> For the complete documentation index, see [llms.txt](https://academy.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://academy.pentaho.com/solution-analyst-path-sandbox/solution-analyst/report-designer.md).

# Report Designer

The fourth Solution Analyst course: Report Designer. 39 lessons in 11 modules: parameterised reports with charts and sub-reports, published and burst, ending in a Regional Sales report.

{% hint style="warning" icon="eye" %}
**SANDBOX — draft page.** Built from `bi-developer-rd-associate` 0.1.9 in Pentaho Content Manager. Module and lesson names, the reading-or-workshop kinds and the times come straight from each lab's manifest. Items marked REPLACE-ME need an owner's confirmation.
{% endhint %}

The fourth of the five courses on the Solution Analyst path. Build the print-quality reports the User Console tools can't: connect Report Designer to your data, lay out elements and groups, add totals and conditional formatting, prompt the reader with parameters, chart and drill down with sub-reports, then publish to the Pentaho Server — and burst one report by territory, so each regional manager gets their own copy by email. The capstone is a management-ready regional sales report.

{% columns %}
{% column %}

<p align="center"><i class="fa-file-lines" style="color:green;">:file-lines:</i><br><strong>39 lessons</strong><br><em>across 11 modules</em></p>
{% endcolumn %}

{% column %}

<p align="center"><i class="fa-flask" style="color:orange;">:flask:</i><br><strong>22 workshops</strong><br><em>hands-on labs</em></p>
{% endcolumn %}

{% column %}

<p align="center"><i class="fa-clock" style="color:cyan;">:clock:</i><br><strong>~15h 30m</strong><br><em>including ~5h 30m of reference reading</em></p>
{% endcolumn %}
{% endcolumns %}

{% hint style="success" icon="cloud-arrow-up" %}
Every workshop is hands-on and runs on Pentaho's hosting platform. The Lab Guide is embedded in each lab and loads automatically when you open it — nothing to install.
{% endhint %}

***

<h3 align="center">Before you start</h3>

{% columns %}
{% column %}
{% hint style="success" icon="circle-check" %}
**What you'll need**

Business Analyst, or experience building reports in the User Console. The reports run on the SteelWheels SampleData, so comfort with SQL `SELECT` queries will make the data-source labs quicker — but every step is shown. The bursting workshop uses a test mail server that the lab provides.
{% endhint %}
{% endcolumn %}

{% column %}
{% hint style="info" icon="tag" %}
**Built against**

Pentaho Enterprise Edition **11.0.0.0-232**, the build every course on the Academy runs — the Pentaho Server and the Report Designer design tool that ships with it. The hosted labs run this exact release, so every screen, menu and dialog matches the guide step for step.
{% endhint %}
{% endcolumn %}
{% endcolumns %}

***

{% hint style="info" icon="file-invoice" %}

#### What you'll build

Reports built up a module at a time on the SteelWheels data: a JDBC data source and its queries, grouped and totalled reports with conditional formatting, polished headers and footers, run-time parameters, charts with drill-down and multiple sub-reports, and reports published to the repository and linked with hyperlinks. Then one report burst by territory: a schedule per regional manager, each emailing that territory's PDF. The capstone is a Regional Sales report — built, charted, parameterised and published — for management.
{% endhint %}

***

<h3 align="center">Skills you'll gain</h3>

<table data-view="cards"><thead><tr><th></th><th></th></tr></thead><tbody><tr><td><i class="fa-database" style="color:blue;">:database:</i> <strong>Data sources</strong></td><td>The Report Designer workspace · JDBC connections · queries and data sets</td></tr><tr><td><i class="fa-table" style="color:blue;">:table:</i> <strong>Layout</strong></td><td>Report elements · groups with headers and footers · fonts, spacing and formatting</td></tr><tr><td><i class="fa-calculator" style="color:blue;">:calculator:</i> <strong>Calculations</strong></td><td>Formulas and functions · group and report totals · conditional formatting</td></tr><tr><td><i class="fa-sliders" style="color:blue;">:sliders:</i> <strong>Parameters</strong></td><td>Prompts · defaults · parameter-driven queries</td></tr><tr><td><i class="fa-chart-column" style="color:blue;">:chart-column:</i> <strong>Charts and sub-reports</strong></td><td>Charts · drill-down · multiple sub-reports</td></tr><tr><td><i class="fa-envelopes-bulk" style="color:blue;">:envelopes-bulk:</i> <strong>Publishing and bursting</strong></td><td>Publishing to the repository · hyperlinks between reports · one schedule per reader, each emailing their own PDF</td></tr><tr><td><i class="fa-trophy" style="color:blue;">:trophy:</i> <strong>Capstone — Regional Sales Report</strong></td><td>Built, charted, parameterised and published — every module in one report</td></tr></tbody></table>

***

<h3 align="center">Course outline</h3>

<p align="center"><i class="fa-file-lines" style="color:green;">:file-lines:</i> reading · <i class="fa-flask" style="color:orange;">:flask:</i> hands-on workshop</p>

{% hint style="info" icon="circle-info" %}
Full lessons unlock once you're enrolled — this is the outline only. Times are the lab guides' own estimates.
{% endhint %}

<table data-search="false"><thead><tr><th width="382">Module</th><th width="115" align="center">Reading</th><th width="132" align="center">Workshops</th><th width="100" align="right">Time</th></tr></thead><tbody><tr><td>Before You Start</td><td align="center">—</td><td align="center">1</td><td align="right">~5m</td></tr><tr><td>Navigating Report Designer</td><td align="center">1</td><td align="center">1</td><td align="right">~20m</td></tr><tr><td>Data Sources &#x26; Queries</td><td align="center">1</td><td align="center">1</td><td align="right">~30m</td></tr><tr><td>Report Elements &#x26; Groups</td><td align="center">1</td><td align="center">2</td><td align="right">~50m</td></tr><tr><td>Calculations</td><td align="center">1</td><td align="center">3</td><td align="right">~1h</td></tr><tr><td>Formatting the Report</td><td align="center">1</td><td align="center">3</td><td align="right">~50m</td></tr><tr><td>Report Parameters</td><td align="center">1</td><td align="center">2</td><td align="right">~45m</td></tr><tr><td>Charts &#x26; Sub Reports</td><td align="center">1</td><td align="center">4</td><td align="right">~1h 30m</td></tr><tr><td>Publishing Reports</td><td align="center">1</td><td align="center">4</td><td align="right">~1h 40m</td></tr><tr><td>Capstone Project</td><td align="center">—</td><td align="center">1</td><td align="right">~2h 30m</td></tr><tr><td>Reference</td><td align="center">9</td><td align="center">—</td><td align="right">~5h 30m</td></tr><tr><td><strong>Total</strong></td><td align="center"><strong>17</strong></td><td align="center"><strong>22</strong></td><td align="right"><strong>~15h 30m</strong></td></tr></tbody></table>

{% stepper %}
{% step %}

### <i class="fa-rocket" style="color:blue;">:rocket:</i> Before You Start

`1 workshop · ~5m`

How to get the best from this lab guide — read this five-minute orientation before you begin the course.

<figure><img src="https://1021209504-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fu2m9COjKaS0E9nT7B9bQ%2Fuploads%2FvOxRnS8stCo620OBrCrh%2Frd-lab-setup.svg?alt=media" alt="Report Designer runs a report&#x27;s query against the SampleData HSQLDB database on port 9001 through its SampleData (Hypersonic) connection and publishes the .prpt to the reporting engine on the Pentaho Server; the User Console opens published reports and the engine runs the report&#x27;s query against SampleData again; the server keeps its repository in PostgreSQL on port 5432"><figcaption><p>Report Designer, the Pentaho Server and the sample data</p></figcaption></figure>

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Before You Start</td><td>~5m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-compass" style="color:blue;">:compass:</i> Navigating Report Designer

`1 reading · 1 workshop · ~20m`

Tour the Report Designer workspace: welcome screen, toolbars, tabs, palettes, and previewing sample reports.

<figure><img src="https://1021209504-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fu2m9COjKaS0E9nT7B9bQ%2Fuploads%2F2MdiReDyRdN3J91crmfA%2Freport-bands.svg?alt=media" alt="Two pages of a product report grouped by product line. Page 1 prints the Page Header, the Report Header, then the Classic Cars group: Group Header, Details Header, a Details band per row and Group Footer, then the start of Motorcycles and a Page Footer, page 1 of 12. The last page prints the Page Header, the Vintage Cars group, the Report Footer and page 12 of 12"><figcaption><p>When each band prints, on the first page and the last</p></figcaption></figure>

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview of Report Designer</td><td>~10m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Navigating Report Designer</td><td>~10m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-database" style="color:blue;">:database:</i> Data Sources & Queries

`1 reading · 1 workshop · ~30m`

Connect Report Designer to your data: JDBC connections, queries, and the data sets that drive every report.

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview of Data Sources &#x26; Queries</td><td>~20m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Connect to a JDBC Data Source</td><td>~10m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-table" style="color:blue;">:table:</i> Report Elements & Groups

`1 reading · 2 workshops · ~50m`

Lay out data elements on the canvas and group rows into report sections with headers and footers.

<figure><img src="https://1021209504-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fu2m9COjKaS0E9nT7B9bQ%2Fuploads%2FaxGe2ozb5SJOhLCniuTB%2Fgroup-by-sorted-rows.svg?alt=media" alt="The same four rows, sorted and unsorted. Sorted by PRODUCTLINE, three Classic Cars rows and one Motorcycles row print as two groups, each with one Group Header and Group Footer. Unsorted, with Motorcycles third, they print three groups: the fourth row, Classic Cars again, starts a second Classic Cars group. The group stores only group-fields set to PRODUCTLINE"><figcaption><p>A group starts wherever PRODUCTLINE changes from the row before</p></figcaption></figure>

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview of Report Elements &#x26; Groups</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Adding Data Elements and Report Groups</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Practice: Data Elements and Report Groups</td><td>~20m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-calculator" style="color:blue;">:calculator:</i> Calculations

`1 reading · 3 workshops · ~1h`

Add formulas and functions to reports: conditional formatting driven by data, and group / report totals.

<figure><img src="https://1021209504-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fu2m9COjKaS0E9nT7B9bQ%2Fuploads%2Fmy7lyhuSSWjNj6ZsD6ue%2Ftwo-pass-engine.svg?alt=media" alt="The reporting engine reads the query rows in two passes: the pagination pass lays out every row to find the page breaks, the page count and each group total; the print pass prints the pages, rendered as Preview, PDF, Excel, HTML or CSV. In the Classic Cars group, Sum shows 5,844,033 in the Group Header, every Details row and the Group Footer; ItemSumFunction is complete only in the footer"><figcaption><p>The engine's two passes, and where each kind of sum is right</p></figcaption></figure>

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview of Calculations</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Conditional Formatting</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Totals</td><td>~10m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Practice: Calculations</td><td>~20m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-paintbrush" style="color:blue;">:paintbrush:</i> Formatting the Report

`1 reading · 3 workshops · ~50m`

Polish the report: headers, footers, fonts, spacing, and the visual details that make reports read well.

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview of Report Formatting</td><td>~10m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Formatting Report Headers &#x26; Footers</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Formatting the Report</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Practice: Formatting</td><td>~10m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-sliders" style="color:blue;">:sliders:</i> Report Parameters

`1 reading · 2 workshops · ~45m`

Let report users filter at run time with parameters — prompts, defaults, and parameter-driven queries.

<figure><img src="https://1021209504-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fu2m9COjKaS0E9nT7B9bQ%2Fuploads%2Ff9NK7hhtYSWsPR85yh89%2Fparameter-flow.svg?alt=media" alt="Each prompt has its own query: prod_list, 7 rows, fills the product_var drop-down, default Classic Cars; country_list, 27 rows, fills country_var, default Australia. The chosen values go into Query 1, where the SQL data factory turns each into a ? bind marker and SampleData runs the prepared statement. A dashed arrow marks a cascading prompt, if country_list named product_var"><figcaption><p>Where a prompt's choices come from, and where its value goes</p></figcaption></figure>

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview of Report Parameters</td><td>~10m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Report Parameters</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Practice: Parameters</td><td>~20m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-chart-column" style="color:blue;">:chart-column:</i> Charts & Sub Reports

`1 reading · 4 workshops · ~1h 30m`

Visualise data with charts, embed sub-reports, and build drill-down interactions between them.

<figure><img src="https://1021209504-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fu2m9COjKaS0E9nT7B9bQ%2Fuploads%2FMW9g8uBnm2LzLzVAQJ1g%2Fsubreport-runs.svg?alt=media" alt="A sub-report runs once each time its band prints: once in the Report Header, once per product line in a Group Header, and once per row in the Details band. A banded sub-report prints at the left edge of its parent band; an inline sub-report prints at its element&#x27;s x and y, here 4.5 inches, beside the radar chart"><figcaption><p>How often a sub-report runs, and where banded and inline sub-reports print</p></figcaption></figure>

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview of Charts &#x26; Sub Reports</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Charts &#x26; Sub Reports</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Drilldown Charts</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Multiple Sub Reports</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Practice: Charts &#x26; Sub Reports</td><td>~30m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-cloud-arrow-up" style="color:blue;">:cloud-arrow-up:</i> Publishing Reports

`1 reading · 4 workshops · ~1h 40m`

Publish finished reports to the BA repository, link reports together with hyperlinks, and burst one report by territory: a schedule per regional manager, each emailing that territory's PDF.

<figure><img src="https://1021209504-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fu2m9COjKaS0E9nT7B9bQ%2Fuploads%2F0sm0nwocB2M12tP4pj9c%2Freport-burst.svg?alt=media" alt="The published Regional Sales report and its three schedules: Regional Sales EMEA with TERRITORY EMEA, APAC with APAC and Japan, and NA with NA, each with its own _SCH_EMAIL_TO. Each background run writes its PDF to /home/admin and hands it to the mail sender, which sends it over SMTP on port 1025 to Mailpit, where the inbox holds one email per manager"><figcaption><p>One report, three schedules, three emails</p></figcaption></figure>

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview of Publishing</td><td>~10m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Publishing Reports</td><td>~20m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Hyperlinks</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Practice: Publishing</td><td>~15m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Report Bursting</td><td>~40m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-trophy" style="color:blue;">:trophy:</i> Capstone Project

`1 workshop · ~2h 30m`

Build, chart, parameterise, and publish a management-ready regional sales report — every module in one project.

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Regional Sales Report</td><td>~2h 30m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-book" style="color:blue;">:book:</i> Reference

`9 readings · ~5h 30m`

Appendices from the course manual: data sources, chart types, environment variables, and report templates.

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Data Sources Reference</td><td>~1h</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Charts Reference</td><td>~1h</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Environment Variables Reference</td><td>~50m</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Report Templates Reference</td><td>~25m</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Report Functions Reference</td><td>~30m</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Common Formulas Reference</td><td>~25m</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Style Properties Reference</td><td>~35m</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Output Parameterization Reference</td><td>~25m</td></tr><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Course Files</td><td>~20m</td></tr></tbody></table>

</details>
{% endstep %}
{% endstepper %}

***

<h3 align="center">Exam &#x26; accreditation</h3>

{% columns %}
{% column %}
{% hint style="info" icon="clipboard-check" %}
**The course exam**

40 questions drawn at random from a pool of 50, covering the taught modules. The pass mark is 80%. It's open-book: browse any module or ask the AI assistant while you work. The Capstone Project is assessed by its own lab checks rather than by the exam.
{% endhint %}
{% endcolumn %}

{% column %}
{% hint style="warning" icon="file-certificate" %}
**Course accreditation**

Finish the lessons and workshops, pass the exam and complete the capstone's checks, and you'll automatically be able to download your course accreditation. It states your name, the course and the Pentaho version you studied against, and is valid for two years. The exam is self-paced and not proctored. REPLACE-ME — the course names the accreditation "Pentaho Report Designer"; confirm the name.

This course is the fourth step on the Certified Solution Analyst learning path: Business Analyst, then Schema Workbench, Metadata Editor, Report Designer and CTools, leading to the Certified Solution Analyst credential — which closes with a proctored exam delivered through Kryterion's Webassessor.
{% endhint %}
{% endcolumn %}
{% endcolumns %}

***

<p align="center"><a href="https://academy.pentaho.com/solution-analyst-path-sandbox/solution-analyst.md" class="button secondary" data-icon="arrow-left">Back to the Solution Analyst path</a></p>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://academy.pentaho.com/solution-analyst-path-sandbox/solution-analyst/report-designer.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
