Pass SQL parameter to subreport

[pomster]

I have a report with a SQL parameter (Customer). on the report is a subreport also with a SQL parameter (Customer).
Can I pass the parameter from the main report SQl to the subreport SQL?


regards,


David

CRXIR2 with CRXIR2 server and SQL 2005
CR2008 with CR2008V1 Server and SQL 2005

 

[BobSuruncle]

Hi David,
Yes, you can.
Right-click on the Subreport, and select "Change Subreport Links" from the shortcut menu.
In the "Subreport Links" dialog, select the main report's Parameter from the "Available Fields" box
on the left and move it to the "Field(s) to link to" box on the right.
From the "Subreport Parameter Field to use" dropdown, scroll to find the parameter that exists in your subreport.
Don't select the one that starts "?Pm-"

Now the value entered in the main report's parameter will be passed to the subreport's parameter.


Bob Suruncle