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

Hello, I have a main report and a

Status
Not open for further replies.

allyne

MIS
Feb 9, 2001
410
0
0
US
Hello,
I have a main report and a few sub-reports as links. All reports use the same stored procedure. The stored procedure uses start_date and end_date parameters within the stored procedure. what I would like to do is have the user enter the date parameter once for all sub-reports. what I'm seeing is the date parameters for each sub-report. In the subreport links on the lower left side I see ?@Start_Date and ?@End_date. This looks good but on the right hand side I'm not able to select data in subreport based on field. Its greyed out. Is this correct?
 
Create date parameters in the main report and the sub-reports and link via the parameters.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top