This REDCap module provides advanced reporting capability.
The link to the advanced reports plugin pages will appear under the external modules heading once the module has been enabled in a project. This will display the list of visible reports. Administrators will also see a link to edit reports, as well as administrative options. Other users granted report editing rights will also see the edit reports link.
To view a report, click on the link in the list of reports. Users with download rights will also get a download link on the report page.
By default, only administrators can edit advanced reports. Edit rights can be granted to other users by changing the system setting Module configuration permissions in projects to Require module-specific user privilege. Edit rights can then be granted by assigning the module-specific privilege to a user or role within the REDCap user rights page.
Note that some report types can only be edited by administrators regardless of these settings.
On the edit page, a new report can be added, or an existing report can be edited or deleted. There is also a link here to view the report, which can be used even if the report is hidden from the main report list.
The following report types are currently available:
- Gantt
- Instrument Query
- Record Table
- SQL (direct database query) *
* only administrators can edit
- Unique Report Name is the identifier used by the system for your report
- Report Label is what the report is called in the list of reports
- Report Category (optional) is the heading under which the report appears in the list
- Report is visible determines whether the report is shown in the list
- Grant access to roles apart from users with edit rights, only the users with roles listed here can see the report
- Allow downloads * determines whether a download link is provided for this report
- Grant downloads to roles * apart from users with edit rights, only the users with roles listed here will see the download link.
- Allow retrieval as image * determines whether the report can be retrieved as an image file,
rather than as a REDCap page, which is useful for embedding a report in a data collection
instrument
- Append &as_image=1 to the report URL to retrieve as an image.
- Access rights are still enforced, so reports may not be visible if embedded in surveys.
- Allow API access * determines whether the report can be accessed using the API
- Note that the Advanced Reports API is separate from the REDCap API and uses its own per-report API keys.
- The API key has to be sent as the value of the
api_keyfield in a HTTP POST request. - Administrators have the option (in the module system settings) to prohibit non-administrators from saving reports where API access is enabled.
* only available on some report types
- Label Fields are shown on the left of the chart and identify each row
- Label Name is the heading for the label column
- Label Field is the event/field which contains the label data
- Chart Categories are the bars on the Gantt chart
- Name is the name of the category, shown within the bars and in the legend at the bottom of the chart
- Start Date Field is the event/field which contains the date which determines where the bar starts on the chart
- End Date Field is the event/field which contains the date which determines where the bar ends on the chart
- Filter Logic is the (optional) conditional logic on which the records will be filtered
Calculated fields can be used for the start and end dates, the Gantt report will interpret the value as a Unix timestamp representing a UTC date/time.
Instrument Query reports treat each instrument in the project like a database table which can be joined and filtered as required. Instrument Query reports support REDCap calculation logic and some smart variables.
- Description brief descriptive text to appear above the report
- HTML <a> <b> and <i> tags as well as the placeholders
$$PROJECT$$(project ID) and$$WEBROOT$$(REDCap version directory web path) can be used in the description.
- HTML <a> <b> and <i> tags as well as the placeholders
- Instruments choose the instruments/forms from which to retrieve data
- Each instrument is treated like a separate database table and can be joined together on any custom logic condition.
- Condition filter the dataset after all the instruments have been retrieved and joined
- Sorting field or logic on which to sort data
- Append
DESCto sort in descending order.
- Append
- Fields to display specify each field or calculation logic for display in the report, with optional alias for the field heading
- Hide missing data codes if selected will show blank values instead of missing data codes
Please refer to the Instrument Query report instructions for more information.
PDF reports can format other reports into a PDF file.
- Source Report the source report from which to fetch the data
- Paper Size the paper size and orientation used in the PDF file
- HTML Source the template/layout of the report in HTML format
Please refer to the PDF report instructions for more information.
Record table reports will display all the fields in the selected instruments and events, including all repeating instances, in a single row for each record.
The data returned in a Record Table will be automatically filtered according to the user's DAG and data export rights.
- Description brief descriptive text to appear above the report
- HTML <a> <b> and <i> tags as well as the placeholders
$$PROJECT$$(project ID) and$$WEBROOT$$(REDCap version directory web path) can be used in the description.
- HTML <a> <b> and <i> tags as well as the placeholders
- Instruments choose the instruments/forms to include
- Events choose the events to include
- Hide missing data codes if selected will show blank values instead of missing data codes
- Description brief descriptive text to appear above the report
- HTML <a> <b> and <i> tags as well as the placeholders
$$PROJECT$$(project ID) and$$WEBROOT$$(REDCap version directory web path) can be used in the description.
- HTML <a> <b> and <i> tags as well as the placeholders
- SQL Query enter SELECT query here
- Result Type choose how the SQL result is to be interpreted (normal or EAV)
- Result Columns pre-specify column names for EAV datasets
Please refer to the SQL report instructions for more information.
The following project-level configuration options are deprecated. They are only visible to administrators and only if at least one of them has been set. To permit non-administrators to edit reports, please use the REDCap module permission as described above.
- Allow users with project design and setup rights to edit reports
- Allow users with add/edit/organize reports rights to edit reports