Make Stored Procedure parameters cascading

building reports crystal reports
1

I don’t have a lot of experience using Stored Procedure as a data source for Crystal Reports. My question is that when you connect to an Oracle Stored procedure which has 2 parameters - Country and City, the parameters are already mapped in Crystal individually. Is there a way i can make these parameters cascading i.e. Country > City, either on front end or backend

Abhi719 :us: (BOB member since 2010-12-10)

2

Use Business View manager.

shamanth (BOB member since 2007-03-01)

3

Not sure you got an answer by now or not but you can create cascading prompts in crystal reports.

Just create dynamic prompts and add country and city as prompts to it and it will show as cascading prompts.

Raj :wave:

Rajasopa (BOB member since 2007-08-22)