Designing Parameters

Your report definition parameters collection must define a unique parameter entry for each parameter sent to the reporting tool. The sequence of your parameters must match the sequence defined in your reporting tool.

Continuing with the Tax Payables Analysis report as an example, let's look at the parameter definitions.

Parameter Code Description Char Type Default Value
P_​FROM_​DT From Date CI_​DATE N/A
P_​TO_​DT To Date CI_​DATE N/A
P_​CHAR_​TYPE Account Type Characteristic CI_​CHTYP CI_​GLTY
P_​TAX_​ACCTY_​CHAR Account Type Char Value for Tax Related GL Account CI_​GLTY LT-Liability/taxes

Highlights for some of the above settings:

  • The from date and to date parameters use the same characteristic type.
  • The characteristic type parameter is defined with a default value pointing to the GL account type characteristic type.
  • The GL account type parameter defines the liability/taxes account type as its default value.
Note: User Id. The sample reports provided by the system pass the user id as the first parameter passed to the reporting tool. It does not need to be defined in the parameter collection for the report.