Siebel Reports Guide > Customizing Siebel CRM Reports > Customizing Reports That Use Parameters >

Guidelines for Defining Parameters in Report Templates


If you define report parameters in a report template, then apply the following guidelines:

  • Siebel CRM sends each report parameter value that a user enters to the Oracle BI Publisher Server as a string. You must make sure that your configuration includes the functions that some data types require so that Siebel CRM can recognize the data type. For example, you can use the canonical date functions to convert a string value to a date value so that Siebel CRM can recognize a Date data type.
  • The minimum and maximum validation (date values entered in a set range) and validation or defaults using date functions, such as Today()-7 and conditional value logic (a display of one parameter that depends on another value) are not currently possible.
  • The Report Parameters virtual business component includes a predefined number of parameter fields, by default. You can create more fields in this business component to add more report parameters for each data type. The following table describes the number of parameter fields that Siebel CRM provides, by default.
    Data Type
    Number of Parameter Fields

    LOV

    10

    Text

    5

    Text Area

    5

    Number

    10

    Date

    5

    Date/Time

    5

    Check box

    10

Siebel Reports Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.