Stored Procedures, Parameters & Subreports 1

[kacie]

I have a main report linked to SQL Stored Procedure with 5 parameters. In the main report I have a subreport linked to a different SQL Stored Procedure with the same 5 parameters. The need for the subreport is so I can get unduplicated counts. Is there any to pass the parameters from the main report to the subreport and not have the subreport parameters appear in the parameter box when the report is run? I would appreciate the help after spinning my wheels on this. Thanks.

 

[synapsevampire]

Try:

http://support.crystaldecisions.com/library/kbase/articles/c2006697.asp

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Naith]

You need to link the main reports parameter fields to the relevant subreport parameters. It sounds as if you're probably linking the main parameters to their {?Pm-...} counterparts in the subreport - which you don't want to do.

You need to use the very small scroll bar (about 0.5 cm high) on the right of the linking window (bottom left), scroll to the actual parameter name, and link on that.

Naith