Preferences

In This Section:

General Preferences

Layout Preferences

Format Preferences

Page Preferences

Labels Preferences

Export Preferences

Editor Preferences

View Preferences

Table of Contents Preferences

Navigation Bar Preferences

Navigation Bar Image

HTML Preferences

SQR File Generation Preferences

Object Preferences

Creating a New Report

Line Properties

Box/Oval Properties

Polygon Properties

Image Properties

Text Column Properties

Column Format Properties

Text Object Properties

Text Object Format Properties

Numeric Properties

Numeric Format Properties

Date/Time Properties

Date/Time Format Properties

Page Number Properties

Page Number Format Properties

Font Properties

Cell Properties

Table of Contents Properties

Exceptions

Exception Builder

Using an Exception in a Variable

Chart Wizard — Chart Type

Chart Wizard — Chart Data

Chart Wizard — Chart Properties

Chart Properties: Data

Chart Properties

Chart Properties: Data

Chart Properties: General

Chart Properties: X-Axis

Chart Properties: Y-Axis

Chart Properties: Y2-Axis

Chart Properties: Y2-Palette

Add Color Palette

Chart Properties: Legend

Chart Properties: Header-Footer

Chart Properties: Palette

Advanced Properties: Pie Chart

Advanced Properties: Bar Chart

Advanced Properties: Area Chart

Advanced Properties: Line, Polar, and Radar Charts

Advanced Properties: Candle Stick Chart

Advanced Properties: Combo Area Line and Area Radar Charts

Advanced Properties: Combo Bar Line Charts

Advanced Properties: Combo Area Charts

Advanced Properties: Combo Bar Area Charts

DescriptionAdvanced Properties: Combo Line Charts

Advanced Properties: Combo Bar Charts

Cross-tab Properties

Analysis Properties

Activating Interactive Reporting Analysis

Interactive Reporting Analysis (definition)

Report Properties

Mode Properties

Page Setup Properties

HTML Report Properties

Label Setup Properties

Security

SQR

Insert Calculated Field

Report Parameter Presets

Set Value

Page Breaks

Page Break Type

Group Breaks

Break Options

Production Reporting Operators

Grid Settings

Export Report Layout Window

Include Files

Include File

Lookup Tables

Lookup Table - General

Lookup Table - Key

Lookup Table - Return Value

Database Tab

Master-Detail Binding

Variables

Variable Builder

Types of Variables

Lookup Builder

Run Report

Remote Login

Configure Default Layout

Rebuilding the Default Layout

Goto Page

Goto Line

Tab

Generate Table of Contents (Report menu)

Layout Templates

Template Browser

Template Options

HTML Properties

Insert Column Values

Hyperion SQR Workspace Link

Add Prompt

Inserting Objects into the Layout

Copying Text and Graphics

Working with Queries (Using the Query Builder)

LoadAll

Configure Join

Binding Queries

Correlating Queries

Creating a Correlated Subquery

Creating an Uncorrelated Subquery

Table

View

System Table

Using More than One Table in an SAP Report

Joins

Configure Join

Outer Join

Distinct Values Example

Limiting the Number of Query Rows Example

Expression

Aggregate Function

Function Examples

Operator Examples

Comparison Operators

Logical Operators

Range Operators

List Operators

Unknown Operators

String Operators

Show Values

Having Clause Builder

Joining Multiple Having Clauses

Where Clauses

Where Clause Builder

Where Clause Wizard

Layout Settings

Custom From Clause Builder

The Layout Window

Layout Window Menus

Align

Space Evenly

Make Same Size

Stretch/Shrink

Move

Center on Page

Fit to Page

Bring to Front and Send to Back

Edit Query (Report Menu)

Query (Report Menu)

Generate Table of Contents (Report Menu)

Entering Runtime Parameters

Data Connection - Name

Data Connection - Provider

Data Connection - ODBC Data Source

Data Connection - Local Database

Data Connection - Login Parameters

Query Builder - Query Name

Logon

Direct Connection

SAP Router

Load Balanced

Gateway

Miscellaneous

Image Format Properties

Load Session (Bad Table)

Load Session (Bad Column)

Load Session (Column Differs)

Load Session (Bad User)

ORACLE OFEN Error

Tabs