View Javadoc

1   /*
2    * DynamicJasper: A library for creating reports dynamically by specifying
3    * columns, groups, styles, etc. at runtime. It also saves a lot of development
4    * time in many cases! (http://sourceforge.net/projects/dynamicjasper)
5    *
6    * Copyright (C) 2008  FDV Solutions (http://www.fdvsolutions.com)
7    *
8    * This library is free software; you can redistribute it and/or
9    * modify it under the terms of the GNU Lesser General Public
10   *
11   * License as published by the Free Software Foundation; either
12   *
13   * version 2.1 of the License, or (at your option) any later version.
14   *
15   * This library is distributed in the hope that it will be useful,
16   * but WITHOUT ANY WARRANTY; without even the implied warranty of
17   *
18   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
19   *
20   * Lesser General Public License for more details.
21   *
22   * You should have received a copy of the GNU Lesser General Public
23   * License along with this library; if not, write to the Free Software
24   *
25   * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
26   *
27   *
28   */
29  
30  package ar.com.fdvs.dj.test.crosstab;
31  
32  
33  import java.awt.Color;
34  import java.util.Date;
35  
36  import net.sf.jasperreports.view.JasperDesignViewer;
37  import net.sf.jasperreports.view.JasperViewer;
38  import ar.com.fdvs.dj.core.DJConstants;
39  import ar.com.fdvs.dj.domain.DJCalculation;
40  import ar.com.fdvs.dj.domain.DJCrosstab;
41  import ar.com.fdvs.dj.domain.DynamicReport;
42  import ar.com.fdvs.dj.domain.Style;
43  import ar.com.fdvs.dj.domain.builders.CrosstabBuilder;
44  import ar.com.fdvs.dj.domain.builders.FastReportBuilder;
45  import ar.com.fdvs.dj.domain.builders.StyleBuilder;
46  import ar.com.fdvs.dj.domain.constants.Border;
47  import ar.com.fdvs.dj.domain.constants.Font;
48  import ar.com.fdvs.dj.domain.constants.HorizontalAlign;
49  import ar.com.fdvs.dj.domain.constants.Transparency;
50  import ar.com.fdvs.dj.domain.constants.VerticalAlign;
51  import ar.com.fdvs.dj.test.BaseDjReportTest;
52  import ar.com.fdvs.dj.test.TestRepositoryProducts;
53  import ar.com.fdvs.dj.util.SortUtils;
54  
55  public class CrosstabReportTest5 extends BaseDjReportTest {
56  
57  	private Style totalHeaderStyle;
58  	private Style colAndRowHeaderStyle;
59  	private Style mainHeaderStyle;
60  	private Style totalStyle;
61  	private Style measureStyle;
62  	private Style measureStyle2;
63  	private Style titleStyle;
64  
65  	public DynamicReport buildReport() throws Exception {
66  		initStyles(); //init some styles to be used
67  
68  		/***
69  		 * Create an empty report (no columns)!
70  		 */
71  		FastReportBuilder drb = new FastReportBuilder();
72  			drb
73  			.setTitle("November 2006 sales report")
74  			.setSubtitle("This report was generated at " + new Date())
75  //			.setPageSizeAndOrientation(Page.Page_A4_Landscape())
76  			.setPrintColumnNames(false)
77  			.setUseFullPageWidth(true)
78  			.setDefaultStyles(titleStyle, null, null, null);
79  
80  		DJCrosstab djcross = new CrosstabBuilder()
81  			.setHeight(200)
82  			.setWidth(500)
83  			.setHeaderStyle(mainHeaderStyle)
84  			.setDatasource("sr",DJConstants.DATA_SOURCE_ORIGIN_PARAMETER, DJConstants.DATA_SOURCE_TYPE_COLLECTION)
85  			.setUseFullWidth(true)
86  			.setColorScheme(DJConstants.COLOR_SCHEMA_GRAY)
87  			.setAutomaticTitle(true)
88  			.setCellBorder(Border.PEN_1_POINT)
89  			.addRow("Product Line", "productLine", String.class.getName(),false)
90  			.addColumn("State","state",String.class.getName(),false)
91  			.addColumn("Branch","branch",String.class.getName(),true)
92  			.addColumn("Item", "item", String.class.getName(),true)
93  			.addMeasure("id",Long.class.getName(), DJCalculation.SUM , "Id", measureStyle)
94  			.addMeasure("amount",Float.class.getName(), DJCalculation.SUM , "Amount",measureStyle2)
95  			.setRowStyles(colAndRowHeaderStyle, totalStyle, totalHeaderStyle)
96  			.setColumnStyles(colAndRowHeaderStyle, totalStyle, totalHeaderStyle)
97  			.setCellDimension(34, 60)
98  			.setColumnHeaderHeight(30)
99  			.setRowHeaderWidth(80)
100 			.build();
101 
102 		drb.addHeaderCrosstab(djcross); //add the crosstab in the header band of the report
103 
104 		DynamicReport dr = drb.build();
105 
106 		//put a collection in the parameters map to be used by the crosstab
107 		params.put("sr", SortUtils.sortCollection(TestRepositoryProducts.getDummyCollection(),djcross));
108 
109 		return dr;
110 	}
111 
112 
113 	/***
114 	 *
115 	 */
116 	private void initStyles() {
117 		titleStyle =  new StyleBuilder(false)
118 			.setFont(Font.ARIAL_BIG_BOLD)
119 			.setHorizontalAlign(HorizontalAlign.LEFT)
120 			.setVerticalAlign(VerticalAlign.MIDDLE)
121 			.setTransparency(Transparency.OPAQUE)
122 			.setBorderBottom(Border.PEN_2_POINT)
123 			.build();
124 
125 		totalHeaderStyle = new StyleBuilder(false)
126 			.setHorizontalAlign(HorizontalAlign.CENTER)
127 			.setVerticalAlign(VerticalAlign.MIDDLE)
128 			.setFont(Font.ARIAL_MEDIUM_BOLD)
129 			.setTextColor(Color.BLUE)
130 			.build();
131 		colAndRowHeaderStyle = new StyleBuilder(false)
132 			.setHorizontalAlign(HorizontalAlign.LEFT)
133 			.setVerticalAlign(VerticalAlign.TOP)
134 			.setFont(Font.ARIAL_MEDIUM_BOLD)
135 			.build();
136 		mainHeaderStyle = new StyleBuilder(false)
137 			.setHorizontalAlign(HorizontalAlign.CENTER)
138 			.setVerticalAlign(VerticalAlign.MIDDLE)
139 			.setFont(Font.ARIAL_BIG_BOLD)
140 			.setTextColor(Color.BLACK)
141 			.build();
142 		totalStyle = new StyleBuilder(false).setPattern("#,###.##")
143 			.setHorizontalAlign(HorizontalAlign.RIGHT)
144 			.setFont(Font.ARIAL_MEDIUM_BOLD)
145 			.build();
146 		measureStyle = new StyleBuilder(false).setPattern("#,###.##")
147 			.setHorizontalAlign(HorizontalAlign.RIGHT)
148 			.setFont(Font.ARIAL_MEDIUM)
149 			.build();
150 
151 		measureStyle2 = new StyleBuilder(false).setPattern("#,###.##")
152 		.setHorizontalAlign(HorizontalAlign.RIGHT)
153 		.setFont(new Font(Font.MEDIUM,Font._FONT_ARIAL,false,true,false))
154 		.setTextColor(Color.RED)
155 		.build();
156 	}
157 
158 
159 	public static void main(String[] args) throws Exception {
160 		CrosstabReportTest5 test = new CrosstabReportTest5();
161 		test.testReport();
162 		JasperViewer.viewReport(test.jp);	//finally display the report report
163 		JasperDesignViewer.viewReportDesign(test.jr);
164 	}
165 
166 }