Siebel Reports Administration Guide > Using Master-Detail Reports > Process of Creating a Report With a Parent-Child Relationship >

Defining Child Controls For a Parent-Child Report


This task is a step in Process of Creating a Report With a Parent-Child Relationship.

Next, define the child report structure for the parent-child report.

To define the child report structure for a parent-child report

  1. In the Libraries window, expand the sssrvreq.rol library file.
  2. Drag and drop the ssFrmActivityMain library component onto the Before child slot of the ssGrpAccount tree in the Report Structure Window.
  3. Collapse the ssFrmActivityMain tree.

    TIP:   Subtrees in the Report Structure window can be distracting when in their expanded format. To improve navigation, collapse subtrees as you perform this procedure.

  4. Drag and drop the ssFrmActivityInnerBefore library component of the sssrvreq.rol library from the Libraries window onto the PageHeader slot of the ssRptContact tree you created in Step 9.
  5. Collapse all libraries in the Libraries window, and then expand the ssoppt.rol library.
  6. Drag and drop the ssOppHeader library component of the ssoppt.rol library onto the PageHeader slot of the ssRptOpportunity tree you created in Step 7.
  7. Subclass the ssOppHeader tree, and then rename it to ssFrmOpportunityPage.
  8. Delete ssTxtOPPTHeadM of the ssFrmOpportunityPage tree.
  9. From the application-level menu, choose File, and then Save.

Next, define the child Opportunity controls for a parent-child report.

To define child Opportunity controls for a parent-child report

  1. Drag and drop the ssOppRowNoAddress library component onto the Content slot of the ssRptOpportunity tree in the Report Structure window.
  2. In the Libraries window, open the sscustom.rol library, then drag and drop the ssLblSectionHead component from the Libraries window onto the ssFrmOpportunityPage tree in the Report Structure window.
  3. Subclass the ssLblSectionHead control, and then rename it to ssLblOpportunityHead.
  4. Subclass the ssFrmOPSTATEHeader tree in ssFrmOpportunityPage, and then rename it to ssFrmOpportunityHeader.
  5. Expand the ssFrmOpportunityHeader tree, and then delete the child ssLblAccount frame in the ssFrmOpportunityHeader tree.
  6. Subclass each of the remaining child controls in the ssFrmOpportunityHeader tree.
  7. Collapse the ssFrmOpportunityPage tree, and then expand the child ssOpRowNoAddress tree in ssRptOpportunity.
  8. Subclass ssOpRowNoAddress, and then rename it to ssOpportunityContent.
  9. Delete the child ssTxtOPSTATEAccount control of the ssOpportunityContent tree.
  10. Subclass each of the remaining child controls in the ssOpportunityContent tree.
  11. From the application-level menu, choose File, and then Save.

Next, adjust the report layout.

To adjust the report layout

  1. In the Layout window, drag the labels and text controls to the left to replace the controls you deleted in the procedure starting with Step 1.

    Make sure each data control is aligned vertically with the corresponding header label.

    TIP:   You can select multiple controls in the Layout window by holding down the shift key.

  2. Right-click the ssGrpAccount tree, choose Properties, expand the Pagination property, and then make sure properties are set according to values described in the following table.
    Property
    Value

    PageBreakBefore

    TRUE

    PageBreakAfter

    FALSE

    To cause a subreport section to display on its own page, set PageBreakBefore to TRUE for the subreport, such as ssRptContact. If PageBreakBefore and PageBreakAfter is FALSE for all subreports, then no page breaks will occur, except between accounts.

  3. From the application-level menu, choose File, and then Save.
Siebel Reports Administration Guide Copyright © 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices.