Run Parameters on subreport and main report - Crystal XI

[ReillyC]

Good evening folks,
I have a bit of challenge.

I used a subreport to concatenate a list of values (i.e. countries for each application)
This reads that we filed Application01 in USA, France and Great Britain.

Application01 - USA, FR, UK
Application02 - USA, CN, JP
Application04 - CA, MX, TW

Then I have my main report which has a report template for each Application number and then I place the subreport info into my main template next to the countries text field. This works great.

Application01
Countries - USA, FR, UK (subreport)
Product Class - TV

Application02
Countries - USA, CN, JP (subreport)
Product Class - VCR

Application04
Countries - CA, MX, TW (subreport)
Product Class - DVD


I want the user to be to use parameters on both the main and subreport.

I want the user to select the countries they want first via a parameter and then be able to select and an "OR" option the the product class.

So a list of countries would be selected, then the user could select from a list of product classes but it would be an or statement rather than a "and" statement.

I hope this is clear.
Is this possible?
Any help is appreciated.

Thanks.

 

[synapsevampire]

So you want to select countries OR select Product Classes, but not both? So if they select a country, products will be ignored, and vice versa?

Are you using dynamic cascading parameters?

Here's the whitepaper on creating them.

If you need additional help, please clarify the requirements a bit.

-k

 

[synapsevampire]

Sorry, here's the whitepaper:

http://support.businessobjects.com/...ers/cr_xi_dynamic_cascading_prompting.pdf.asp

-k

 

[ReillyC]

I try what you suggested. I will let you know if it works for me. Thanks

Cheers
R