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.