Time for action – configuring drivers
by Dario R. Bernabeu, Mariano García Mattío
Pentaho 5.0 Reporting by Example Beginner’s Guide
- Pentaho 5.0 Reporting by Example Beginner’s Guide
- Table of Contents
- Pentaho 5.0 Reporting by Example Beginner’s Guide
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. What is Pentaho Report Designer?
- 2. Installation and Configuration
- 3. Start PRD and the User Interface (UI) Layout
- 4. Instant Gratification – Creating Your First Report with PRD
- Creating your first report with PRD
- Time for action – creating a new report and creating a table based on data sets
- Time for action – configuring the Report Header and Details Header sections
- Time for action – configuring details
- The second half of the report
- Time for action – adding functions
- Time for action – configuring the Details Footer section
- Time for action – adding more details
- Output types
- Time for action – exporting in different formats
- Summary
- 5. Adding a Relational Data Source
- Learning about JDBC driver
- Time for action – configuring drivers
- Creating a new data set
- Time for action – creating a new data set
- Time for action – modifying the header and detail
- Time for action – modifying the report's footer
- Aggregation functions
- Time for action – using functions to configure styles
- Encoding charset
- Summary
- 6. Adding Groups
- 7. Adding Parameters
- 8. Using Formulas in Our Reports
- 9. Adding Charts
- 10. Adding Subreports
- 11. Publishing and Running Reports in Pentaho BA Server
- 12. Making a Difference – Reports with Hyperlinks and Sparklines
- 13. Environment Variables, Stylesheets, and Crosstabs
- 14. PRD Reports Embedded in Web Applications
- Tools and technologies we will be using
- Time for action – installing and starting Apache Tomcat
- Time for action – installing and initiating Eclipse WTP
- Time for action – creating a new Dynamic Web project
- Time for action – creating a Tomcat instance
- Time for action – setting a JNDI/JDBC connection pool
- Time for action – configuration of libraries and the PRD report
- Time for action – creating a context Listener
- Time for action – creating a web client
- Time for action – creating a standalone application
- Summary
- A. Sakila DB Data Dictionary
- B. Pop Quiz Answers
- Chapter 2, Installation and Configuration
- Chapter 3, Start PRD and the User Interface (UI) Layout
- Chapter 4, Instant Gratification – creating your first report with PRD
- Chapter 5, Adding a Relational Data Source
- Chapter 6, Adding Groups
- Chapter 7, Adding Parameters
- Chapter 8, Using Formulas in Our Reports
- Chapter 9, Adding Charts
- Chapter 10, Adding Subreports
- Chapter 11, Publish and Run Reports in Pentaho BA Server
- Chapter 12, Making a Difference – Reports with Hyperlinks and Sparklines
- Chapter 13, Environment, Stylesheets, and Crosstabs
- Chapter 14, PRD Reports Embedded in Web Applications
- Index
At this time, we will download the JDBC driver from the official MySQL assets and then copy it into the Pentaho Report Designer.
In order to download the MySQL JDBC driver we will open the following web page: http://dev.mysql.com/downloads/connector/j/5.1.html.
- Move downwards in the page and find the tab named Generally Available (GA) Releases. We will choose the right file, depending on our operative system, from the following choices:
- mysql-connector-java-x.x.xx.tar.gz
- mysql-connector-java.x.x.xx.zip
- Click on the Download button and follow the steps to perform the download.
In order for PRD to be able to make use of the recently downloaded JDBC driver, we need to copy it to a certain path.
- Open the compressed file we just downloaded and browse its contents until we locate the JDBC driver:
mysql-connector-java-x.x.xx-bin.jar. - Copy this
.jarto[PRD_HOME]/lib/jdbc. - For the PRD to load the JDBC driver we just added, we need to restart the PRD.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.