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 with Stored Procedure asking for parameters

Status
Not open for further replies.

MisterMo

Programmer
Mar 18, 2002
564
GB
Hi guys, This is the question

Using CR10 and SQL2K

I have a report which use a SP with parameters
there ia also a SubReport.. well 2 actually, and they both use a SP with a single parameter each.

I have tried various type of linking

such as {subreport.Parameter} = {MainReport.Parameter}

or {Subreport.FieldValue} = {MainReport.Parameter}

or {Subreport.FieldValue} = {MainReport.FiledValue} and
{subreport.parameter} = {Subreport.FieldValue}

where Parameter = SP.Parameter

no matter what I do when I run the report it keeps asking me for the SP.Parameter from the Main report and the 2 Sub Reports.

am I doing something wrong somewhere along the line or it just cannot be done???


Thank you in advance for your help


Mo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top