Pentaho Report Designer

Version: 9.5.x
Audience: anonymous
Part Number: MK-95PDIA008-09

Using Pentaho Report Designer
Get started with the Report Designer
Configuration files
Tour the interface
Create a report
Advanced topics
Troubleshooting
Report Designer configuration files
Tour the Report Designer interface
The Welcome screen
The Report Designer main toolbar
Defining preferences
Report Designer's tabbed views
The report workspace
The Structure pane
Master report or sub-report
The Data pane
Data sets
Functions
Environment
Parameters
The Style pane
The Attributes pane
The Palette
Function reference
Common functions
Report functions
Summary functions
Running functions
Advanced functions
Chart Data functions
Image functions
Script functions
Deprecated functions
Style properties reference
Font styles
Text styles
Text Spacing styles
Padding styles
Object styles
Size and Position styles
Links styles
Excel styles
Sparkline styles
Page Behavior styles
Border styles
Attributes reference
Barcode
Common
Table of contents
Index
Excel
HTML
HTML-events
Images
PDF
Pentaho
Query
Query-metadata
Parameter
Sparkline
Survey-scale
Swing
Wizard
Connect to a data source
JDBC
Passing security information to a report over a JDBC connection
Metadata
Pentaho Data Integration
OLAP
OLAP (advanced)
XML
Table
Other Data Sources
Advanced topics
Add a JNDI data source
Add a MongoDB data source
Create queries
Create queries with SQL Query Designer
Access the SQL Query Designer
Apply query filters
Refine the query
Analyze results
Create sub-queries with SQL Query Designer
Create queries with Metadata Query Editor
Create MDX queries
Dynamic query scripting
Hadoop Hive-specific SQL limitations
Add report elements
Report layout types
Add standard design elements
Align elements
Add bands
Create sub-reports
Placing inline and banded sub-reports
Refer to report elements by name or column position
Create a table of contents
Create an index
Apply formatting to report elements
Create hyperlinks
To a report on a chart
On visualizations
Paste formatting
Morph an element
Implement row banding
Add a chart
Choose a chart type
Create a JFreeChart element
Create a sparkline chart
Sparkline attributes
Perform calculations
Use the Formula Editor
Formulas and functions
Summarize data in groups
Formulas and functions
Formulas
Conditional formatting
Multiple conditional formatting
Calculated dates
Date and time parameters
Functions
Page numbering
Publish a report
Publish to the Pentaho Server
Edit Interactive Reports
Hide reports
Link reports
Link in tabs
Output parameterization
Simple SQL output parameterization
Advanced SQL output parameterization
Simple metadata output parameterization
Simple OLAP output parameterization
Localize a report
Use externalized message bundles
Create Report Design Wizard templates
Report Design Wizard template design guidelines
Requirements
Formatting inheritance
Inheriting styles from the data query
Padding and grid lines
Updating
Interactive Reports template design guidelines
Requirements
Formatting inheritance
Inheriting styles from the data query
Padding and grid lines
Updating
Dynamic element positioning in templates
Percentages
Block, inline, or row
Dynamic height message elements
Proportional column widths
Template properties
Deploy a template to Report Design Wizard
Deploy a template to Interactive Reports
Set the default Interactive Reports template
Report Designer and Reporting engine issues
Report elements with dynamic heights overlap other elements
Columns unexpectedly merge when exporting to Excel

Back to home page