Editing Dynamic Parameters for Reports

Procedure

Dynamic parameters are set up when your reports are defined. Dynamic parameters have a data type of character, and the default value has a default value that eCredit uses to calculate the parameter value at run-time. You can edit a dynamic parameter value by changing the default value.

To edit report dynamic parameters:

  1. Select Admin.
    The Admin Home Page appears.

  2. From the Business Administration tab, select Report Setup.
    The Reports Search screen appears.

  3. Enter a name or category to identify the report that has the dynamic parameter you want to edit, and click Search.
    The Search Results section displays the reports that match the information you enter.

  4. Select view/edit in the row for the report.
    The Report Details screen appears.

  1. In the Report Parameters section, select view/edit in the row for the dynamic parameter you want to change.
    The Report Parameter Details screen appears.

  2. In the Default Value field, enter one of the pre-defined parameters using the following format:

[parameter]

You can enter any of the following dynamic parameters:

Parameter Name

Entry in Default Value field

Description

Current Date

[CDD]

Supplies the current system date at run-time to the reporting engine, using the YYYY-MM-DD format.

Current Datetime

{CDT]

Supplies the current system date and time at run-time to the reporting engine, using the format YYYY-MM-DD HH:MM:SS.

Current Week-end Date

[CWE]

Supplies the current system week-end date at run-time to the reporting engine, using the format YYYY-MM-DD. The week is defined to start on Sunday and end on Saturday.

Current Month-end Date

[CME]

Supplies the current system month-end date at run-time to the reporting engine, using the format YYYY-MM-DD.

Last Week-end Date

[LWE]

Supplies the previous week-end date at run-time to the reporting engine, using the format YYYY-MM-DD.

Last Month-end Date

[LME]

Supplies the previous month-end date at run-time to the reporting engine, using the format YYYY-MM-DD.

Any date/time parameter from above plus or minus a number

[Date parameter (+ or - N)] where N is a whole number between -999 and +999 that indicates a number of days. For example, to generate the report for 10 days after the end of the month,  enter [CME+(10)]

Adjusts the date for the specified parameter by the number of days entered.

Current User ID

[UID]

Supplies the currently logged on User's ID as an input parameter for the report.

  1. If necessary, change the Display Label and Is Displayable selection for the parameter. For dynamic parameters, clear the Is Displayable selection if users are ever able to generate the report, and you do not want them to enter values for this parameter.

  2. Click Save.