1. Reports Guide
  2. Adding Report Parameters to Oracle Publisher Desktop

Adding Report Parameters to Oracle Publisher Desktop

The following procedure describes how to add report parameters to Oracle Publisher Desktop.

To add report parameters to Oracle Publisher Desktop

  1. In Oracle Publisher Desktop, open a report template.

  2. Use the following syntax to add a report parameter:

    <?param@begin: Param1>

    For example, you can add the following parameters:

    Param1 = <?$Param1?>
Param2 = <?$Param2?>
Param3 = <?$Param3?>

    For example, you can set Param1 to Active so that if the user chooses Param1, then the report only includes service requests that are active.

    You can use a field that the user specifies to display data rows in different colors. For example, the ACTIVE_STATUS field.

    For important caution information, see Configuring Report Parameters to Filter Data.

  3. Make sure that a definition exists in the Siebel application for the parameter you added in Step 6.

    You must make sure that a parameter definition exists in the Siebel application for each report parameter that you specify, and that the Name property of this definition uses the same value that you specify in Oracle Publisher Desktop, such as Param1. For more information about parameter syntax and usage, see Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher available on Oracle Technology Network (http://www.oracle.com/technetwork/indexes/documentation/index.html) or Designing and Publishing Pixel-Perfect Reports in Oracle Analytics Server available at https://docs.oracle.com/en/middleware/bi/analytics-server/design-publish/index.html.

  4. (Optional) Configure Siebel CRM to display the parameter settings that the user provides.

    To verify that Oracle Publisher receives the correct input, you can configure Siebel CRM to display the parameter settings that the user provides. Siebel CRM can display this information in the report output. This verification does not affect the report layout controls. For example, assume you use the following syntax to define param1 in the report template:

    <?param@begin: Param1?>

    You then add the following code to display the parameter values that the user specifies:

    <?$Param1?>