dynamic jasper report

[sudeepjee srivastava]

HI All I wanted to add dynamically the number of columns in my report, means the number of columns in my report would increase based on the search criterion selected by the user.
Note -: I wanted to do this in a single jrxml file
any solutions with a small code snippet would be welcomed.

[Nilesh Padmawar]

Hi sudeepjee,

kindly look at the following link:

http://dynamicjasper.sourceforge.net/

It's all dynamic jasper report , you can add columns at runtime.
if you need any example please let me know.
recently i have developed one sample app with dynamicJasper2.0.9

Regards,
Nils- Not anather java developer

[arehman habib]

i want to see how you implemented it

[Nilesh Padmawar]

Hi Sivasundaram,
Send me your mail id.

-
Nils

[Harika emm]

Hi
I am working on jasper reports which has to be generated dynamically
here in my project
user will have a page where he can select the department, starting data and end date to view the report in pdf
so my report generation is dynamic so please help me in this with an example code

thanku..

[Nilesh Padmawar]

Sorry for late reply.
Please send me your mail id through private massage.

--
Nils
Not Another Java Developer

[Martijn Verburg]

Hi all,

Please remember to UseTheForumNotEmail!

[Nilesh Padmawar]

Hi all,
It’s now all easy to understand the DynamicJasper api and I am happy that people are loving it like me. As author mention in the site (DynamicJasper) that "DynamicJasper (DJ) is an open source library that hides the complexity of Jasper Reports, it helps developers to save time when designing simple/medium complexity reports generating the layout of the report elements automatically"
And it’s really working!!!

From last 6 to 7 months I am working on Dynamic Jasper Reports and getting more involved in the project.

In parallel, I was working on sample java app through which we can preview the design view and output report. It is base on DynamicJasper-3.0.2-test-project provided by Dj.

As it is a more than one file I can not post it directly.

--
Nils- Not another java developer

[Nilesh Padmawar]

For your convinience , here is my main class.....
Check out imported packages and lib

Library file required:
commons-beanutils-1.7.0.jar
commons-codec-1.3.jar
commons-collections-3.1.jar
commons-digester-1.7.jar
commons-discovery-0.2.jar
commons-el-1.0.jar
commons-fileupload-1.0.jar
commons-javaflow-20060411.jar
commons-lang-2.1.jar
commons-logging-1.0.4.jar
commons-validator-1.2.0.jar
DynamicJasper-3.0.2.jar
el-api.jar
el-ri.jar
iText-2.1.2u.jar
jasperreports-3.0.0-applet.jar
jasperreports-3.0.0-javaflow.jar
jasperreports-3.0.0.jar
jdt-compiler-3.1.1.jar
jfreechart-1.0.0.jar
junit.jar
log4j-1.2.15.jar
mysql-connector-java-5.0.8-bin.jar
poi-3.0.1-FINAL-20070705.jar

Main Class:

 package com.nils.controller;
 
import java.awt.Color;
import java.util.Collection;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;
 
import com.nils.jasperhandler.ReportExporter;
import com.nils.jasperhandler.TestRepositoryProducts;
 
// import ar.com.fdvs.dj.domain.ColumnsGroupVariableOperation;
import net.sf.jasperreports.engine.JRDataSource;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;
import net.sf.jasperreports.view.JasperDesignViewer;
import net.sf.jasperreports.view.JasperViewer;
import ar.com.fdvs.dj.core.DJConstants;
import ar.com.fdvs.dj.core.DynamicJasperHelper;
import ar.com.fdvs.dj.core.layout.ClassicLayoutManager;
import ar.com.fdvs.dj.core.layout.LayoutManager;
import ar.com.fdvs.dj.core.layout.ListLayoutManager;
import ar.com.fdvs.dj.domain.AutoText;
import ar.com.fdvs.dj.domain.DJCalculation;
import ar.com.fdvs.dj.domain.DJCrosstab;
import ar.com.fdvs.dj.domain.DJCrosstabColumn;
import ar.com.fdvs.dj.domain.DJCrosstabRow;
import ar.com.fdvs.dj.domain.DynamicReport;
import ar.com.fdvs.dj.domain.Style;
import ar.com.fdvs.dj.domain.builders.ColumnBuilder;
import ar.com.fdvs.dj.domain.builders.CrosstabBuilder;
import ar.com.fdvs.dj.domain.builders.CrosstabColumnBuilder;
import ar.com.fdvs.dj.domain.builders.CrosstabRowBuilder;
import ar.com.fdvs.dj.domain.builders.DynamicReportBuilder;
import ar.com.fdvs.dj.domain.builders.FastReportBuilder;
import ar.com.fdvs.dj.domain.builders.GroupBuilder;
import ar.com.fdvs.dj.domain.builders.StyleBuilder;
import ar.com.fdvs.dj.domain.constants.Border;
import ar.com.fdvs.dj.domain.constants.Font;
import ar.com.fdvs.dj.domain.constants.GroupLayout;
import ar.com.fdvs.dj.domain.constants.HorizontalAlign;
import ar.com.fdvs.dj.domain.constants.Page;
import ar.com.fdvs.dj.domain.constants.Transparency;
import ar.com.fdvs.dj.domain.constants.VerticalAlign; // import
import ar.com.fdvs.dj.domain.entities.DJGroup;
import ar.com.fdvs.dj.domain.entities.columns.AbstractColumn;
import ar.com.fdvs.dj.domain.entities.columns.PropertyColumn;
// ar.com.fdvs.dj.test.BaseDjReportTest;
// import ar.com.fdvs.dj.test.TestRepositoryProducts;
import ar.com.fdvs.dj.util.SortUtils;
/**
 * 
 * @author Nils
 *
 */
public class MainClass
{
 
private DJCrosstab djcross;
private Style totalHeader;
private Style colAndRowHeaderStyle;
private Style mainHeaderStyle;
private Style totalStyle;
private Style measureStyle;
 
// Base Class
protected JasperPrint jp;
protected JasperReport jr;
protected Map params = new HashMap();
protected DynamicReport dr;
 
public DynamicReport buildReport() throws Exception {
 
Style detailStyle = new Style();
 
Style headerStyle = new Style();
headerStyle.setFont(Font.ARIAL_MEDIUM_BOLD);
headerStyle.setBorderBottom(Border.PEN_1_POINT);
headerStyle.setBackgroundColor(Color.gray);
headerStyle.setTextColor(Color.white);
headerStyle.setHorizontalAlign(HorizontalAlign.CENTER);
headerStyle.setVerticalAlign(VerticalAlign.MIDDLE);
headerStyle.setTransparency(Transparency.OPAQUE);
 
Style headerVariables = new Style();
headerVariables.setFont(Font.ARIAL_MEDIUM_BOLD);
//headerVariables.setBorderBottom(Border.THIN);
headerVariables.setHorizontalAlign(HorizontalAlign.RIGHT);
headerVariables.setVerticalAlign(VerticalAlign.MIDDLE);
 
Style titleStyle = new Style();
titleStyle.setFont(new Font(18, Font._FONT_VERDANA, true));
Style importeStyle = new Style();
importeStyle.setHorizontalAlign(HorizontalAlign.RIGHT);
Style oddRowStyle = new Style();
oddRowStyle.setBorder(Border.NO_BORDER);
oddRowStyle.setBackgroundColor(Color.LIGHT_GRAY);
oddRowStyle.setTransparency(Transparency.OPAQUE);
 
DynamicReportBuilder drb = new DynamicReportBuilder();
Integer margin = new Integer(20);
drb.setTitleStyle(titleStyle)
.setTitle("November 2006 sales report")//defines the title of the report
.setSubtitle("The items in this report correspond "
+"to the main products: DVDs, Books, Foods and Magazines")
.setDetailHeight(new Integer(15)).setLeftMargin(margin)
.setRightMargin(margin).setTopMargin(margin).setBottomMargin(margin)
.setPrintBackgroundOnOddRows(false)
.setGrandTotalLegend("Grand Total")
.setGrandTotalLegendStyle(headerVariables)
.setDefaultStyles(titleStyle, null, headerStyle, detailStyle)
.setPrintColumnNames(true)
.setOddRowBackgroundStyle(oddRowStyle);

 
AbstractColumn columnState = ColumnBuilder.getInstance()
.setColumnProperty("state", String.class.getName())
.setTitle("State").setWidth(new Integer(85))
//.setStyle(titleStyle).setHeaderStyle(titleStyle)
.build();
 
AbstractColumn columnBranch = ColumnBuilder.getInstance()
.setColumnProperty("branch", String.class.getName())
.setTitle("Branch").setWidth(new Integer(85))
.setStyle(detailStyle).setHeaderStyle(headerStyle)
.build();
 
AbstractColumn columnaProductLine = ColumnBuilder.getInstance()
.setColumnProperty("productLine", String.class.getName())
.setTitle("Product Line").setWidth(new Integer(85))
.setStyle(detailStyle).setHeaderStyle(headerStyle)
.build();
 
AbstractColumn columnaItem = ColumnBuilder.getInstance()
.setColumnProperty("item", String.class.getName())
.setTitle("Item").setWidth(new Integer(85))
.setStyle(detailStyle).setHeaderStyle(headerStyle)
.build();
 
AbstractColumn columnCode = ColumnBuilder.getInstance()
.setColumnProperty("id", Long.class.getName())
.setTitle("ID").setWidth(new Integer(40))
.setStyle(importeStyle).setHeaderStyle(headerStyle)
.build();
 
AbstractColumn columnaQuantity = ColumnBuilder.getInstance()
.setColumnProperty("quantity", Long.class.getName())
.setTitle("Quantity").setWidth(new Integer(80))
.setStyle(importeStyle).setHeaderStyle(headerStyle)
.build();
 
AbstractColumn columnAmount = ColumnBuilder.getInstance()
.setColumnProperty("amount", Float.class.getName())
.setTitle("Amount").setWidth(new Integer(90)).setPattern("$ 0.00")
.setStyle(importeStyle).setHeaderStyle(headerStyle)
.build();
 
// drb.addGlobalHeaderVariable(columnAmount,
// ColumnsGroupVariableOperation.SUM,headerVariables);
//drb.addGlobalHeaderVariable(columnaQuantity, ColumnsGroupVariableOperation.SUM,headerVariables);
//drb.addGlobalFooterVariable(columnAmount, ColumnsGroupVariableOperation.SUM,headerVariables);
//drb.addGlobalFooterVariable(columnaQuantity, ColumnsGroupVariableOperation.SUM,headerVariables);
 
GroupBuilder gb1 = new GroupBuilder();
 
// define the criteria column to group by (columnState)
DJGroup g1 = gb1.setCriteriaColumn((PropertyColumn) columnState)
.addFooterVariable(columnAmount,DJCalculation.SUM,headerVariables) // tell the group place a variable footer of the column "columnAmount" with the SUM of allvalues of the columnAmount in this group.
.addFooterVariable(columnaQuantity,DJCalculation.SUM,headerVariables) // idem for the columnaQuantity column
.setGroupLayout(GroupLayout.DEFAULT) // tells the group how to be shown, there are manyposibilities, see the GroupLayout for more.
.build();
 
GroupBuilder gb2 = new GroupBuilder(); // Create another group (using another column as criteria)
DJGroup g2 = gb2.setCriteriaColumn((PropertyColumn) columnBranch) // and we add the same operations for the columnAmount and
.addFooterVariable(columnAmount,DJCalculation.SUM) // columnaQuantity columns
.addFooterVariable(columnaQuantity,DJCalculation.SUM)
.build();
 
drb.addColumn(columnState);
drb.addColumn(columnBranch);
drb.addColumn(columnaProductLine);
drb.addColumn(columnaItem);
drb.addColumn(columnCode);
drb.addColumn(columnaQuantity);
drb.addColumn(columnAmount);
 
drb.addGroup(g1); // add group g1
drb.addGroup(g2); // add group g2
 
drb.setUseFullPageWidth(true);
drb.addAutoText(AutoText.AUTOTEXT_PAGE_X_SLASH_Y, AutoText.POSITION_FOOTER, AutoText.ALIGMENT_RIGHT);
 
DynamicReport dr = drb.build();
return dr;
}
 
/***************************************************************************
 * 
 */
private void initStyles() {
totalHeader = new StyleBuilder(false).setHorizontalAlign(
HorizontalAlign.CENTER).setVerticalAlign(VerticalAlign.MIDDLE)
.setFont(Font.ARIAL_MEDIUM_BOLD).setTextColor(Color.BLUE)
.build();
colAndRowHeaderStyle = new StyleBuilder(false).setHorizontalAlign(
HorizontalAlign.LEFT).setVerticalAlign(VerticalAlign.TOP)
.setFont(Font.ARIAL_MEDIUM_BOLD).build();
mainHeaderStyle = new StyleBuilder(false).setHorizontalAlign(
HorizontalAlign.CENTER).setVerticalAlign(VerticalAlign.MIDDLE)
.setFont(Font.ARIAL_BIG_BOLD).setTextColor(Color.BLACK).build();
totalStyle = new StyleBuilder(false).setPattern("#,###.##")
.setHorizontalAlign(HorizontalAlign.RIGHT).setFont(
Font.ARIAL_MEDIUM_BOLD).build();
measureStyle = new StyleBuilder(false).setPattern("#,###.##")
.setHorizontalAlign(HorizontalAlign.RIGHT).setFont(
Font.ARIAL_MEDIUM).build();
}
 
/** *********************************** */
// Base Class
public void testReport() throws Exception {
dr = buildReport();
String query = "select * from usertable";
 
/**
 * Get a JRDataSource implementation
 */
JRDataSource ds = getDataSource();
//DynamicJasperReport dj = new DynamicJasperReport();
//JRDataSource ds = dj.getDataSource(query);
 
/**
 * Creates the JasperReport object, we pass as a Parameter the
 * DynamicReport, a new ClassicLayoutManager instance (this one does the
 * magic) and the JRDataSource
 */

jr = DynamicJasperHelper.generateJasperReport(dr, getLayoutManager(),params);

// JasperPrint jp = DynamicJasperHelper.generateJasperPrint(dr,new ListLayoutManager(), ds);

/**
 * Creates the JasperPrint object, we pass as a Parameter the
 * JasperReport object, and the JRDataSource
 */
if (ds != null)
jp = JasperFillManager.fillReport(jr, params, ds);
else
 jp = JasperFillManager.fillReport(jr, params);
 
exportReport();
 
// log.debug("test finished");
 
}
 
protected LayoutManager getLayoutManager() {
return new ClassicLayoutManager();
}
 
protected void exportReport() throws Exception {
System.out.println(System.getProperty("user.dir") + "/target/"
+ this.getClass().getName() + ".pdf");
ReportExporter.exportReport(jp, System.getProperty("user.dir")
+ "/target/" + this.getClass().getName() + ".pdf");
}
protected JRDataSource getDataSource() {
Collection dummyCollection = TestRepositoryProducts.getDummyCollection();
dummyCollection = SortUtils.sortCollection(dummyCollection,dr.getColumns());
 
JRDataSource ds = new JRBeanCollectionDataSource(dummyCollection);//Create a JRDataSource, the Collection used
//here contains dummy hardcoded objects...
return ds;
}
 
public static void main(String[] args) throws Exception {
MainClass test = new MainClass();
test.testReport();
JasperViewer.viewReport(test.jp); // finally display the report report
JasperDesignViewer.viewReportDesign(test.jr);
}
}
   

This class represent group test from DynamicJasper-3.0.2-test-project provided by Dj.
If you want to test other report then just replace buildReport() method corresponding to related deign object.

Feel free to ask any queries related to this code.

--
Nils- Not another java developer