Pentaho Report Designer
Pentaho Report Designer is a sophisticated report creation tool that you can use standalone, or as part of the larger Pentaho Business Analytics distribution. It enables professionals to create highly detailed, print-quality reports based on adequately prepared data from virtually any data source.
Report Designer is one of several ways to create reports with Pentaho software. Through the Pentaho Server's Web-based Pentaho User Console, you can also use the Interactive Reporting interface, or you can integrate the Pentaho Reporting engine (on which Report Designer is built) into your own software.
This section covers all of the major Report Designer features and functions, from adding a data source to working with conditional formatting and formulas. You can read it cover-to-cover to attain a reasonably comprehensive Report Designer education, or you can use it strictly as a reference to consult when you run into an operational challenge.
Get started with the Report Designer
How you start Report Designer depends on which platform you are using Windows, Linux, or OS X.
On Windows
If you used the Pentaho Business Analytics installer available to you through your subscription, you will have a Start menu category for all of your Pentaho applications. To run Report Designer, click the Report Designer item in the Pentaho Business Analytics subdirectory in the Pentaho application folder. Alternatively, you can run the pentaho\design-tools\report-designer\report-designer.exe from Windows Explorer or the command prompt.
On Linux
The Business Analytics installer does not create program entries in the K menu or Applications menu in Linux desktop environments, so you will have to start Report Designer by navigating to the pentaho/design-tools/report-designer/ directory and running the report-designer.sh script. You can do this from your file manager, or from a terminal window.
On OS X
The Mac installation procedure does not create program entries in the dock, so you will have to start Report Designer by opening your Applications folder, then the report-designer sub-folder, then running report-designer.app.
Configuration files
Upon first launch, Report Designer creates a .pentaho directory in the current user's home directory, and populates it with the configuration subdirectories and files.
Tour the interface
You can tour the user interface before moving on to more complex tasks.
Create a report
To create a report in Report Designer, follow this process.
Procedure
Connect to a data source (usually a database, yet you can also pull data from a flat file). Learn more
Get your data with a query. Learn more
Arrange data elements in the Report Designer workspace. Learn more
Apply formatting to report elements. Learn more
Add chart elements. Learn more
Create formulas or calculated fields using data retrieved from your query. Learn more
Publish the report, either to the Pentaho Server, or locally as a PDF or other supported file format. Learn more
Results
Advanced topics
The following topics help to extend your knowledge of Report Designer beyond basic setup and use:
- Output parameterization
Maintain one report with output parameters so the person viewing the report can change its data structure or values.
- Localize a report
Pull text content from message bundles that contain localized strings.
- Create Report Design Wizard templates
Creating templates for the Report Design Wizard and Interactive Reports.
Troubleshooting
See our list of common problems and resolutions.