- Pentaho 5.0 Reporting by Example
- Mariano García Mattío Dario R. Bernabeu
- 217字
- 2021-08-13 16:24:37
Chapter 5. Adding a Relational Data Source
In this chapter, we will create a copy of the report created in the previous chapter and modify it so that it takes its data from a relational source. We will explain what JDBC is, what a JDBC driver is, and how it is used.
The topics we will be covering in the chapter include the following:
- Downloading the JDBC driver for MySQL and copying it inside Pentaho Report Designer (PRD)
- Using the UI to create/edit JDBC-type data sets and creating a JDBC connection to our sakila database, with its corresponding SQL query
- Modifying the following sections: Report Header, Group Header, Details Header, and Details Footer; we will configure the last two to be repeated on each page
- Deleting certain objects from the report, adding some new ones, and modifying others so that they all correspond to our new data source
- Aggregation functions, explaining the most used ones; we will add a new function into our report and use its output in order to modify the style of a message
- Understanding and modifying the charset of our report
As an extra, we will invite you to create your own report from the ground up, as well as give you a few tips to assist you in its creation.
推薦閱讀
- Excel2019高級進階：SQL應用
- Excel 2010辦公應用實戰從入門到精通（超值版）
- Power BI零售數據分析實戰
- Word／Excel／PPT三合一商務辦公應用從入門到精通
- Excel效率手冊：早做完，不加班 （ 精華版·函數篇）（升級版）
- 新編電腦選購、組裝、維護與故障處理從入門到精通
- 微軟辦公軟件國際認證（MOS）Office 2010大師級通關教程（第2版）
- 零基礎學游戲UI設計
- Excel2010辦公專家從入門到精通（精編版）
- ChatGPT+Excel高效數據計算與處理（視頻教學版）
- PowerPoint 2016從入門到精通
- PPT 2016幻燈片設計與制作從新手到高手
- Access數據庫程序設計實踐教程
- Excel函數、圖表與透視表從入門到精通（全新版）
- 文形色構，職場人士必修的PPT演示設計課