How do I setup read-only Default Parameter values for MS Access reports in MARS?

The Default Parameters tab allows you to set up read-only default values for specific parameters that you can then assign to any of your schedules.

Options - Default Parameters

  • Go to Options.
MS Access: MARS Home Menu.
  • Select Default Parameters.
MS Access: Default Parameters section in Options in MARS.

The Default Parameters tab allows you to set default values for specific parameters that you can then assign to any of your schedules.

Default Parameters are useful for MARS environments where users are assigned schedules with specific parameter settings that need not be tampered with.

Creating a Default Parameter

To create a default parameter, perform the following:

  • On the Default Parameters tab, enter the name of the parameter in the Define parameter - Name field.
MS Access: Default Parameters section in Options in MARS.
  • For the value, choose one of the following options:
  • Ignore the parameter specified.
  • Set its value to Null.
  • Set it to a value you specify in the Value field.
You can also drag and drop values from the inserts menu (i.e. date parameters or data items) into the Value field.
MS Access: Default Parameters section in Options in MARS.
  • Once you are satisfied with the parameter name and value, click the Check mark to add it to the Default Parameter list.
MS Access: Default Parameters section in Options in MARS.
  • Repeat steps 1-3 for the remaining parameters you wish to set.
  • Once you have finished entering in parameters, decide if you would like administrators (or those with similar admin rights) to be able to edit the default parameter values you just set.
  • If you do, check the box next to Allow Administrators to change these values on the parameters screen.
  • If you would like to apply these default parameter values to all your currently existing schedules, click Apply to Existing.
MS Access: Default Parameters section in Options in MARS.
  • Click Yes.
MS Access: Default Parameters section in Options in MARS.
  • Click OK.
MS Access: Default Parameters section in Options in MARS.
  • Click Apply.
  • When reports are added to schedules, the parameters specified will now automatically have the default values you configured.