I can pass parameters via a querystring to a Crystal Report rather easily using ASP.
However, is there a way to use one of those passed parameters as the first Parameter of a Dynamic Cascading set of Parameters?
Example:
I have an ASP Button. It passes a parameter Company Name via a querystring entry named webCO to a report.
In the report this Parameter is named ?webCO.
Now when the report loads, I want the selection screen to come up so the user can choose the Cascading Dynamic Parameters.
Regions
Districts
Sales
But, of course, I only want the user to see the Regions in the webCO (Company), as if the webCO was actually at the top of the Cascading Parameters.
I get the CO to equal the webCO as a Filter.
And I can build the Cascading Parameters with its corresponding Filters.
But, when the User fills in the parameters, they see all the Regions regardless of whether they are in the Company Name or not.
Is there a way to tie them together? The end report works, but not as I imagine it should. It shows the users options that I would like filtered down by the incoming querstring Parameter.
IP Logged
