I have a situation with parameters that I need help with. I am using Crystal XI (v 11.5.3.417), with SQL Server 2000 database.
I have a report whose main datasource is a stored procedure, and secondary datasources that are Crystal Command objects, used as lookups to get distinct lists of values. I have 2 lists of values (Department and Team), that populate the drop-down lists for cascading prompts. I also have 2 static date parameters used to allow the users to filter the data within the timeframe they choose. When I first created the report I had the date parameters as parameters in the SP, and the dept and team parameters sitting on the report.
This caused double-prompting of the date values because as the report opened it went immediately to the SP and I got prompted for the dates. The resulting dataset was returned to the report, and as it continued to open it saw the dept and team parameters, so it requeried the datasource (forgetting it's first retrieval of data), and included the date parameters again in the second set of prompts.
My solution to this was to create the separate lists of values for department and team, add parameters for those 2 values to the SP, remove all of the parameters from the report, and run 'Verify Database', which recreates all 4 parameters on the report. That was the only way to get the SP to 'see' the dept and team parameters. All of this works fine except I need dept and team to be cascading. The method I used to create the parameters on the report creates each of them as separate parameters, not related to each other like when you create cascading prompts in the normal fashion. I don't know how to make the team drop-down dependant upon the dept choice when they are completely separate parameters.
In thread thread766-1258135 , satinsilhouette talks about a way to get parameters to cascade:
"Try going back into your parameter and then binding all three together by clicking in the parameter box next to each of them. This gives you the cascading effect."
I am not sure what is meant by that.
Does "going back into your parameter" mean the parameter edit window?
"clicking in the parameter box" - what is meant by that?
I have a report whose main datasource is a stored procedure, and secondary datasources that are Crystal Command objects, used as lookups to get distinct lists of values. I have 2 lists of values (Department and Team), that populate the drop-down lists for cascading prompts. I also have 2 static date parameters used to allow the users to filter the data within the timeframe they choose. When I first created the report I had the date parameters as parameters in the SP, and the dept and team parameters sitting on the report.
This caused double-prompting of the date values because as the report opened it went immediately to the SP and I got prompted for the dates. The resulting dataset was returned to the report, and as it continued to open it saw the dept and team parameters, so it requeried the datasource (forgetting it's first retrieval of data), and included the date parameters again in the second set of prompts.
My solution to this was to create the separate lists of values for department and team, add parameters for those 2 values to the SP, remove all of the parameters from the report, and run 'Verify Database', which recreates all 4 parameters on the report. That was the only way to get the SP to 'see' the dept and team parameters. All of this works fine except I need dept and team to be cascading. The method I used to create the parameters on the report creates each of them as separate parameters, not related to each other like when you create cascading prompts in the normal fashion. I don't know how to make the team drop-down dependant upon the dept choice when they are completely separate parameters.
In thread thread766-1258135 , satinsilhouette talks about a way to get parameters to cascade:
"Try going back into your parameter and then binding all three together by clicking in the parameter box next to each of them. This gives you the cascading effect."
I am not sure what is meant by that.
Does "going back into your parameter" mean the parameter edit window?
"clicking in the parameter box" - what is meant by that?