The View Ad Hoc Report widget allows the user to pin a report directly to their dashboard. The user can choose which report to view by utilizing settings. This widget can be configured to display the entire report, the report grid or one of two charts defined for the report.
Configure a report
To configure a report to display in Ad Hoc, click the wrench icon to view the “Report Viewer” form.
Select the report to display, the report grid, or one of the two charts.
Click the Save changes button. Or, click the Cancel button to exit the form without saving changes.
Report filters that are predefined in the report configuration are applied when the report is loaded into the View Ad Hoc Report widget. Users can filter the report by values in one or more of its columns.
Create a report
To create a report configured to show filters in its configuration, create a report that is configured with Show Filters in Report Configuration and select at least one filter field.
Grant appropriate permissions on the report to ensure it is included in the list of reports on the widget for the appropriate users/groups.
Add the View Ad Hoc Report widget to the Personal dashboard. Configure the widget to display the preferred report.
Click the plus icon to define additional filters.
Select the column for inclusion in the filter.
Hover over the filter field to expose the setting wheel to:
- Change an existing filter configuration.
- Define the filter criteria for filters being added.
To eliminate the possibility of a user overwriting a filter for other users, the application is configured so that filters do not persist when the user leaves their dashboard.
- Multiple View Ad Hoc Report widgets can be pinned to the user’s dashboard, however, only a single filterable View Ad Hoc Report widget is supported on the dashboard.