Using the Ad Hoc Reporting tree to create reports
To create an ad hoc report, do one of the following:
- Drag a report element or report topic from the Ad Hoc Reporting tree to the Ad Hoc Reporting workspace.
- Double-click a report element or report topic.
- Select the report element or report topic, and click Insert.
When you double-click or drag a report topic, all report elements it contains appear as columns in the ad hoc report.
When you double-click or drag a report element, a single element appears as a report column in the ad hoc report.
Note: By default, data is turned off in the Ad Hoc Reporting workspace. When you add report topics or report elements to the report palette, the columns are populated with abcd. When you click Run with all data or Preview with limited data, the report is populated with the actual data.