Subscriptions --> Sub reports with parameters

[davida37]

SQL server 2005
SSRS

Hi,

I have a report with 1+ sub reports. I need to schedule this report - and select default parameters values for teh main report and sub reports. When you go into subscriptions - it only allows you to select a value for the main report and not the sub reports. Is there a way around this?

Thanks
David

 

[davida37]

Or can I do this by passing a parameter value or text box value from the main report into the sub report? - If so what expression do i use?

Thasnk

 

[MColeman]

In this case, couldn't the subreport be linked to the main report using a field value in the main report?

The subreport is in the list data region of a main report.

In the subreport properties, parameters tab, use a parameter to associate the subreport with the main report list data region by setting the parameter value
to a field in the main report.