Cascading prompts

[griffter]

Hi All

I am trying to use cascading prompts in a report but am having an annoying blip. I want to select a country or countries, which gives me a list of available sites for those countries, I then want to select the sites and the materials available for that site. However the available materials contains duplicates because the same materials are available across multiple sites.

Although it will only let you select the material once it does not look right in the parameter window:-

Select Materials:

Material 1
Material 2
Material 1
Material 3
Material 2 etc

How do I remove the duplicates???

 

[Madawc]

Group by Material. Suppress the detail lines, showing just the group header

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

 

[IdoMillet]

Since this is a parameter, the idea of grouping would not work.

Here is a tech document about this problem:

http://support.businessobjects.com/library/kbase/articles/c2017769.asp

Cheers,
- Ido

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

http://www.MilletSoftware.com