Introduction
About This Guide
Manual Conventions
Documentation Requests
Designing Dashboards
Create a Dashboard
Provide Data
Manage Data Sources
Working with SQL Data Sources
Manage SQL Queries
Filter Queries
Pass Query Parameters
Stored Procedures
Filter Data Sources
Calculated Fields
Add Dashboard Items
Bind Dashboard Items to Data
Bind Dashboard Items to Data in the Web Dashboard
Hidden Data Items
Bind Dashboard Items to Data in OLAP Mode
Dashboard Items Settings
Chart
Providing Data
Series
Panes
Interactivity
Legend
Axes
Orientation
Conditional Formatting
Scatter Chart
Providing Data
Interactivity
Legend
Axes
Orientation
Labels
Conditional Formatting
Grid
Providing Data
Columns
Interactivity
Conditional Formatting
Totals
Column Filter
Layout
Pies
Providing Data
Interactivity
Layout
Lables
Style
Cards
Providing Data
Layout
Delta
Sparkline
Formatting
Interactivity
Cards Arrangement
Conditional Formatting
Gauges
Providing Data
Delta
Gauge Scale
Interactivity
Layout
Style
Pivot
Providing Data
Interactivity
Conditional Formatting
Layout
Expanded State
Choropleth Map
Providing Maps
Providing Data
Delta
Map Navigation
Interactivity
Labels
Legend
Geo Point Maps
Map Types Overview
Providing Maps
Geo Point Map
Providing Data
Bubble Map
Providing Data
Legends
Pie Map
Providing Data
Pie Options
Coloring
Legends
Clustering
Map Navigation
Interactivity
Labels
Range Filter
Providing Data
Series
Interactivity
Predefined Periods
Date Filter
Images
Image Overview
Providing Images
Interactivity
Image Settings
Text Box
Treemap
Providing Data
Interactivity
Layout
Grouping
Coloring
Labels
Filter Elements
Filter Elements Overview
Providing Data
Interactivity
Dashboard Item Group
Tab Container
Data Shaping
Summarization
Grouping
Sorting
Filtering
Top N
Formatting Data
Interactivity
Master Filtering
Drill-Down
Neutral Filter Mode
Appearance Customization
Conditional Formatting
Coloring
Data Analysis
Aggregations
Calculations
Dashboard Parameters
Creating Parameters
Passing Parameter Values
Requesting Parameter Values
Expression Constants, Operators, and Functions
Convert Dashboard Items
Dashboard Layout
Dashboard Title
Dashboard Item Caption
Dashboard Items Layout
Undo and Redo Operations
Save a Dashboard
Open a Dashboard
Exporting
UI Elements
Toolbox
Dashboard Surface
Dashboard Menu
Dashboard Item Menu
Data Item Menu
Designer Toolbar
Dialogs and Wizards
Dashboard Data Source Wizard
Specify Data Source Settings (Database)
Specify Data Source Settings (JSON)
Specify Data Source Settings (OLAP)
Specify Data Source Settings (Data Fedaration)
Query Builder
Preview Data
Filter Editor
Designing Reports
First Look at the Report Designer
Add New Reports
Open Reports
Save Reports
Introduction to Banded Reports
Bind to Data
Bind a Report to a Database
Specify Query Parameters
Bind a Report to a Join-Based Federated Data Source
Bind a Report to a Union-Based Federated Data Source
Bind a Report to a Transformation-Based Data Source
Bind a Report to a Federated Master-Detail Data Source
Create Reports
Table Reports
Vertical Reports
Letters
Master-Detail Report with Detail Bands
Master-Detail Report with Subreports
Hierarchical Report
Cross-Tab Reports
Multi-Column Reports
Reports with Cross-Band Content and Populated Empty Space
Reports Merged with PDF
Reports with Embedded PDF Content
Reports with Visual PDF Signature
Configure Design Settings
Change Report Measurement Units
Change Report Page Settings
Enable the Right-To-Left Layout
Use Report Elements
Manipulate Report Elements
Add Controls to a Report
Bind Report Controls to Data
Use Embedded Fields (Mail Merge)
Validate Report Data Bindings
Select Report Elements and Access Their Settings
Move and Resize Report Elements
Apply Styles to Report Elements
Copy Report Controls
Arrange Report Controls
Add Report Controls to Containers
Validate the Report Layout
Use Basic Report Controls
Label
Character Comb
Rich Text
Check Box
Picture Box
Subreport
Panel
Page Break
Table of Contents
Page Info
PDF Content
PDF Signature
Use Tables
Table Overview
Bind Table Cells to Data
Manage Table Structure
Manipulate Table Elements
Hide Table Cells
Use Barcodes
Add Barcodes to a Report
Barcode Recognition Specifics
Codabar
Code 11 (USD-8)
Code 128
Code 39 (USD-3)
Code 39 Extended
Code 93
Code 93 Extended
Deutsche Post Leitcode
Deutsche Post Identcode
EAN 13
EAN 8
ECC200 - Data Matrix
GS1 - DataBar
GS1 - Data Matrix
GS1- 128 - EAN-128 (UCC)
Industrial 2 of 5
Intelligent Mail
Intelligent Mail Package
Interleaved 2 of 5
Matrix 2 of 5
MSI - Plessey
PDF417
Pharmacode
PostNet
QR Code
UPC Shipping Container Symbol (ITF-14)
UPC Supplemental 2
UPC Supplemental 5
UPC-A
UPC-E0
UPC-E1
Use Charts
Use Charts in Reports
Add a Chart (Set Up Series Manually)
Add a Chart (Use a Series Template)
Use Charts to Visualize Grouped Data
Use Gauges and Sparklines
Add Gauges to a Report
Add Sparklines to a Report
Draw Lines and Shapes
Draw Lines
Draw Shapes
Draw Cross-Band Lines and Boxes
Use Report Parameters
Create a Report Parameter
Report Parameters with Predefined Static Values
Report Parameters with Predefined Dynamic Values
Multi-Value Report Parameters
Cascading Report Parameters
Date Range Report Parameters
Reference Report Parameter
The Parameters Panel
Shape Report Data
Filter Data
Filter Data at the Report Level
Filter Data at the Data Source Level
Limit the Number of Records to Display
Group and Sort Data
Sort Data
Group Data
Sort Data by a Custom Field
Group Data by a Custom Field
Sort Groups by a Summary Function's Result
Format Data
Specify Conditions for Report Elements
Conditionally Change a Control's Appearance
Conditionally Change a Label's Text
Conditionally Change a Band's Visibility
Conditionally Filter Report Data
Conditionally Suppress Controls
Limit the Number of Records per Page
Calculate Summaries
Calculate a Summary
Calculate an Advanced Summary
Count Elements and Values
Display Row Numbers in a Report, Group or Page
Count the Number of Records in a Report or Group
Count the Number of Groups in Report
Use Calculated Fields
Calculated Fields Overview
Calculate an Aggregate Function
Calculate a Weighted Average Function
Layout Dynamic Report Content
Maintain the Band Location on a Page
Keep Content Together
Maintain the Size and Content of Data-Bound Controls
Anchor Controls
Suppress Controls
Customize Appearance
Appearance Properties
Report Visual Styles
Add Navigation
Add Page Numbers
Add Cross-References and Hyperlinks
Add Bookmarks and a Document Map
Create a Table of Contents
Provide Interactivity
Create Drill-Down Reports
Sort a Report in Print Preview
Edit Content in Print Preview
Add Extra Information
Add Waterrmarks to a Report
Display the Current Date and Time in a Report
Display the User Name in a Report
Merge Reports
Add a Report to the End/Beginning
Use Data-Driven Page Sequence
Use Expressions
Expressions Overview
Expression Language
Functions in Expressions
How to: Use Expressions
Data Binding Modes
Preview, Print, and Export Reports
Export a Document
CSV-Specific Export Options
HTML-Specific Export Options
Image-Specific Export Optoins
MHT-Specific Export Options
PDF-Specific Export Options
RTF-Specific Export Options
Text-Specific Export Options
XLS-Specific Export Options
XLSX-Specific Export Options
DOCX-Specific Export Options
Report Designer Tools
Design Surface
Main Toolbar
Toolbox
Query Builder
Chart Designer
Expression Editor
Filter Editor
Format String Editor
Master-Detail Retaliation Editor
UI Panels
Properties Panel
Expressions Panel
Field List
Report Explorer
Report Design Analyzer