Subreport Parameter for Stored Procedure 1

[jkercheval]

I have a report that contains a subreport. Both the report and the subreport show information by calling a stored procedure. Both stored procedures require a parameter to be passed. They both need the same input (which is a part number). Is there anyway I can auto-populate the subreports parameter with the inputted partnumber so it does not have to be put in twice when the user runs the report? I am using Crystal 8.5 developer's edition.

 

[lyanch]

Yes. In "change subreport links" (right click on subreport) make certain the "select data based upon a field" is not selected.

select the paramter field from the main report then on the lower left hand side under subreport parameter to use, scroll until you get the stored proc parameter in the subreport. The scroll bars are tiny.. but they do work.

Lisa

 

[jkercheval]

Thanks for the info. Would you believe I started to do that and didn't follow through? Your response was a great help.