Search icon CANCEL
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Pentaho 5.0 Reporting by Example: Beginner's Guide

You're reading from  Pentaho 5.0 Reporting by Example: Beginner's Guide

Product type Book
Published in Aug 2013
Publisher Packt
ISBN-13 9781782162247
Pages 342 pages
Edition 1st Edition
Languages
Author (1):
Mariano, GARCIA MATTIO Mariano, GARCIA MATTIO
Profile icon Mariano, GARCIA MATTIO

Table of Contents (23) Chapters

Pentaho 5.0 Reporting by Example
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 5. Adding a Relational Data Source 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 Sakila DB Data Dictionary Pop Quiz Answers Index

Index

A

  • active / The customer table
  • actor table
    • actor_id / The actor table
    • first_name / The actor table
    • last_name / The actor table
    • last_update / The actor table
  • Add Functions... option / Time for action – adding functions
  • Add Parameter... option / Time for action – creating nested parameters
  • address / The address table
  • address2 / The address table
  • address table columns
    • address_id / The address table
    • address / The address table
    • address2 / The address table
    • district / The address table
    • city_id / The address table
    • postal_code / The address table
    • phone / The address table
    • last_update / The address table
  • address_id / The customer table, The address table
  • Administration perspective / The Administration perspective
  • Advanced Options option / Uploading reports
  • agregation functions
    • about / Aggregation functions
    • using, for style configuration / Time for action – using functions to configure styles
  • Apache Tomcat
    • about / Learning Apache Tomcat
    • installing / Time for action – installing and starting Apache Tomcat, What just happened?
    • starting / Time for action – installing and starting Apache Tomcat, What just happened?
  • API
    • about / Learning about JDBC driver
  • Application Programming Interface (API) / Time for action – configuration of libraries and the PRD report
  • Applications section / Time for action – creating a standalone application
  • area chart
    • about / The area chart
  • attributes / Style and Attributes
  • Attributes.group characteristic / What just happened?

B

  • Band field / Insertable objects
  • bar chart
    • about / Starting practice, The bar chart
    • creating / Time for action – creating a bar chart, What just happened?
  • barline chart / The barline chart
  • Bar sparkline / Learning about sparklines
  • Bar sparkline field / Insertable objects
  • Browse Files perspective / The Browse Files perspective
  • bubble chart / The bubble chart
  • business / Business
    • store table / The store table
    • rental table / The rental table
    • payment table / The payment table
  • business.customer data table
    • customer_id / The customer table
    • store_id / The customer table
    • first_name / The customer table
    • last_name / The customer table
    • address_id / The customer table
    • active / The customer table
    • create_date / The customer table
    • last_update / The customer table
    • address table / The address table
    • city table / The city table
    • country table / The country table, Inventory
  • business database
    • staff table / The staff table
    • about / The staff table
  • buyer report / The buyer report

C

  • Call Web Service button / HTML actions
  • category table
    • category_id / The category table
    • category / The category table
    • last_update / The category table
  • category_id / The category table
  • CDF / Main features of Pentaho Report Designer
  • charset
    • about / Encoding charset
    • encoding / Encoding charset
  • Chart field / Insertable objects
  • charts
    • JFreeChart / Charts
    • configuring / Creating and configuring charts
    • types / Types of charts, The bar chart, The line chart, The area chart, The pie chart, The multipie chart, The barline chart, The bubble chart, The scatter-plot chart, The XY bar chart, The XY line chart, The XY area chart, The waterfall chart, The radar chart, The XY area line chart
    • report section, relation / The relationship between charts and report sections, Have a go hero
    • Hyperlink / Time for action – hyperlinks in charts, What just happened?
  • charts, types
    • bar chart / The bar chart
    • line chart / The line chart
    • area chart / The area chart
    • pie chart / The pie chart
    • multipie chart / The multipie chart
    • barline chart / The barline chart
    • ring chart / The ring chart
    • bubble chart / The bubble chart
    • scatter-plot chart / The scatter-plot chart
    • XY bar chart / The XY bar chart
    • XY line chart / The XY line chart
    • XY area chart / The XY area chart
    • extended XY line chart / The extended XY line chart
    • waterfall chart / The waterfall chart
    • radar chart / The radar chart
    • XY area line chart / The XY area line chart
  • Check Box / Parameters
  • city / The city table
  • city table columns
    • city_id / The city table
    • city / The city table
    • country_id / The city table
    • last_update / The city table
  • city_id / The address table, The city table
  • code components
    • creating / Code components
    • context Listener, creating / Time for action – creating a context Listener
    • web client, creating / Time for action – creating a web client
    • standalone application, creating / Time for action – creating a standalone application, What just happened?
  • CONCATENATE function / The formula editor
  • Connection Configuration window / Time for action – creating a new data set
  • contextInitialized() method / Time for action – creating a context Listener
  • Count functions / Pop quiz – JDBC, Functions, and Encoding Charset
  • country_id / The city table
  • create_date / The customer table
  • Crosstabs editor
    • about / Crosstabs editor
    • layout, configuring / Time for action – configuring the layout, Have a go hero
  • Ctrl key / Time for action – adding parameters
  • customer data / Customer Data
  • customer_id / The customer table

D

  • data
    • defining / Types of reports
  • Data Panel / Time for action – creating a new data set
  • data panel
    • about / The Data panel
    • data sets / The Data panel
    • functions / The Data panel
    • environment / The Data panel
    • parameters / The Data panel
  • data sets based table
    • creating / Time for action – creating a new report and creating a table based on data sets
  • Date field / Insertable objects
  • Date Picker / Parameters
  • Default Value field / Pop quiz – formulas
  • Default Value Formula option / Time for action – adding parameters
  • description / The film table
  • details
    • configuring / Time for action – configuring details, What just happened?
    • adding, to report / Time for action – adding more details, What just happened?
  • Details Footer section
    • configuring / Time for action – configuring the Details Footer section
  • Details Header sections
    • configuring / Time for action – configuring the Report Header and Details Header sections, What just happened?
  • district / The address table
  • Document Object Model (DOM) / Time for action – creating a web client
  • Drop Down / Parameters
  • Dynamic Web project
    • creating / Time for action – creating a new Dynamic Web project

E

  • Eclipse
    • about / Learning Eclipse and WTP
  • Eclipse Perspectives
    • configuring / Configuring Eclipse Perspectives
  • Eclipse WTP
    • installing / Time for action – installing and initiating Eclipse WTP, What just happened?
    • initiating / Time for action – installing and initiating Eclipse WTP, What just happened?
  • Edit Group... option / Learning more about groups
  • Editor area / Configuring Eclipse Perspectives
  • Edit Query... option / Time for action – creating nested parameters
  • EJB / Learning JEE
  • Ellipse field / Insertable objects
  • email / The customer table
  • Embed In Report option / Time for action – adding more details
  • environment variables
    • about / Learning about environment variables
    • in PRD / Environment variables in PRD
    • using / Using the environment variables
    • Cascading Style Sheets (CSS), using / Learning CSS
    • CSS, applying / Applying CSS
    • layout, configuring / Time for action – configuring the layout
  • Environment Variables... option / Time for action – installing JDK and configuring the environment variables
  • environment variables layout
    • configuring / Time for action – configuring the layout, What just happened?
    • style sheet, creating / Time for action – creating and applying our stylesheet, What just happened?
    • stylesheet, applying / Time for action – creating and applying our stylesheet, What just happened?
  • Expression Language (EL) 2.2 / Learning Apache Tomcat
  • extended XY line chart / The extended XY line chart

F

  • features, PRD
    • Reporting algorithm / Main features of Pentaho Report Designer
    • Diverse data sources / Main features of Pentaho Report Designer
    • Diverse output formats / Main features of Pentaho Report Designer
    • Insertable objects / Main features of Pentaho Report Designer
    • graphs / Main features of Pentaho Report Designer
    • parameterization / Main features of Pentaho Report Designer
    • formulas and style expressions / Main features of Pentaho Report Designer
    • cross-tab report / Main features of Pentaho Report Designer
    • nteractive reports / Main features of Pentaho Report Designer
    • wizard / Main features of Pentaho Report Designer
    • publication / Main features of Pentaho Report Designer
    • Java API / Main features of Pentaho Report Designer
    • extendibility / Main features of Pentaho Report Designer
    • stylesheet support / Main features of Pentaho Report Designer
    • Pentaho suite integration / Main features of Pentaho Report Designer
    • Pentaho Data Integration / Main features of Pentaho Report Designer
    • Abstraction layers / Main features of Pentaho Report Designer
  • film table
    • film_id / The film table
    • title / The film table
    • description / The film table
    • release_year / The film table
    • language_id / The film table
    • original_language_id / The film table
    • rental_duration / The film table
    • rental_rate / The film table
    • length / The film table
    • replacement_cost / The film table
    • rating / The film table
    • special_features / The film table
    • last_update / The film table
  • film_actor table
    • film_id / The film_actor table
    • actor_id / The film_actor table
    • last_update / The film_actor table
  • film_category table
    • film_id / The film_category table
    • category_id / The film_category table
    • last_update / The film_category table
  • film_id / The film table
  • film_text table
    • film_id / The film_text table
    • title / The film_text table
    • description / The film_text table
  • first Subreport
    • creating / Time for action – creating our first Subreport
    • configuring / Time for action – configuring our first Subreport, What just happened?
  • first_name / The customer table
  • format tools / Format tools
  • formula editor
    • about / The formula editor
    • new formula, creating / Time for action – creating a new formula, What just happened?
    • formula, styling with / Time for action – styles with formulas, What just happened?, Have a go hero
  • formulas
    • managing / Formulas
    • creating / Creating formulas
    • formula editor / The formula editor
  • FOSS / Learning JEE
  • functions
    • adding, to report / Time for action – adding functions
    • modifying / Time for action – modifying functions and page breaks, What just happened?

G

  • general layout, PUC
    • about / General layout of Pentaho User Console
    • Home perspective / The Home perspective
    • Browse Files perspective / The Browse Files perspective
    • Opened perspective / The Opened perspective
    • Schedules perspective / The Schedules perspective
    • Administration perspective / The Administration perspective
  • Generate web.xml deployment descriptor option / Time for action – creating a new Dynamic Web project
  • get values button / HTML actions
  • graphs
    • sparklines / Main features of Pentaho Report Designer
    • JFreeChart graphs / Main features of Pentaho Report Designer
  • Group Footer section / Have a go hero
  • Group Header section / Time for action – configuring the layout
  • groups
    • about / Learning more about groups, Have a go hero
    • Name field / Learning more about groups
    • Available Fields / Learning more about groups
    • Selected Fields / Learning more about groups
  • Group section
    • about / Configuring the Group section
    • configuring / Time for action – adding groups, What just happened?

H

  • helper reports / Types of reports
  • Help | Sample Reports | Advanced | HTML Actions / HTML actions
  • Help | Sample Reports | Operational Reports | Buyer Report / Have a go hero
  • history, PRD
    • about / History
  • Home perspective / The Home perspective
  • horizontal-line / Time for action – modifying the header and detail
  • Horizontal line field / Insertable objects
  • HTML Actions / HTML actions
  • Hyperlink
    • about / Learning about hyperlinks
    • link / Learning about hyperlinks
    • target / Learning about hyperlinks
    • types, in PRD / Types of hyperlinks in PRD
    • PRD and Pentaho BI Server interaction / Interaction between PRD and Pentaho BA Server
    • creating / Time for action – creating our first hyperlink
    • in charts / Time for action – hyperlinks in charts, What just happened?
  • Hyperlink types, in PRD
    • self / Types of hyperlinks in PRD
    • URL / Types of hyperlinks in PRD
    • Pentaho Repository / Types of hyperlinks in PRD
    • Manual linking / Types of hyperlinks in PRD

I

  • IDE / Learning Eclipse and WTP
  • Image field / Insertable objects
  • Image field field / Insertable objects
  • Import Spreadsheet / Time for action – creating a new report and creating a table based on data sets
  • income statement / The income statement
  • Index / Insertable objects
  • information
    • defining / Types of reports
  • infrastructure configurations
    • about / Time for action – creating a Tomcat instance
    • JNDI/JDBC connection pool, setting / Time for action – setting a JNDI/JDBC connection pool
    • PRD report configuration / Time for action – configuration of libraries and the PRD report
    • libraries, configuring / Time for action – configuration of libraries and the PRD report, What just happened?
  • insertable objects
    • about / Insertable objects
    • label / Insertable objects
    • Text field / Insertable objects
    • number field / Insertable objects
    • data field / Insertable objects
    • message / Insertable objects
    • resource label / Insertable objects
    • Resource field / Insertable objects
    • Resource message / Insertable objects
    • Image field / Insertable objects
    • Image / Insertable objects
    • Ellipse / Insertable objects
    • Rectangle / Insertable objects
    • Horizontal line / Insertable objects
    • Vertical line / Insertable objects
    • Survey scale / Insertable objects
    • Bar sparkline / Insertable objects
    • Line sparkline / Insertable objects
    • Pie sparkline / Insertable objects
    • Band / Insertable objects
    • Subreport / Insertable objects
    • Table of content / Insertable objects
    • Index / Insertable objects
  • installing
    • Sakila database / Time for action – downloading and installing Sakila DB
  • inventory / Inventory
  • inventory databas
    • film table / The film table
    • category table / The category table
    • film_category table / The film_category table
    • language table / The language table
    • actor table / The actor table
    • film_actor table / The film_actor table
    • inventory table / The inventory table
    • film_text / The film_text table
  • inventory list / The inventory list
  • inventory table
    • inventory_id / The inventory table
    • film_id / The inventory table
    • store_id / The inventory table
    • last_update / The inventory table
  • Inventory table / Inventory
  • invoice / Invoice

J

  • Jasper / Learning Apache Tomcat
  • Java Development Toolkit (JDT) / Learning Eclipse and WTP
  • Java Naming and Directory Interface (JNDI) / Time for action – setting a JNDI/JDBC connection pool
  • Java Runtime Environment (JRE) / System requirements
  • Java Virtual Machine (JVM) / System requirements
  • JDBC
    • about / Learning about JDBC driver
  • JDBC driver
    • about / Learning about JDBC driver
    • using, requirements / Learning about JDBC driver
    • implementation details / Learning about JDBC driver
    • configuring / Time for action – configuring drivers
  • JDK
    • installing, on LINUX environment / Time for action – installing JDK and configuring the environment variables
    • installing, in In Windows environments / Time for action – installing JDK and configuring the environment variables
  • JEE
    • about / Learning JEE
  • JEE components
    • Servlets / Learning JEE
    • JSP / Learning JEE
    • EJB / Learning JEE
    • Web Services (WS)Topicn / Learning JEE
  • JFreeChart / Charts
  • JNDI/JDBC connection pool
    • setting / Time for action – setting a JNDI/JDBC connection pool
  • JRE / System requirements
  • Juno / Learning Eclipse and WTP

L

  • label / Time for action – modifying the header and detail
  • Label object / Insertable objects
  • language table
    • language_id / The language table
    • language / The language table
    • last_update / The language table
  • language_id / The film table
  • last_name / The customer table
  • last_update / The customer table, The address table, The city table, The film table
  • layout
    • configuring / Time for action – configuring the layout
  • length / The film table
  • line chart
    • about / The line chart
  • Line sparkline / Learning about sparklines
  • Line sparkline field / Insertable objects
  • Link To option / Time for action – adding more details
  • ListOfMonths parameter / What just happened?
  • ListOfYears parameter / What just happened?
  • logo, Pentaho / Learning Pentaho

M

  • memory indicator / Message section and memory indicator, Have a go hero
  • menu bar / The menu bar
  • Message field / Insertable objects
  • message section / Message section and memory indicator
  • multipie chart / The multipie chart
  • Multi Selection Button / Parameters
  • Multi Value List / Parameters
  • MULTIVALUEQUERY function / Time for action – creating our first sparkline
  • MySQL / Learning the Sakila database

N

  • nested parameters
    • creating / Time for action – creating nested parameters, What just happened?, Have a go hero
  • new data set
    • creating / Time for action – creating a new data set
    • header, modifying / Time for action – modifying the header and detail
    • details, modifying / Time for action – modifying the header and detail
    • report’s footer, modifying / Time for action – modifying the report's footer
  • New Folder... button / Creating a new solutions folder
  • new report
    • creating / Time for action – creating a new report and creating a table based on data sets, Time for action – creating a new report, What just happened?, Time for action – creating a new report
  • new solutions folder
    • creating / Creating a new solutions folder
    • reports, publishing in Pentaho BA Server / Time for action – publishing reports in Pentaho BA Server, What just happened?
    • reports, executing in Pentaho BA Server / Executing reports in Pentaho BA Server
    • schedule, creating / Creating a schedule
    • reports, uploading / Uploading reports, Have a go hero
  • Number-field type object / Time for action – creating a new formula
  • Number field / Insertable objects

O

  • oddEvenRowBanding function / Time for action – adding functions
  • OK button / Time for action – creating nested parameters
  • Opened perspective / The Opened perspective
  • Open Formula / Time for action – creating our first hyperlink
  • output types, PRD
    • exporting, in different formats / Time for action – exporting in different formats, What just happened?, Have a go hero

P

  • Page Header section / What just happened?
  • parameter
    • about / Parameters
    • adding / Time for action – adding parameters, What just happened?
    • nested parameters, creating / Time for action – creating nested parameters, What just happened?, Have a go hero
  • parameter, display types
    • Drop Down / Parameters
    • Single Value List / Parameters
    • Multi Value List / Parameters
    • Radio Button / Parameters
    • Check Box / Parameters
    • Single Selection Button / Parameters
    • Multi Selection Button / Parameters
    • Text Box / Parameters
    • Text Area / Parameters
    • Date Picker / Parameters
  • parameters
    • about / Parameters
    • display, types / Parameters
  • PATH variable / Time for action – installing JDK and configuring the environment variables
  • Payment History / Invoice
  • payment table
    • payment_id / The payment table
    • customer_id / The payment table
    • staff_id / The payment table
    • rental_id / The payment table
    • amount / The payment table
    • payment_date / The payment table
    • last_update / The payment table
    • screenshot / The payment table
  • Pentaho
    • about / Learning Pentaho
    • functionalities / Learning Pentaho
    • defining / Defining Pentaho
    • components / Pentaho components
    • probjects / Principal Pentaho projects
    • historical review / A brief historical review
    • characteristics / Principal characteristics of Pentaho
    • BA Server, downloading / Downloading Pentaho BA Server
    • system requirements / System requirements
  • Pentaho Aggregate Designer (PAD) / Principal Pentaho projects
  • Pentaho BA Server
    • downloading / Downloading Pentaho BA Server
  • Pentaho Data Integration (PDI) / Principal Pentaho projects
  • Pentaho Data Mining / Principal Pentaho projects
  • Pentaho Metadata Editor (PME) / Principal Pentaho projects
  • Pentaho Report Designer (PRD) / Principal Pentaho projects
  • Pentaho Reporting Engine / History
  • Pentaho Reporting Flow Engine / History
  • Pentaho Schema Workbench (PSW) / Principal Pentaho projects
  • phone / The address table
  • pie chart
    • about / Starting practice, The pie chart
    • creating / Time for action – creating a pie chart
  • Pie sparkline / Learning about sparklines
  • Pie sparkline field / Insertable objects
  • plugins / Learning Eclipse and WTP
  • postal_code / The address table
  • PRD
    • features / Main features of Pentaho Report Designer
    • Pentaho BI Server, publishing in / Main features of Pentaho Report Designer
    • history / History
    • environment, configuring / Configuring the environment
    • installing / Time for action – downloading, installing, and configuring PRD
    • downloading / Time for action – downloading, installing, and configuring PRD
    • configuring / Time for action – downloading, installing, and configuring PRD, What just happened?
    • starting / Starting PRD, Time for action – starting PRD and creating a new report, What just happened?
    • new report, creating / Time for action – starting PRD and creating a new report
    • layout / PRD layout
    • used, for report creating / Creating your first report with PRD
    • output types / Output types
    • about / Parameters, Subreports
    • Subreports / Subreports in PRD
    • Hyperlink, types / Types of hyperlinks in PRD
    • environment variables / Environment variables in PRD
    • Style sheets / Stylesheets in PRD
    • Style definition editor / The Style Definition Editor
  • PRD layout
    • about / PRD layout
    • work area / The Work area
    • insertable objects / Insertable objects
    • report tree structure / Report tree structure
    • style / Style and Attributes
    • attributes / Style and Attributes
    • data panel / The Data panel
    • menu bar / The menu bar
    • shortcuts / Shortcuts
    • tab section / The tab section
    • format tools / Format tools
    • message section / Message section and memory indicator, Have a go hero
    • memory indicator / Message section and memory indicator, Have a go hero
  • Preview option / Time for action – modifying the report's footer
  • previous report copy
    • creating / Time for action – making a copy of the previous report
  • probjects, Pentaho
    • Pentaho BA Server / Principal Pentaho projects
    • Pentaho User Console (PUC) / Principal Pentaho projects
    • Pentaho Report Designer (PRD) / Principal Pentaho projects
    • Pentaho Data Integration (PDI) / Principal Pentaho projects
    • Pentaho Analysis / Principal Pentaho projects
    • Pentaho Data Mining / Principal Pentaho projects
    • Pentaho Metadata Editor (PME) / Principal Pentaho projects
    • Pentaho Schema Workbench (PSW) / Principal Pentaho projects
    • Pentaho Aggregate Designer (PAD) / Principal Pentaho projects
    • Saiku / Principal Pentaho projects
    • CTools / Principal Pentaho projects
  • product sales / Product Sales
  • PUC
    • general layout / General layout of Pentaho User Console

R

  • radar chart / The radar chart
  • Radio Button / Parameters
  • rating / The film table
  • Rectangle field / Insertable objects
  • release_year / The film table
  • rental table
    • rental_id / The rental table
    • rental_date / The rental table
    • inventory_id / The rental table
    • customer_id / The rental table
    • return_date / The rental table
    • staff_id / The rental table
    • last_update / The rental table
  • rental_duration / The film table
  • rental_rate / The film table
  • replacement_cost / The film table
  • report
    • functions, adding / Time for action – adding functions
    • Details Footer section, configuring / Time for action – configuring the Details Footer section
    • details, adding / Time for action – adding more details, What just happened?
  • Report Header
    • configuring / Time for action – configuring the Report Header and Details Header sections, What just happened?
  • Reporting algorithm / Main features of Pentaho Report Designer
  • reports
    • types / Types of reports
    • examples / Examples of typical reports
    • buyer report / The buyer report
    • income statement / The income statement
    • inventory list / The inventory list
    • invoice / Invoice
    • product sales / Product Sales
    • Top N Customers / Top N Customers
    • HTML Actions / HTML actions
    • Subreports, relation / The relation between Reports and Subreports
    • uploading / Uploading reports, Have a go hero
  • reports, types
    • transactional reports / Types of reports
    • strategic reports / Types of reports
    • helper reports / Types of reports
  • report tree structure
    • about / Report tree structure
  • Report tree structure / Time for action – modifying the header and detail
  • Resource field field / Insertable objects
  • Resource label field / Insertable objects
  • Resource message field / Insertable objects
  • REST / Principal characteristics of Pentaho
  • Rich Client Application (RCA) / Learning Eclipse and WTP
  • Rich Text Format (RTF) / History
  • ring chart / The ring chart
  • Row Banding function / Time for action – adding functions, Time for action – creating a new report
  • Rules / Learning CSS

S

  • Saiku / Principal Pentaho projects
  • Sakila database
    • about / Learning the Sakila database
    • downloading / Time for action – downloading and installing Sakila DB
    • installing / Time for action – downloading and installing Sakila DB
  • Sakila database schema
    • about / The Sakila database schema
    • customer data / Customer Data
    • inventory / Inventory
    • business / Business, Have a go hero
  • scatter-plot chart / The scatter-plot chart
  • schedule
    • creating / Creating a schedule
  • Schedules perspective / The Schedules perspective
  • second Subreport
    • creating / Time for action – creating and configuring the second Subreport, What just happened?, Have a go hero
    • configuring / Time for action – creating and configuring the second Subreport, What just happened?, Have a go hero
  • SelectRating parameter / Time for action – adding parameters
  • Send Forward option / Time for action – configuring the layout
  • Service Oriented Architecture (SOA) / Principal characteristics of Pentaho
  • Shift key / Time for action – adding parameters
  • shortcuts / Shortcuts
  • Simple bar codes field / Insertable objects
  • Single Selection Button / Parameters
  • Single Value List / Parameters
  • Sparklines
    • about / Learning about sparklines
    • types, bar / Learning about sparklines
    • types, line / Learning about sparklines
    • types, pie / Learning about sparklines
    • creating / Time for action – creating our first sparkline, What just happened?, Have a go hero
  • special_features / The film table
  • SQL query
    • modifying / Time for action – modifying the SQL query, What just happened?
    • layout, configuring / Time for action – configuring the layout
  • staff table
    • staff_id / The staff table
    • first_name / The staff table
    • last_name / The staff table
    • address_id / The staff table
    • picture / The staff table
    • email / The staff table
    • store_id / The staff table
    • active / The staff table
    • username / The staff table
    • password / The staff table
    • last_update / The staff table
  • store table
    • store_id / The store table
    • manager_staff_id / The store table
    • address_id / The store table
    • last_update / The store table
  • store_id / The customer table
  • strategic reports / Types of reports
  • style / Style and Attributes
  • Style Definition Editor / Stylesheets in PRD, The Style Definition Editor
  • style sheet
    • about / Trying out stylesheets
    • crosstab / Learning about crosstabs
    • crosstab, in PRD / The crosstabs in PRD
    • crosstab, using / Using crosstabs
  • Subreport / Insertable objects
  • Subreports
    • creating / Time for action – creating a new report, What just happened?, Creating and configuring Subreports
    • about / Subreports
    • in PRD / Subreports in PRD
    • reports, relation / The relation between Reports and Subreports
    • section relation / The relation between sections of the Report and Subreports
    • configuring / Creating and configuring Subreports
    • Banded option / Creating and configuring Subreports
    • Inline option / Creating and configuring Subreports
    • opening / Opening and closing Subreports
    • closing / Opening and closing Subreports
  • Survey scale field / Insertable objects
  • system requirements, Pentaho / System requirements
    • Pentaho BA Server, installing / Time for action – installing and running Pentaho BA Server, What just happened?
    • Pentaho BA Server, running / Time for action – installing and running Pentaho BA Server, What just happened?

T

  • Table of content / Insertable objects
  • tab section / The tab section
  • tactical reports / Types of reports
  • Text-field type object / Time for action – creating a new formula
  • Text Area / Parameters
  • Text Box / Parameters
  • Text field / Insertable objects
  • title / The film table
  • tools
    • JEE / Learning JEE
    • Apache Tomcat / Learning Apache Tomcat
    • Eclipse / Learning Eclipse and WTP
    • WTP / Learning Eclipse and WTP
  • Top N Customers / Top N Customers
  • transactional reports / Types of reports

V

  • Vertical line line field / Insertable objects
  • View area / Configuring Eclipse Perspectives

W

  • WAR / Time for action – creating a standalone application
  • waterfall chart / The waterfall chart
  • Web Perspective / Configuring Eclipse Perspectives
  • Web Services (WS) / Learning JEE
  • work area / The Work area
  • WTP
    • about / Learning Eclipse and WTP

X

  • XY area chart / The XY area chart
  • XY area line chart / The XY area line chart
  • XY bar chart / The XY bar chart
  • XY line chart / The XY line chart
lock icon The rest of the chapter is locked
arrow left Previous Section
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}