Chapter 8, Using Formulas in Our Reports
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
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.