1. Reports Guide
  2. Viewing the Report Template of a Master-Detail Report

Viewing the Report Template of a Master-Detail Report

In the example in this topic, you view the report template that Siebel CRM uses for the Service Request Activity (All) master-detail report.

To view the report template of a master-detail report

  1. Run the Service Request Activity (All) report:

    1. Log in to the Siebel Service application.

    2. Navigate to the Service screen, and then choose All Service Requests across Organizations.

    3. In the All Service Requests across Organizations list, choose an account and then click the Reports button in the application toolbar.

    4. In the Run Report pane, in the Report Name list, choose Service Request Activity (All).

    5. Choose a report output type, and then click Submit.

    6. In the File Download dialog box, choose Open.

      Siebel CRM displays the Service Request Activity (All) report in a browser window. To view this report, see About Master-Detail Reports.

  2. Open Oracle Publisher Desktop.

    For more information, see About Oracle Publisher Desktop.

  3. Open the srvreqaa.rtf file that resides in the following folder: SIEBEL_SERVER_ROOT\XMLP\TEMPLATES.

    For more information, see Directory Structure That Siebel Reports Uses

    This template, for example, includes the following items:

    • Table for the master record that Siebel CRM displays in a form.

    • Table for each set of child records that Siebel CRM displays in a list.

    • For-each loop that Siebel CRM runs for all master records. It includes the parent form and all child lists.

    • The following condition for the Activity section that prevents Siebel CRM from displaying header information in the Activity section if no activities exist for the service request:

      (<?if:current-group()//ssAction?>)

      For information about how to identify the report template that is associated with a report, see Views You Use to Register Report Templates.

  4. In the Publisher menu, select Tools, select Field Browser, and then select Show All.

    The Field Browser dialog box displays, that allows you to view and modify the template. For more information, see Oracle Publisher Code for Service Request Activity (All) Report Template.