Summary

This article explains union reports and how to create them.

Union Reports allow for multiple reports of the same data structure to be combined for easier reading and analysis. For example, rather than creating a single basic report containing all the data for all the visits in a study, it may be useful to create one basic report per visit and then combine all the Visit reports into a single Union Report.

 

  1. On the Ad-Hoc Reports page select ‘Create Report.’
  2. On the ‘Create Report’ form, select ‘Union Report – combines multiple tables of the same data structure into a single report.
  3. Review the options for the ‘Question Headers Displayed Based On:’ selection field to set the column headers for your report.
    • questionID: This option will use the questionID (a variable, such as dob, visitdt, etc) as the column header. This is the default.• Question Text: This option will use the question text as displayed on the eCRF as the column header.
    • Question Label: This option will use a question label configured by the Software Implementation Specialist (SIS) as the column header.
  4. Complete the Create Report form by entering a Report Name and Report Description.
     
  5. If duplicate rows of data should be included in the report, check the checkbox beside ‘Union All.’
  6. Click the ‘Next >>’ button.


Need more help?

Please visit the Fountayn Contact Information page.