| Info |
|---|
CCC Data Warehouse Report Server - Copyright May 2021 |
...
Authenticator for Mac and Windows Chrome browsers is available free from the Chrome Web Store. This app installs very quickly to your desktop (recommended) as well as your phone, and includes a lot of great features that promote security and usability. NOTE: The entire download and install process takes less than one minute. You may need local IT authorization and assistance to install it if policy requires this.
To Install the Chrome Authenticator:
...
The Ad Hoc Editor is the interactive designer for creating and editing an ad hoc View, where you can explore and analyze data from a Topictopic, Domaindomain, or other data source. Ad hoc Views are used to create content for various types of Reports, including tables, cross tabscrosstabs, and charts. After you create an ad hoc View, you - and any other authorized users with the proper permissions - can save it as a Report, then further refine the displayed information and personalize the look of the report in the Report Viewer.
...
Topics: JRMXL files created externally and uploaded to JasperReports Server as a basis for Ad Hoc views.
Domains: Virtual views of a data source that present the data in business terms, allow for localization, and provide data-level security.
You can also open and edit an existing Ad Hoc view to create a new Ad Hoc view.
Ad Hoc View Types
The design and content tasks for creating a new report are determined by the Ad Hoc View Type that is selected. By default, all new ad hoc Views are set to the Crosstab format type.
The Ad Hoc Editor allows you to select from three different view types:
Table: Used to view detailed values in the database and to summarize the values in columns.
Crosstab: Used to aggregate data across multiple dimensions.
Chart: Used to compare one or more measures across multiple sets of related fields.
...
| Note |
|---|
By default, the format type for all new ad hoc Views is are set to the standard Crosstab type. To build create a Table report, you must change the format type to Table in the “Select Visualization Type” dialog box. |
| Info |
|---|
Note: This document only covers the Table type in detail. For more discussion on Crosstab and Chart typescrosstab and chart type formats, see JasperReports Server v7 User Guide: Working with Standard Crosstabs. |
...
| Info |
|---|
Creating Filters with Relative DatesYou can filter information in your view based on a date range relative to the current system date. You can accomplish this using date-based filters, and entering a text expression describing the relative date or date span you want to display, using the format <Keyword>+/-<Number> where:
For example, if you want to see all of the CC Promise Grant Applications submitted during the prior week, your expression would be: WEEK-1. |
...