asked on

Report with unlinked subreports has duplicate parameter selection

I have a main report and three unlinked sub-reports, all appearing on a single page. Each of the four reports should have the same parameter selection, which are for fiscal year and for combination Fiscal Year and Period (1 to 13 per year). When I run the report, the dialog box for parameters ('Enter Values') shows the two selections I want, with the source at top right (which are [0P_FYEAR] and [UOSVPER]. After adding the sub-reports, now I get an additional selection of parameters for the year and year-period. For the year it shows the source as [0P_FYEAR](name of first sub-report)/[0P_FYEAR](name of 2nd sub-report/[0P_FYEAR]/(name 3rd sub-rpt). It is similar for the year-period selection. Thus I have four parameters to select when I only want two. How can I get rid of the extra parameter selection in the dialog box?

SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dwabbott

ASKER

That would make the sub-reports linked rather than unlinked, wouldn't it? Would I have to return to where I insert a sub-report and start over, specifying linked?

SOLUTION

vasto

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dwabbott

ASKER

I tried the linking as you suggest but no change. On the design view of the main report, I right-clicked on each sub-report, went to Change Subreport Links, and inserted the two parameters to Fields to link to. There are two further choices to make: Subreport parameter field to use and Select data in subreport based on field:
What should I be doing here, if I am in the right place?

SOLUTION

Kurt Reinhardt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dwabbott

ASKER

Success! After a few false starts, I now have only the two parameters showing. Excellent! Now the hard part, the points, but here goes:
mlmcc 250 for the most details that I needed; robert 100 for the first correct solution, vasto and rhinok 75 for also having the correct solution. Thanks to you all for your help!