New in ad hoc reporting

Add calculations to reports to develop more complex reports

Administrators can give a subset of users the ability to create calculations as columns in a report. Through signature option access, calculations are created with standard mathematical operators and SQL syntax that is enabled by using an expression library. New features are also included to validate the expression before it is added to the report and for your administrator to customize the expression library. Learn more about adding calculations to reports

Add summaries for selected attributes in a report to quickly analyze data results

In the new Summary tab in the Ad Hoc dialog box, users can add summaries for selected attributes to the report. Depending on the style of report that is selected, the summaries can be displayed at the header or the group level. The summaries provide high level overviews including counts, averages, minimum values, and maximum values. Learn more about adding summaries to attributes

Redesign of the ad hoc reporting dialog simplifies the report design inputs

The Ad Hoc dialog box is redesigned for improved field selection and report development. You can quickly enter data by using the Select buttons and hyperlinks for attributes.

Restrict record access to prevent performance issues

You can configure improved performance limits for your individual security groups. These limits restrict the number of records that users access when they develop a report during the preview stage of report development. Additionally, record limits are available for saved ad hoc reports. Learn more about restricting the number of records that a user accesses