Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Same Parameters for Main and Sub report

Status
Not open for further replies.

kamkaro

Programmer
Oct 25, 2006
23
CA
I would like to allow my users to enter 2 parameters (Start and End date) in the primary report and have that parameters be passed in some manner to the sub report.

Ideally, user makes one parameter selection and have that parameter work in my primary report as well as in the sub reports as well.


Any workaround/Steps would be greatly appreciated.
 
This is actually fairly easy.

1. Create the parameters in the main report.
2. Create the subreport, including its parameters.
3. In the main report, go to the Linking Expert and do the following:
a. Select the Start Date parameter in the top-left. Move it to the top-right.
b. In the bottom-right uncheck the option to "Select data in subreport based on field:"
c. In the bottom-left, select the Start Date parameter from the subreport.
d. Repeat steps a-c for the End Date parameter.

This will link together the two sets of parameters.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top