Filtering reports with more than one multi-instance form or itemset

You can apply filters to reports that contain data from more than one multi-instance form. However, results will vary depending on where you apply the filter. The following table describes how reporting behavior differs, depending on the filtered element.

Filter options

You can filter on	For these results
A report element from a single-instance form	Rows for filtered-out items are removed. Example: Report contains: SubjectID, Gender, Adverse events, and Concomitant Medications. Filter: Gender column = Male Results: Report removes all rows for female subjects.
A report element from a multi-instance form	Rows for filtered-out items are set to blank values, but not removed. Example: Report contains: SubjectID, Gender, Adverse events, and Concomitant Medications. Filter: Adverse event = Depression Results: Report does not remove rows for other adverse events. Instead, the Adverse Events column displays blank values for all other adverse events.

You can filter on

For these results

A report element from a single-instance form

Rows for filtered-out items are removed.

Example: Report contains: SubjectID, Gender, Adverse events, and Concomitant Medications.

Filter: Gender column = Male

Results: Report removes all rows for female subjects.

A report element from a multi-instance form

Rows for filtered-out items are set to blank values, but not removed.

Example: Report contains: SubjectID, Gender, Adverse events, and Concomitant Medications.

Filter: Adverse event = Depression

Results: Report does not remove rows for other adverse events. Instead, the Adverse Events column displays blank values for all other adverse events.

Copyright © 2012 - 2015 Oracle and/or its affiliates. All rights reserved.