Query Wizard - Add Multiple Subjects to Query

Top  Previous  Next  

The Query Wizard - Add Multiple Subjects to Query screen lets build more complicated Queries by combining multiple Subjects within a Query. You can also use multiple subject queries to create sub reports in the DataPA report designer.

 

The base Subject of the Query you have been building is displayed in the top left corner of the treeview.  If you do not wish to create a Multiple Subject Query simply click on 'Next >' to go to the Query Wizard - Finished screen.

 

clip5853

 

To Add a child Subject to an existing Subject, click on the existing subject to select it and then click on the 'Add' button.  The Query Wizard will go through the necessary screens so that you can Select a Subject, Define Filter Conditions, Select Fields and define Sort Criteria for the additional Subject's Query as you did for the initial part of the Query.

 

The only difference in the process is in the defining of the Filter Conditions where the Query Condition form requires the parent and the child Subjects to be related to each other.  For details see Query Condition - 2 Subjects.  Once you have added the child subjects they will be displayed in the treeview.

You can not Delete or Edit the Base subject's query from the Multiple Subjects Form

 

clip5854

To Delete or Edit the additional Subjects, or Add children to them, click on the Subject in the treeview and then click on the appropriate button.

 

clip5855

The Split Query Results option allows you to return each subject as a separate recordset, rather than the default which is to allow DataPA to combine the results into a single recordset. Split results is useful for creating sub reports.

 

The Inner Join option allows you to control the join between the highlighted subject and it's parent. If you select the Inner Join check box then the parent record and any of it's parents will not be include in the results if there are no records returned by the child subject. If you NOT select the Inner Join check box then the parent record and any of it's parents will  be included in the results even if there are no records returned by the child subject.

 

clip400

Once you have finished building your Multiple Subject Query, click on the 'Next >' button to go to the Query Wizard - Finished screen.


Copyright © 2003-2017 DataPA Limited, all rights reserved. DataPA OpenAnalytics 6.0