I am building a Crystal Report that will be called from an ASP page. This is currently being designed in VS2005 with CR2008. (CR is up to date.) I have not created the Windows Installer for the project yet, since its still under development. I am only viewing the Web Pages and Reports via the VS2005 Debugger.
This Web Site has dozens of CR Reports, but with this particular one, I want to add Cascading Parameters to allow the user to zero in on the information they want returned. Cascading Parameters seems like a straightforward concept.
However, if I add more than two layers of parameters and debug the website and go to the report. The drop down to pick the first layer only lists the first entry. Now, if I remove some of the layers, so there are only two layers, the drop down is properly populated.
Here it is with more specifics. This is for telephony, but you should get the gist.
Parameters I want to cascade:
Region (East, West, Central, Rochester)
State
Host Switch
Trunk Group number
If I build a Cascading Parameter as above, the drop down only shows: CENTRAL (which alphabetically would be first in the list)
If I remove the levels of: "Host Switch" and "Trunk Group Number", the drop down from region shows (CENTRAL, EAST, WEST, ROCHESTER) as expected.
If I add back "Host Switch" and "Trunk Group Number" into the cascade of parameters, it goes back to just showing CENTRAL. Even if I add just "Host Switches", the other Regions seem to vanish from the drop down choices.
I am stumped because, as I said, the concept of Cascading Parameters to a CR seems straightforward. I have made literally hundreds of Crystal Reports for ASP pages before, but now as I review them, I never had a report with more than 2 cascading parameters. Every forum and book I have read on cascading parameters tells me that you can have virtually infinite cascading parameters.
Please help!
IP Logged
