Stored Procedure Parameter

[Flopper]

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

 

[Naith]

Change your subreport links so that they link on the parameter fields. It's important that the destination for the link is not the {?Pm-?...} equivalent of the parameter name. You must link on the actual parameter name, without the ?Pm prefix. Use the very fiddly scrollbar to find it.

Naith