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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting a Subreport with store procedure to the Main report

Status
Not open for further replies.

pattid

Technical User
Sep 16, 2003
9
US
I have a subreport that has store procedure parameters that I want to link to the main report. These stored procedures parameters are:
BegPer
Endper
Right now when I insert the subreport and then refresh the report it prompts me to choose date parameters for both the main and the subreport. I want to link the reports in a way that I will only be promted once to enter date parameters. No one else here in the office has ever experienced this so I was hoping someone could shed some light on it. Thanks!!
 
Right click the subreport you want linked to your main report and select Change Subreport Links...

From there, select the fields in your main report that you want linked to your subreport and move them to the Field(s) to link to:. Then, select the appropriate parameter fields from the drop down list ( ?<parameter> ).

 
That worked!!! Thanks for your help, I really appreciate it!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top