Adhoc Business Objects

Here you will find instructions for creating reports based on your own selected criteria.

Steps:

1. Click .

2. Click .

The HTML Report Panel Workspace

1. Building queries

2. Choosing a template to display report values

3. Setting more report options

• Filtering report values

• Adding breaks, sorts, and calculations

• Formatting reports

Building a Query using the HTML Report Panel

1. Understanding queries and universes

• Queries are based on universes

• What does a universe contain?

• What different types of objects can you use in a query?

• Running a query

2. Building a simple query

3. Running a simple query

Filtering Queries

1. How query filters work

2. Combining filters

3. Editing and removing query filters

Defining the Structure of Reports

1. Creating sections to group information

2. Creating sections in a report

3. Changing the order of sections on a report

Filtering the Information Displayed in Reports

1. How report filters work

• The difference between report filters and query filters

• What makes up a filter?

• What objects can I filter?

• Understanding filter operators

2. Applying report filters to report data

• Creating report filters

3. Applying multiple filters to a report

• Combining report filters

4. Editing and removing filters

Applying Sorts and Breaks to Organize Report Information

1. Sorting the results displayed on reports

• Sorting values displayed on tables

• Applying sorts to sections

2. Using breaks to group information on tables

Using Calculations in Reports

1. What predefined calculations are available?

2. Inserting and removing calculations

Formatting Reports and Report Page Layout

1. Using the Result Preview pane

2. Defining page size, orientation, and margins

3. Displaying report titles

4. Aligning tables and charts on the report page

5. Formatting sections

6. Formatting page headers and footers

Formatting Tables, Crosstabs, and Forms

1. Formatting vertical and horizontal tables

2. Formatting crosstabs

3. Formatting forms

Formatting Charts

1. Available formatting options for charts

2. Personalizing how charts are formatted

Downloading Documents

Saving documents as PDF files