asked on

Passing one parameter to multiple subreports

Experts,

I'm developing a report that uses subreports. I need to pass a "common" date range that the user will enter once to each of the subreports to be used as a select statement.

I know how to add parameters to the subreport and include them in the subreport select expert but because the date range is always the same - my client only wants to add the date range once.

Can you help? What's the easiest way?

Thanks in advance

Steve

Mike McCracken

Add it to the main report and link the subreports to the main report using it.

mlmcc

SStroz

ASKER

mlmcc,

I tried that and the parameter from the main report wasn't available inside the subreport. I'm trying to use the Select Expert in the subreport. Where do I look?

Steve

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SStroz

ASKER

mlmcc,

I tried your instructions and it doesn't seem to be working. In the main report I have a static date parameter. It doesn't seem like I can use that as a link to the subreport.

I tried creating a similar parameter in the subreport and linking to it - but that didn't work either.

Any ideas?

Steve

SOLUTION

frodoman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike McCracken

Glad i could help

mlmcc