Siebel Reports Administration Guide > Configuring Parameterized Reports > Configuring Parameters for Reports >

Creating the Parameterized Reports in Actuate e.Report Designer Professional

Make sure you have installed Actuate e.Report Designer Professional from the DVD-ROM. Since the report design process is similar to any other report, only the design specific to a parameterized report is described in this topic. The general process in designing a parameterized report includes two main steps:

  • Creating parameters and referencing the parameters where they are used.
  • Additionally, certain report methods to be modified using Actuate e.Report Designer Professional to pass the parameter values selected or entered by the Siebel applications user.

The first step is generic to all parameterized reports. The second step is specific to Siebel parameterized reports and is described for the Revenue Analysis Summary report.

When Revenue Analysis Summary report is run from a Revenues screen, the parameter screen appears after the report is selected from the Reports menu or after the schedule parameters are entered with the Schedule Report option. The user needs to select a value for each of the three parameters from the drop-down lists before clicking Finish.

The report is then generated and displays the first parameter field (which is the grouping field) in a cross tab format with the second parameter in aggregated date scale along columns, and the third parameter as rows. Therefore, this report is essentially a cross tab report (for more details, see Using Reports with Group Sections in this book with the displayed field selected by the user at run time. The second parameter defines the columns and the third parameter defines the rows.

To set report parameters

The report process parameters are set by the user in the client in the following order.

  1. In the top-level report object. store language dependent parameters fetched from the report ROV file (in the Start() method of root node 'revd') as global variables.

    Sub Start()


          ' get language values from user entered parameters





    End Sub

  2. Get the language independent codes for the parameter values selected by the user from the LOV table.

    ThenParameter = represents a group key.

    ValueParameter = represents a metric key.

    ByParameter = represents a date key.

    These values are necessary to support internal report logic that is language independent. The parameter retrieval is based on the ssSmart.rol library custom DataStream control ssList_Of_ValuesQuery (select ssSmart.rol from Library Organizer menu, double click on ssList_Of_ValuesQuery, and select Class tab).

    Modify the control methods Start() and Fetch() to set a search specification dynamically and store retrieved parameter language independent values.

    Function Start() As Boolean

    Dim DateSt as String

    Dim ValueSt as String

    Dim ThenSt as String

    ' create Search Spec date portion based on LOV or default '

    ' value

    if revdet::ByParameterV <> "" Then

    DateSt = "[Value] = '" & revdet::ByParameterV & "'"


    DateSt = "[Name] = 'Month'"

    end if

    ' create Search Spec Value portion based on LOV or default '

    ' value

    if revdet::ValueParameterV <> "" Then

    ValueSt = "[Value] = '" & revdet::ValueParameterV &"'"


    ValueSt = "[Name] = 'Revenue'"

    end if

    ' create Search Spec Then portion based on LOV or default '

    ' value

    if revdet::ThenParameterV <> "" Then

    ThenSt = "[Value] = '" & revdet::ThenParameterV & "'"


    ThenSt = "[Name] = 'Account'"

    end if

    ' dynamic search spec

    SearchSpec="[Type] = 'REVN_FUNCTIONCAPTIONS' AND " & ValueSt

    + & " OR [Type] = 'REVN_SERIESCAPTIONS' AND " & ThenSt

    + & " OR [Type] = 'FCST_INTVL_PERD_TYPE' AND " & DateSt

    Start = Super::Start( )

    End Function

    Function Fetch( ) As AcDataRow

    Dim aRow As ssList_Of_ValuesDataRow

    Set Fetch = Super::Fetch( )

    If Fetch Is Nothing Then

       Exit Function

    End If

    set aRow = fetch

       Select Case aRow.ssValue

       case revdet::ByParameterV


       case revdet::ValueParameterV


       case revdet::ThenParameterV


       End Select

       End Function

  3. Use date parameter ByParameterV to set a search specification for ssPeriodQuery data stream from revper.rol. As a result Period business component returns only period record of specified type (day or month or quarter or year).

    Sub Start( )

    Super::Start( )

    ' set search spec to get only needed period type records

    ssReport::ssSearchSpec = "[Period Type]='" &

    revdet::ByParameterV & "' "

    End Sub

  4. Use ByParameter and ValueParameter parameter values to fill out revenue Line Item record dynamically. The purpose is to create a list of revenue records that are independent of user parameters to make sure that general logic works correctly. Later, line item records are stored in a memory list for further aggregation.

    Function CreateUListRow(Rec as acDataRow ) as uListRow

    Dim uRec as uListRow

    Dim aRec as ssRevenueDataRow

    dim CurrentSection as integer ' put into root

    ' calculate section key and UnitKeyStat


    Set aRec = rec

    set uRec = New uListRow

    ' filter ByParameter

    Select Case LCase(revdet::ThenParameter)

       case "account"


       case "campaign"


       case "opportunity"


       case "project"


       case "partner"


       case "product"


       case "product line"


       case "description"


       case "revenue type"


       case "revenue class"


       case "win probability"


       case "sales rep"


       case "contact last name"


       case "Quote"


       Case Else

          if gErrorMsg = "" then gErrorMsg =

    "'Then' parameter is invalid"

             Exit Function

    End Select

    ' filter ValueParameter

    Select Case LCase(revdet::ValueParameter)

    case "revenue"



    case "margin"



    case "cost"



    case "upside"



    case "downside"



    case "average price"



    case "quantity"


    Case Else ' default

    if gErrorMsg = "" then gErrorMsg = "'Show' parameter

    is invalid"

    Exit Function

    End Select

    ' Get values for the remaining fields









    uRec.SectionKey = CurrentSection

    uRec.uDateUnit = UnitKeyStat ' GetUnitKey(uRec.uDate)

    ' create key for Item grouping based on displayed attributes

    ' Item+Commit+Prob

    uRec.ItemKey= Trim(uRec.uItem) & Trim(uRec.uCommit) &


    Set CreateUListRow = uRec

       End Function

Parts of the described approach to handling the user parameters can be of general use for other parameterized reports. They include Parameters retrieval, filtering Periods, and fetching values from the LOV table.

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