Linking Reports via Parameters

[CappsRLO]

I have a main report which I have created a StartDate & FinishDate as Report
Parameters. They are not hidden so the user has to enter these 2 dates to
run the Report. I have another Report which Displays a second subset of data
which also use the same 2 Parameters prompting the user to enter the dates.

I chose a field in my Main Report where I modified the Navigation Properties
to point to my second report when clicked on. The Report runs fine but I
have to re-enter the second set of date values in my linked report.

How do I pass my date parameter from my main report to my linked report so
the user does not have to enter them a second time but the report runs based
off the date values entered in my Main report?

 

[xlbo]

In the navigation properties, next to the drop down box where you select the report to jump to is a button labelled "Parameters". Click on that and set the 2nd reports parameters equal to the 1st reports parameters

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question