One parameter for many subreports? 1

[gabster]

Is this possible to have one single parameter that affects multiple similar SUBreports?

Example:

I have a date parameter that lets the user select a date range based on a date field that is existent in all SUBreports (I may have about 8 SUBreports).

I do not want to got through all 8 SUBreports to select the same date range parameter.

Thank you...
Gabi.

 

[chris777]

You add a link to the subreport based on that main report parameter. It will then select the subreport data based on the link.

Is that what you were asking for?

 

[gabster]

Thanks...

Would this work for multiple SUBreports?

 

[gabster]

Here is the problem:

I created a sample main report (main.rpt) that contain 2 similar (mainly quering the same database fields) SUBreports (entity_1.rpt and entity_2.rpt).

Both SUBreports have a date range parameter (called ?DateParam that lets the user select a date range parameter (if they would be stand alone reports).

Now, when I try to preview the main report (main.rpt), in the "Enter Parameter Values" that pops up, I have listed for each SUBreport its own parameter (thing that I do not want) like this:

DateParam(entity_1.rpt)
DateParam(entity_2.rpt)

I would like to have only on parameter in the main report that pasess the same user entered value to both SUBreports.


Hope my problem didn't made you life harder...

Thanks a lot, again.

 

[csm2]

If you link both subreports to main report on ?DateParam, you will only need to enter param once.

 

[gabster]

Thanks.

I just wanted to have the "DateParam" only once and I have it twice (once for every subreport).

 

[kenhamady]

Gabster,

You need to have 3 identical parameters. One in the main report, and one in each subreport. If you then link both of the subreport parameters to the main report parameter, you will only get one prompt, the one in the main report. The other two parameters will automatically take their value from the main report parameter. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com