Siebel Reports Administration Guide > Master-Detail Reports > Example—Creating a Master-Detail Report >

Creating a Report Design in Actuate e.Report Designer Professional


Now the new report design is created, and the major structural components are added.

To create a master-detail report design in Actuate e.Report Designer Professional

  1. Open Actuate e.Report Designer Professional.
  2. Open the srvreqaa.rod (Service Request Activity - All) report design.
  3. When prompted, locate and include the sssrvreq.rol library file from the \Siebdev\RPTSRC\LIB (or equivalent) folder.

    The library path is updated and will result in the srvreqaa.rod file changing.

  4. Close the Actuate Output pop-up window.
  5. Close the srvreqaa.rod report design and click Yes All when prompted to save the report design and library.

    The srvreqaa.rod report and your new Account - Opportunity/Contact Detail report will share frame components from this library. If any customizations need to take place in either report, the component is subclassed first to keep the changes local to one report.

  6. Choose File > New. In the Create New Report window, select Blank Report and click OK.

    A blank design report appears.

  7. Delete the components Report and SimplePageList in the Content and PageList sections of the blank report.

    For removal of Report and SimplePageList components, it is recommended that the components be deleted using the Project Browser:

    1. Navigate to View > Project Browser > Symbols.
    2. Delete the following components under the class NewReportApp Subclass Of AcReport:
      • Class Report Subclass of AcReportSection.
      • Class SimplePageList Subclass of AcSimplePageList.

        Deleting from the Project Browser makes sure that these components are completely deleted from the report.

    3. Close the Project Browser.
  8. Choose Tools > Library Organizer.

    The Include Library window appears.

    1. Before adding the libraries remove the two existing sample libraries (erd_sample_library.rol and sample_sfdata_library.rol) and click More.
    2. Click Browse and navigate to \Siebdev\RPTSRC\LIB (or equivalent on your system), choose sssiebel.rol and click Open.
    3. Repeat this step for the files sscustom.rol, sssrvreq.rol, acopcon.rol, and sssiebel.bas.

      NOTE:  If the acopcon.rol library file is not in the folder named in Step b, navigate to \Siebdev\RPTSRC\ENU\LIB (or the equivalent on your system).

    4. Click OK to close the Include Library window when all the files are added.
    5. Click OK to close the Library Organizer.

      The files sssiebel.rol and sscustom.rol are required libraries for all Siebel standard and custom reports. The acopcon.rol library file is the data supply ROL file that you generated from Siebel Tools; it will define the way data is transferred to the new report.

      NOTE:  Components from afc.rol (and or components from the Actuate e.Report Designer Professional toolbar) and sssiebel.rol should not be used by report developers for designing Siebel-Actuate reports. When developing Siebel application reports, only use the sscustom.rol library.

  9. Right-click on the top-level object (default name NewReportApp) and select Rename.

    The Rename window appears.

    • For the new name, input acopcon.

      It is recommended that you use the same name you used for the ROD file saved previously (without the ROD extension).

  10. Double-click the acopcon (top level) icon in the structure tree.
    1. In the Component Editor window, click Class.
    2. Change the Super Class value from AcReport to ssReport.

      This is an important step. Siebel reports must inherit from ssReport (the Siebel standard report) instead of directly from AcReportSection (Actuate report). ssReport is provided in sscustom.rol and inherits from baseReport from sssiebel.rol.

      NOTE:  You cannot perform this step until you have included the sssiebel.rol library.

      Two components are automatically added to the report when you change the report's class: a report section (ssRpt) and a pagelist section (ssPageList).

  11. While still in the Component Editor for the acopcon (top level) icon, click Properties.
    • Scroll to the ssReportTitle property and enter the value Account - Opty/Contact Detail.

      This value is used in the window title for the report table of contents in the report viewer.

      Close the acopcon - Component Editor.

  12. Save the report design by choosing File > Save. Name the report acopcon.rod and specify a location where you want the report to be saved; for example, \Siebdev\RPTSRC\custom\acopcon.rod.

    Remember to save the design file periodically as you work.

  13. Make sure that the Show Empty Slots option in View > Options is checked.

    You may want to deselect this option at a later time if you find the display of empty slots in the structure tree and layout pane distracting. For now, the empty slots must be visible because components will be dragged onto them from the sscustom library.

  14. Expand the top-level report component.
    1. Right-click the report section child component in the structure tree (ssRpt) and select Slot Information.

      The Single Structure Reference window appears.

    2. Verify name is set to ssRpt.

      Click Subclass and click Close. The report section child component will now be named ssRpt1. You must subclass each component you introduce into the report if you plan on modifying the component. Otherwise, the system will not allow your changes.

    3. Right-click the report section (ssRpt1) and click Rename. Change the name to ssRptAccount.

      It is good design practice to employ naming conventions for components in your reports and to give them meaningful names. The ssRpt prefix indicates that this is a report section based on the ssReport library component. The Account suffix identifies this as the master report section in which account records are displayed.

  15. Expand the report section component (ssRptAccount).
    1. Click the Library Browser button and open the sscustom.rol library.
    2. Drag and drop the ssGrp library component onto the Content child slot of the report section.
  16. Right-click the group section component (ssGrp) and subclass following Step 14.
    1. Right-click the group section component (ssGrp1) and click Rename.
    2. Change the name to ssGrpAccount.
    3. Right-click the group section component (ssGrpAccount) and click Properties. In the Key property, enter ssName.
    4. Close the ssGrpAccount - Component Editor window.
  17. Drag and drop the ssSeq library component onto Content - ssGrpAccount. When prompted, click Use As Content.

    This provides the sequential section that causes the subreports to execute in sequence.

  18. Subclass the sequential section and rename it ssSeqAccount following Step 14.
  19. Drag and drop the ssRpt library component onto the Content - ssSeqAccount sequential section. Subclass following Step 14 and rename it ssRptOpportunity. Expand this report component.
  20. Drag and drop the ssRpt library component onto Content - ssSeqAccount sequential section again. Subclass this report component following Step 14 and rename it ssRptContact. Expand this report component.
  21. Close the Library Browser window.
Siebel Reports Administration Guide