Skip to main content

Post 13: iReport: Inserting a heading for a group of records part 1

Inserting a heading for a group of records 
You may need to display headings for a subset of records in your report at certain places. For example, if you are generating a weekly or monthly report of all customer invoices, you may
want to display a heading for each subset or group of records corresponding to an individual customer. This is sometimes convenient, as it allows you to generate just one report (that is,
a report of all invoices issued in a month), which actually consists of many reports (that is, a report for each of your customers).
 

JasperReports offers an interesting feature known as grouping of records, which you can use to do many tricks in report designing. This recipe demonstrates how to use the grouping feature to generate a dynamic heading for a group corresponding to a customer name in your report.

Getting ready 
Refer to the Post6:  iReport: Installation of PostgreSQL, which shows how you can install and run PostgreSQL. Note that your installation of PostgreSQL should be up and running before you proceed.


Refer to the post named Copy Sample Data Into Postgres  which helps you to create a database named jasperdb2 and copy sample data for this post into the database. 

How to do it...
1. Create the SimpleGroupWithHeader.jrxml file such that  Designer tab of iReport shows a report with a title Māsika Customer Invoices, as shown next:




for more information you can refer Post 12: iReport: Creating a simple table of records along with labels for each column

2.  Switch to the Preview tab to see a current preview of your report. You will see a  simple table with an arrangement of records, as shown in the following screenshot:

 

3.  Switch to the Designer tab. Right-click on the top-most element
SimpleGroupWithHeader in the Report Inspector window (on the left side of the Designer tab). A pop-up menu will appear. Click onAdd Report Groupoption in the pop-up menu, as shown in the following screenshot 



4.  A New group wizard dialog will appear as shown follows:

 

5.Type Customer in the Group name field and select CustomerName in Group by the following report object drop-down list, as shown in the following screenshot:

6.  Press the Next button, the dialog will change as shown in the following screenshot:

7.Press the Press the Finish button to dismiss the dialog. You will notice Customer Group Header 1and Customer Group Footer 1 sections have been added into your report, as shown in the following screenshot:

8.  Switch to the Preview tab to see the preview of your report. You will see clear grouping of records based on customer names separated by wide spaces, as shown in the following screenshot:

 9.  Observe each page of your report and concentrate on customer names. You will notice that there are a number of groups for each customer spread randomly throughout the report, as shown in the following screenshot:  

10) Open the Report query window by clicking the report query button to the right of the Preview tab. unfortunately, it is a bit difficult to find this button in iReport as it shows no tool tip when you move your mouse over it. Its icon is similar in shape to a standard database icon and looks like . A Report query window will appear, as shown in the following screenshot:

 

 

Post 13: iReport: Inserting a heading for a group of records  part 2


Comments

Popular posts from this blog

Index: JSF

Java Server Faces Basics Post 1: JSF : Introduction to JSF  Post 2: JSF:  configuration files  Post 3: JSF: Installation Post 4: JSF: Your first JSF project   Standard JSF Tags Post 1: JSF: textbox example Post 2: JSF: password example Post 3: JSF: textarea example JSF 2 GraphicImage Example Post 4: JSF: GraphicImage Example Post 101 : JSF : The valueChangeListener Attribute Example

Index: iReport

iReport for Java ------------------------------------------------------------ Titles and Headers ------------------------------------------------------------ Post 1: iReport : Downloading, installing, and running JasperReports and iReport Post 2: iReport : Creating your first "Hello World" report   Post 3: iReport : Understanding iReport Elements Post 4: iReport : Creating and sizing the title for your report Post 5: iReport: Inserting a company logo in the title of your report  Post 6: iReport : Installation of PostgreSQL Post 7: iReport : Creating a report from relational data Post 8: iReport : Using dynamic titles that can change during report processing. Post 9: iReport : Adding a simple header to your report Post 10: iReport : Setting margins for your report and aligning the report header relative to report margins  ------------------------------------------------------------ Body and Footer ---------------------------------------------------------...