Pass parameters to a stored procedure in a Crystal Report sub report?

Question

I have a Crystal Report, that is populated with a stored procedure, it also contains a sub report, that I am trying to populate with another stored procedure ... same parameters. I cannot figure out how to pass the parameter value to the sub report.

Any help would be appreciated!

Answer 1

When you add the stored proc to the sub-report CR will add the parameters automatically. Then when you set up the sub-report links you link the main report parameters to the sub-report parameters.

Answer 2

Sounds all so simple, but unfortuanate it isn't that simple. I can link the parameters from main to sub -report, no problem. But when it comes to feeding it to the subreport procedure parameters it becomes rather difficult.

I'm using Crystal XI. Same procedure main and subreport. The aim is to let the user select the parameters only once. Currently, the user needs to select the parameters for both main and sub report.

Ok, I over-read the comment where to find the dropdown. The drop down is in the screen subreport links. On the botton there are 2 dropdowns, use the one on the left.

Answer 3

You can pass value to sub report like this:

oRpt.SetParameterValue("@InvNo", Session("InvoiceNo"), "rptInvoicePrintSub") ' parameter for subreport