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

Date Parameter pass from main to sub report 1

Status
Not open for further replies.

dazum

Technical User
Apr 6, 2011
57
US
I am using CR 11
I have a Begin date parameter in the main report used for a field called Decision_Date. I use a sub report to get a field called Status_Date. I want to get any Status_Date that is >= the Decision_Date from the main report. In order to get get the correct Status_Date, I also have a date parameter in the sub report, which is exactly the same for the Decision_Date parameter in the same report.
When I prompt for date parameters there are 2 Begin date parameters (one for the main report, and one for the sub report). Can I do something so I am prompted only once for the Begin date since the parameter for the Decision_Date and the Status_Date are the same?
 
In the subreport linking dialog box. Drag parameter from main report into linking pane.

In lower left corner click on scroll bar and find the Sub Report Parameter and link

You will now only be prompted once

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top