Home > Archive > MS SQL Server Reporting Services > November 2005 > Passing parameters to subreport









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Passing parameters to subreport
Shan

2005-11-28, 1:23 pm

I have a report with only two parameters input by user @startdate and
@enddate. On my Subreport I use the same parameters. How can I make the
subreport run by taking the user input on the main report and passing it to
the subreport so it can run too.

Any help is appreciated.

Thanks
Nick P.

2005-11-28, 1:23 pm

You should be able to use the Properties for the subreport, go to
"Parameters" tab and specify the values for the subreport parameters using
the parameters from the main report(Parameters!st
artdate.Value and
Parameters!enddate.Value).

"Shan" wrote:

> I have a report with only two parameters input by user @startdate and
> @enddate. On my Subreport I use the same parameters. How can I make the
> subreport run by taking the user input on the main report and passing it to
> the subreport so it can run too.
>
> Any help is appreciated.
>
> Thanks

Shan

2005-11-28, 8:25 pm

Nick,
I cant seem to work it thru. I right click the subreport then properties
then Parameters tab. When I click inside the Parameter Name I see both
StartDate and EndDate. Where should I put these valuse that you have
provided me?

Thanks

"Nick P." wrote:
[color=darkred]
> You should be able to use the Properties for the subreport, go to
> "Parameters" tab and specify the values for the subreport parameters using
> the parameters from the main report(Parameters!st
artdate.Value and
> Parameters!enddate.Value).
>
> "Shan" wrote:
>
Nick P.

2005-11-28, 8:25 pm

Variables under the "Parameter Name" column are the names of the parameters
used in the subreport. Use the "Parameter Value" column to match them up
with the appropriate parameters used in the main report(click on drop-down,
select <Expression...>. in "Edit Expression" dialog..click and expand the
"Parameters" on the left pane, then select the appropriate parameter value
(from the main report). Hope this helps.

"Shan" wrote:
[color=darkred]
> Nick,
> I cant seem to work it thru. I right click the subreport then properties
> then Parameters tab. When I click inside the Parameter Name I see both
> StartDate and EndDate. Where should I put these valuse that you have
> provided me?
>
> Thanks
>
> "Nick P." wrote:
>
Shan

2005-11-28, 8:25 pm

GREAT!!!. Works like a champ.

Thank You!

"Nick P." wrote:
[color=darkred]
> Variables under the "Parameter Name" column are the names of the parameters
> used in the subreport. Use the "Parameter Value" column to match them up
> with the appropriate parameters used in the main report(click on drop-down,
> select <Expression...>. in "Edit Expression" dialog..click and expand the
> "Parameters" on the left pane, then select the appropriate parameter value
> (from the main report). Hope this helps.
>
> "Shan" wrote:
>
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com