Using main report field as parameter for subreport with stored procedure
Posted on 2003-11-07
I'm starting to fear this can't be done, but I haven't lost hope yet...
I have a main report without any parameters, as designed. I need to link in a subreport whose data is derived from a stored procedure with 2 parameters. I would like these parameters to be linked to 2 fields in the main report. However, when I try to create the subreport off the stored procedure it prompts me for the two input parameters, for which I must enter values in order to add the stored procedure. Once that is done, I am unable to link the parameters to fields in the main report. In addition, the main report prompts me for the parametes for the subreport when refreshing.
Is there a way to make the subreport link to two fields in the main report and not prompt the user to enter a value?