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.
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.
- 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
Your report will consist mostly of data retrieved from a database query that you will create through Report Design Wizard, SQL Query Designer, MQL Query Builder, or by hand. Once you have a dataset, you are able to further constrain it to show specific details, and then move on to report layout and design.
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.
See our list of common problems and resolutions.