Query Studio report FAQs

What kind of data can I use in my reports?

The Reporting and Analysis database contains two types of data:

Study management data—Stored in the operational data model, and includes metrics and status data for a study. Use study management data to report on the completion status of your study. You can report on things like the number of visits that are complete for a study or the number of forms that are frozen or locked.
The Reporting and Analysis database study management schema is installed with each InForm installation. It is not specific to your study.
Clinical reporting data—Stored in the clinical data model, and includes data about each subject visit. Use clinical data to report on specific clinical questions and responses. You can report on things like adverse events, vital signs information, and dosing records.

I'm filtering a report with more than one repeating form and itemset. How is my data affected?

You can apply filters to reports that contain data from more than one repeating form. However, results will vary depending on where you apply the filter.

Filter options

You can filter on	For these results
A report element from a non-repeating 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 repeating 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 non-repeating 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 repeating 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.