Cascading Prompts

[TheGoldMineGuru]

BOEXI on MSSQL2000

Datasource: OLEDB - Stored Procedure
Parameters: ?City, ?ZipCode

I built a Stored Procedure for a specific report. There are two prompts, City and ZipCode. If you choose a City, I want the drop down for the ZipCode to only be those associated with the City as found in the database. I know this is a Cascading Prompt. The stored proc has both of these parameters specified, and the Cascading prompt needs to match up to them for both City and ZipCode (not just the ZipCode).

I have built a cascading prompt within BusinessViews, but I cannot associate it with my stored proc parameters successfully.

Can this be done or do I need to create a BusinessView based on my Stored Proc and then link to that in Crystal? At the moment, I'm linking the stored proc directly within Crystal, then pointing to the LOV for the parameters. Seems messy to me.

Thanks!

 

[TheGoldMineGuru]

Seems like there may not be a way to do this. I changed my Stored Proc to only include the @City parameter. The cascading prompt is bound to that one, where the second one is bound to a Crystal parameter, ?Zip. It actually auto names it, "?City -zip", which tells me that you couldn't bind to an existing parameter, such as one from a Stored Proc. This takes processing away from the server, but I don't see any alternative.

Thanks for anyone who gave this some thought