This documentation supports the 19.08 version of Remedy Action Request System.

To view an earlier version, select the version from the Product version menu.

Using subreports to link web reports together

Subreports, which are reports that are linked and appear inside another report, can provide detailed information about a customer beyond the data provided in a parent report. For example:

  • If a customer listing provides a customer ID, that customer ID can be input into a subreport that displays details about each customer. An ID value is often the common data between two data sets.
  • If a parent report displays only the amount spent (or other customer data), a subreport can provide customer details (such as address). A subreport can show a combined parent report and subreport.

Testing each subreport before building the next subreport can help minimize difficulties that can arise with subreports.

The example in this section provides high-level instructions. Subreports are discussed in detail in the BIRT Report Designer online help.

To create a subreport

  1. Design the structure of a report and its subreports.
    This includes details of required data sets and how they are related, and can be a simple relationship diagram of forms.
  2. Create a data source and a required number of data sets.
    For an example, consider a parent "People" report that can have an added subreport, which shows roles attached to a particular people record. The relationship structure is:
    CTM:People (Person ID) > CTM:SupportGroupFuncRoleLookUp (Person ID)
    This structure has two data sets that are required to develop the subreport. The two required data sets are CTM:People and CTM:SupportGroupFuncRoleLookUp.
  3. Create the required data sets as follows:
  4. Create a data set for the parent record (CTM:People).
  5. Create a data set for the child records (CTM:SupportGroupFuncRoleLookUp).
  6. In the Parameter tab of data set creation for child record, create a parameter for the parent key based on which will pull child records.
    For example, the key will be Person ID. Do not link the parameter to any report parameter.
  7. Click Query and modify the query as follows to pull child records having a key value the same as parent record:

    "Person ID" = [param:dsPersonID]
  8. Insert a second table element inside the new detail row of table.
    The child table must have the child record data set associated to it.
    Second table element inside a table detail row

  9. Go to the Binding tab of the new child table.
  10. Bind the key field of the parent data set to the parameter of the child data set parameter.
    Binding tab of the child table

  11. Click Data Set Parameter Binding.
  12. Bind the parent key value to the child.
    Data Set Parameter

  13. Preview the report (save, run, and close the report).

Related topic

Examples of modifying reports with the BIRT Report Designer

Was this page helpful? Yes No Submitting... Thank you

Comments