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 contain the text N/A, but are 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, N/A appears in the Adverse Events column 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 contain the text N/A, but are 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, N/A appears in the Adverse Events column for all other adverse events.

Copyright © 2014 Oracle and/or its affiliates. All rights reserved.