Skip to Content

How to set only one Parameter

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Dec 11, 2018 at 07:30 AM

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

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • 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..

  • Dec 10, 2018 at 05:38 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

      subr.jpg (24.5 kB)
  • Dec 11, 2018 at 01:53 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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