I'm fairly new to Crystal Reports, so this is probably easy, but I'm having trouble figuring it out.

I have four stored procedures I'm trying to incorporate into one report.  They are similar to:

CityList(State) - returns list of cities in State
SubdivisionList(City) - returns list of subdivisions in City
StreetList(Subdivision) - returns list of streets in Subdivision
HouseList(Street) - returns list of houses on Street

When I run the report, I want to provide one parameter - State - and have the stored procedures joined to provide all the info.  So, for each city returned by CityList(State), SubdivisionList(City) should be called to retrieve that data.  I realize this is impractical, but is it possible?  If so, how do I do it?  Since there are 4 layers, subreports aren't possible.

I would alter them into one stored proc but our DBA doesn't like there being a stored procedure that could return all Houses in a particular State.  (Just an example, my dataset is actually much smaller.)

Thanks!

Brian,

Thanks for your help.  I'm not sure that DCPs are actually what I'm looking for as the user won't be giving further input into which city, subdivision, or street they are looking for.  The issue the DBA has is that he doesn't want a single procedure to return so much data for security purposes. 

In the example I used above, he wouldn't want a single stored procedure to return

State | City | Subdivision | Street | House #

as that gives someone knowing a state code essentially a data dump of a ton of info.

What he would want is one proc that returns all the cities for a state.  Then a proc that returns all the subdivisions for a city would have to be called once for each city.  Then a proc that returns the streets would have to be run once for each sub in each city.  Eventually way too many calls are made to the database and every house # in the state is returned, but it is "stronger" security-wise as there is no single call that returns all the data. 

Perhaps I am just misunderstanding DCPs, so let me know if I am.

Thanks!