RE: Cascading Parameters

[allyne]

Hi Everyone,

I'm Using Crystal Reports XI with a SQL 2000 Stored Procedure.

I have a report that has all the customer demographic information. At this point there is no grouping on the report. (Very basic)

What I want to do is create a cascading parameter that shows all our locations and when the user selects a location all the users for that location shows in the next prompt. When this happens it will show all the customer information created by that user. For example.

When the dialog promt appears it looks something like this:

Location_1
Location_2
Location_3

When Location_1 is selected it shows:
User_1
User_2
User_3

Or when Location_2 is select it shows:
User_4
User_5

The problems is the when the dialog box appears its only showing Location_1 and not Location_2 and Location_3.

Is it possible to have more then one location in a cascading parameter? If so how can I have all locations appear?

Thanks for all your help!

 

[satinsilhouette]

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.

 

[allyne]

Thanks for your response! I gave it a try and came up with the same results. It does give the cascading effect but doesn't show all the locations. It only shows the first location. Any other suggestions?

Thanks so much for your help!

 

[satinsilhouette]

Let me ask you this, are all the locations fields in the same table? Or are you trying to use 3 different tables to make the location prompt?

Do you have any select criteria that is preventing the other locations from coming through?

 

[allyne]

Hello,

All Locations are in one table and there are no other select criteria that is preventing the other locations from coming though. I'm wondering if I need to reinstall Crystal or my report is corrupt. I do have another report that I created that's using the cascade parameter and it seems to be working. Not sure why this report won't work. Any thoughts? Thanks for your help!

 

[Madawc]

I use Crystal 10, not 11, but I think you are asking it to do more than it is designed for.

You could get the same effect by grouping on location and then choosing Hide (drill-down OK for the user details.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[IdoMillet]

Set the parameter definition to allow multiple values.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[allyne]

Hi,

Thanks for all your help and suggestions. I'll give it a try.

Thanks again for your help!