How to set only one Parameter

[former_member580112]

Hello,

I have one master report, which has many sub-reports and each subreport has a parameter. So when i run master report it ask the parameter value for each subreport (Which will be the same month end date), So is it possible to setup a one parameter for the master report that will feed the value to each subreport? If so, can you please help as how to do it?

Also, on demand my user wants to run those subreport stand alone as well. so when they run any sub report it should prompt for that parameter.

Any help would be appreciated.

Thank You.

[abhilash_kumar]

You'd need to setup the parameter in the Main Report first.

-Abhilash

[former_member580112]

Hello,

Now I have created the parameter on the Main Report. Now my each sub-report is based of a "Command" and has following condition

where MonthEnd={?MonthEndDate}

For that you mentioned "If the Subreport is based off of a Stored Proc/Command and if it contains the prompt in the Command Source, you'd select the option at the bottom left that says "subreport parameter field to use" and choose the parameter from the drop-down."

I need to set up this for each sub-report? If so, where can I find this option "subreport parameter field to use" ? and what should I setup in my query for the where clause?

Thanks again..

[former_member580112]

Hello,

I see "subreport parameter field to use" is on change sub-report change link. Do i have to change this option for each sub-report? as I have about 15-18 sub reports on the main report.

Thank you.

[abhilash_kumar]

Yes this needs to be done for each Subreport.

You're essentially passing the prompt's value from the Main Repor into the Subreport's Command prompt.

-Abhilash

[former_member580112]

Thanks for your reply. Still one thing is not clear that what should I set in my query for the where clause in each sub-report? As currently it is setup

where MonthEnd={?MonthEndDate}

Thanks..

[abhilash_kumar]

I guess you've already set it up properly.

All you have to do is link the prompt in the Main Report with the {?MonthEndDate} prompt from the Subreport.

When you go to "Change Subreport Links", move the Month End Date prompt from the Main Report to the pane on the right and then you should see the corresponding Month End Date prompt from the Subreport in the "Select subreport parameter field to use" drop-down.

-Abhilash

[abhilash_kumar]

Hi Dax,

Right-click the first Subreport > Change Subreport Links > Move the parameter field to the pane on the right.

If the Subreport is based off of a Stored Proc/Command and if it contains the prompt in the Command Source, you'd select the option at the bottom left that says "subreport parameter field to use" and choose the parameter from the drop-down.

If the Subreport is created directly against the Table/View, you'd select the option to the bottom right and select the corresponding field from the drop-down. This automatically inserts a Record Selection Formula inside the Subreport. So, you'd also have to delete the parameter from the Subreport as it's no longer needed.

-Abhilash

[former_member580112]

Thanks for your reply. So per instruction I selected the 1st subreport in master report and selected "Change Subreport Links", as you can see from image below that there is "Report Fields" but it does not allow me to move.

So am I missing something here?

Thanks again.