Hi,
I have Report1 that uses storedproc with parameter and it works fine.

I have another Report2 that also uses storedproc with parameter and it also works fine.

Now, I want Report2 to be merged to Report1 as subreport. When I inserted a subreport to Report1 and selected Report2 as subreport, the application now throws "Missing paremeter field value". I guess the parameter value I passed to Report1 was not passed to Report2. Although they used different storedproc, the parameters they require are the same.

Does anybody here knows how I can pass the value of the parameter to Report1 (main report) and Report2 (subreport)? As I mentioned, the reports use two different storedproc but the storedproc requires the same parameter. Thanks in advance.

In your application you need to create a subreport object from the ReportDocument object and pass the parameters to it.

Hi,
What do mean by "create a subreport object from the ReportDocument object and pass the parameters to it"?

I hope u can give a bit more of details how to do this. :)

Again, my problem is how to pass a parameter to the stored proc of the sub report. My code goes like this:

Dim p1 As ParameterField = Me.CrystalReportViewer1.ParameterFieldInfo(0)
        Dim p1value As New ParameterDiscreteValue
        p1value.Value = myVariable 'the variable contains the value to pass
        p1.CurrentValues.Add(p1value)

This works, and can pass a parameter to the Main Report. My problem is, how can I pass a value to the parameter of the Sub Report. Thanks a lot for the reply.

Hi

If u got the soln for passing parameter to subreport please post it here.

I need it badly.

Thank you

All the information you need is here...
http://devlibrary.businessobjects.co...dk_net_doc.chm