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!

Subreport Stored Procedure Parameter

Status
Not open for further replies.

Flopper

Technical User
Jan 19, 2001
140
AT
Greetings,

My report contains two different parameterised SQL stored procedures, one in the main report and the second in a subreport.

Each stored procedure requires two parameters, a date and a text field. Therefore upon refresh I am prompted for four parameters, two date and two text prompts.

However, and this is where the problem arises, I require only one date and one text as both dates will be the same value, as will the text.

Is there any way in which i can force the stored procedure of the subreport to accept the parameters inserted into the main report.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top