Walkthrough: Designing the Subreport

Walkthrough

In this example, the subreport will contain a Table bound to the 'customers' query. The 'customers' query accepts a 'state' parameter, and lists all customers from the specified state.

1. Click the 'New' button in the Style Studio toolbar. This opens the 'New Asset' dialog box.

2. In the left panel, select the 'Report' node. In the right 'Types' panel, select 'Blank Tabular Report' and click 'OK'.

3. Expand the Style Studio Toolbox panel.

4. Click the 'Table' button in the Toolbox panel to open the 'Data Binding' dialog box for a new Table.

5. Under the Data tab, bind the table to the 'customers' query from the 'Orders' data source.

6. In the Columns tab, click the left-arrow to remove the following columns from the 'Columns' pane:

'customer_id'
'state'
'zip'

Note: The parameter for the subreport must be set prior to its insertion into the main report.

7. In the Condition tab, specify the beginning of the condition:

[state][is][equal to]

8. Select the 'Variable' option in the menu at right.

 

9. Type “state” into the 'Label' field, and click 'Append' to insert the complete condition:

[state][is][equal to][$(state)]

10. In the Grouping & Summary tab, drag 'city' into the 'Grouping' pane, and click 'Finish'.

 

11. Save this subreport as “customer_subreport.srt”. The example continues in Walkthrough: Embedding the Subreport.

<< 6.7.4 Subreports © 1996-2013 InetSoft Technology Corporation (v11.5) Walkthrough: Embedding the Subreport >>