Example: Working with Conditionalsubqueries_component.bqy.
Note:
For Conditionalsubqueries_component.bqy to work correctly, it must be first merged with another Interactive Reporting Studio document; for example, Sample_en_esm.bqy. See Merging Components.
To use Conditionalsubqueries_component.bqy:
Merge Conditionalsubqueries_component.bqy and Sample_en_esm.bqy.
See Merging Components.
In Interactive Reporting Studio , from Sections, right-click Sales Query and select Duplicate section.
Sales Query2 and Sales Results2 are created.
Rename Sales Query2 to be Secondary Query, and Sales Results2 to be Secondary Results.
Select Sales Query, and drag State to the Filter line.
Filter is displayed.
Optional: If the Sample.oce dialog box is displayed, click OK without entering any information.
Select Show Values, and select AZ and CA.
Click OK, and select State on the Filter line.
Select Query, then Variable Filter.
From Sections, select Secondary Query, and drag State to the Filter line.
For Secondary Query, repeat steps 5-7, but do not set as a variable filter.
Proceed with setting the component properties and processing the queries.
To set the component properties and process the queries:
From Sections, select Conditional Sub-Queries Properties frame.
From Available Queries, select Sales Query and click
to move it to Primary Events.From Event Name, select Sales Query.
From Limit Lookup Table, select Sales Results.
From Available Queries, select Secondary Query and click
to move it to Sub-Queries.Click Apply.
From Sections, select Sales Query, and click Process.
Filter is displayed with AZ and CA selected. Click OK. Sales Results displays data only for AZ and CA.
From Sections, select Secondary Results.
The data from the primary query is returned in the sub-query; that is, the data is displayed only for AZ and CA.