Home Discussions Questions & Answers Saving frequently used parameter input

Saving frequently used parameter input

Avatar photoCustomer August 9, 2023 at 5:22 pm

I run the same report multiple times a week using the same ‘Operating Unit’ and ‘Date Range’. How can I save these values so they populate automatically?

Viewing 6 reply threads
  • Author
    Replies
    • Support August 11, 2023 at 4:08 am  

      You can store your personalized default parameter values using the menu option Actions > Save User Parameter Defaults. These saved values will automatically populate the parameters the next time you open that report.

    • Avatar photoCustomer August 11, 2023 at 10:52 am  

      We have two templates for this report—one for monthly data and one for weekly data. Can I save different default periods for each template?

    • Support August 12, 2023 at 7:53 am  

      Yes, once a template is selected, you can store default parameter values specifically against that template. Use the menu option Actions > Save Template Parameter Defaults. This ensures that the relevant defaults load when the template is chosen.

    • Avatar photoCustomer August 13, 2023 at 11:32 am  

      Which default takes precedence if both a User Default and a Template Default are saved?

    • Support August 14, 2023 at 11:27 pm  

      The system would typically load the most specific default. If you select a template, the Template Parameter Defaults would likely override the general User Parameter Defaults for those specific parameters.

    • Avatar photoCustomer August 15, 2023 at 7:41 am  

      Is there a way for developers to set default values using dynamic SQL?

    • Support August 17, 2023 at 6:10 am  

      Yes, a developer can define a Default Value for a parameter. If the value starts with the keyword ‘select’, Blitz Report executes the SQL to derive the default value dynamically instead of using a fixed value. For instance, `select to_char(sysdate, ‘MON-RR’) from dual` to get the current date.

Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with: