glassner
Members-
Posts
67 -
Joined
-
Last visited
glassner's Achievements
-
Yes, the test server is a linux machine
-
Using JasperReport 3.7.3, with java 1.5 locally, and everything works fine When deploying to my test server then I get the error in question (using the same exact .ear) Anyone has figured out what this error could be ?
-
Woudl it work with java 1.4 ?
-
I was trying the "table" wizard. ANyone knows whether documentation exists on how to use it ? I cannot print anything with it, yet I think I have set up correctly its dataset ...
-
My $V{PAGE_NUMBER} prints only on the very first page of my report, but not on the subsequent pages. Yet, the "Print repeated values" is checked. What else ?
-
Got it. This works for me. Hope somebody finds this useful JRPptxExporter pptExporter = new JRPptxExporter(); pptExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); pptExporter.setParameter(JRExporterParameter.OUTPUT_STREAM, pptReport ); pptExporter.exportReport(); byte[] reportBytes = pptReport.toByteArray(); //Prepare response response.setContentType("application/vnd.ms-powerpoint"); response.setHeader("Content-disposition", "attachment; filename=Report.ppt" ); response.setHeader("Expires", "0"); response.setHeader("Cache-Control", "must-revalidate, post-check=0, pre-check=0"); response.setHeader("Pragma", "public"); response.setContentLength(reportBytes.length); //Send Content to Browser response.getOutputStream().write(reportBytes); response.getOutputStream().flush();
-
This is my code to generate a PdF file, where reportStream is an object of type InputStream representing the .jasper file. I could not find a way to use JasperPrint with JRPptxExporter ... JasperPrint jasperPrint = JasperFillManager.fillReport(reportStream, parameterMap, resultSet); byte[] reportBytes = JasperExportManager.exportReportToPdf(jasperPrint); //Prepare response response.setContentType("application/pdf"); response.setHeader("Content-disposition", "attachment; filename=Report.pdf" ); response.setHeader("Expires", "0"); response.setHeader("Cache-Control", "must-revalidate, post-check=0, pre-check=0"); response.setHeader("Pragma", "public"); response.setContentLength(reportBytes.length); //Send Content to Browser response.getOutputStream().write(reportBytes); response.getOutputStream().flush();
-
I am trying to use the JRPptxExporter from version 3.7.3 Could anyone provide any examples on how to use it and what parameter, if any, should be set ? Thank you !
-
Solved the issu of the column header not showing on Excel following Teoror suggestion http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=76165 Any plans on allowing JasperReport to facilitate the creation of Excel formulas ?
-
That was it. Thank you !
-
ANyone could help me figure out why the columnGroup does not show in Excel format ? <columnGroup name="academicDegreeType" height="35" totalPosition="End"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{academicDegreeType}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="50" height="20" backcolor="#CCCCCC"/> <textElement verticalAlignment="Middle"> <font size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{academicDegreeType} == "DOCTORATE" ? "PhD" : $V{academicDegreeType} == "NT MASTER" ? "NT MS" : $V{academicDegreeType} == "MASTER" ? "MS" : $V{academicDegreeType} == "OTHER" ? "Other": $V{academicDegreeType} == "NO DEGREE" ? "Non Degree" : $V{academicDegreeType}]]></textFieldExpression> </textField> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="20" width="25" height="14" backcolor="#CCCCCC"/> <textElement verticalAlignment="Top"> <font size="7" isBold="true"/> </textElement> <text><![CDATA[A]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="20" width="25" height="14" backcolor="#CCCCCC"/> <textElement verticalAlignment="Top"> <font size="7" isBold="true"/> </textElement> <text><![CDATA[P]]></text> </staticText> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="106" height="20" backcolor="#CCCCCC"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="8" isBold="true"/> </textElement> <text><![CDATA[Total Approved]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="78" y="20" width="28" height="14" backcolor="#CCCCCC"/> <textElement verticalAlignment="Top"> <font size="7" isBold="true"/> </textElement> <text><![CDATA[ManYears P]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="20" width="25" height="14" forecolor="#000000" backcolor="#CCCCCC"/> <textElement verticalAlignment="Top"> <font size="7" isBold="true"/> </textElement> <text><![CDATA[P]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="20" width="25" height="14" backcolor="#CCCCCC"/> <textElement verticalAlignment="Top"> <font size="7" isBold="true"/> </textElement> <text><![CDATA[A]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="50" y="20" width="28" height="14" backcolor="#CCCCCC"/> <textElement verticalAlignment="Top"> <font size="7" isBold="true"/> </textElement> <text><![CDATA[ManYears A]]></text> </staticText> </cellContents> </crosstabTotalColumnHeader> </columnGroup>
-
I am also finding other issues when converting to Excel format: The entire header of my crosstab does not appear on my report if I export it in Excel, but it does appear in any other format (say, PDF). I converted the Excel report into XML and then opened it with a text editor: the header of the report is just not there ! As I said, the header appears in any other type of export http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=76165&topid=76234
-
Yes, I was using data cells. It is not clear whether there is an easy way to create Excel formulas with Jasper especially if we are using crosstabs. If there is a way, please let me know.The documentation on this issue is non-existent.
-
I tried also with version 3.7.3, and it does not work. ANy help please ?
-
The entire header of my crosstab does not appear on my report if I export it in Excel, but it does appear in any other format (say, PDF). I converted the Excel report into XML and then opened it with a text editor: the header of the report is just not there ! As I said, the header appears in any other type of export. The crosstab xml is below. Anyone would be kind enough to help in this ? <crosstab> <reportElement style="Crosstab Data Text" positionType="Float" x="14" y="33" width="548" height="67"/> <rowGroup name="courseCategoryCode" width="77"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{courseCategoryCode}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="-3" width="77" height="29" backcolor="#CCCCFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{courseCategoryCode} + " Totals"]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents backcolor="#FFFFFF"/> </crosstabTotalRowHeader> </rowGroup> <columnGroup name="academicDegreeType" height="35" totalPosition="End"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{academicDegreeType}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="50" height="20" backcolor="#CCCCCC"/> <textElement verticalAlignment="Middle"> <font size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{academicDegreeType} == "DOCTORATE" ? "PhD" : $V{academicDegreeType} == "NT MASTER" ? "NT MS" : $V{academicDegreeType} == "MASTER" ? "MS" : $V{academicDegreeType} == "OTHER" ? "Other": $V{academicDegreeType} == "NO DEGREE" ? "Non Degree" : $V{academicDegreeType}]]></textFieldExpression> </textField> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="20" width="25" height="14" backcolor="#CCCCCC"/> <textElement verticalAlignment="Top"> <font size="7" isBold="true"/> </textElement> <text><![CDATA[A]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="20" width="25" height="14" backcolor="#CCCCCC"/> <textElement verticalAlignment="Top"> <font size="7" isBold="true"/> </textElement> <text><![CDATA[P]]></text> </staticText> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="106" height="20" backcolor="#CCCCCC"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="8" isBold="true"/> </textElement> <text><![CDATA[Total Approved]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="78" y="20" width="28" height="14" backcolor="#CCCCCC"/> <textElement verticalAlignment="Top"> <font size="7" isBold="true"/> </textElement> <text><![CDATA[ManYears P]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="20" width="25" height="14" forecolor="#000000" backcolor="#CCCCCC"/> <textElement verticalAlignment="Top"> <font size="7" isBold="true"/> </textElement> <text><![CDATA[P]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="20" width="25" height="14" backcolor="#CCCCCC"/> <textElement verticalAlignment="Top"> <font size="7" isBold="true"/> </textElement> <text><![CDATA[A]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="50" y="20" width="28" height="14" backcolor="#CCCCCC"/> <textElement verticalAlignment="Top"> <font size="7" isBold="true"/> </textElement> <text><![CDATA[ManYears A]]></text> </staticText> </cellContents> </crosstabTotalColumnHeader> </columnGroup> <measure name="ACTUAL_DEGREE_QTYMeasure" class="java.math.BigDecimal" calculation="Sum"> <measureExpression><![CDATA[$F{actualDegreeQty}]]></measureExpression> </measure> <measure name="PROJECTED_DEGREE_QTYMeasure" class="java.math.BigDecimal" calculation="Sum"> <measureExpression><![CDATA[$F{projectedDegreeQty}]]></measureExpression> </measure> <measure name="PROJECTED_MANYEARS_QTYMeasure" class="java.math.BigDecimal" calculation="Sum"> <measureExpression><![CDATA[$F{projectedApprovedManyears}]]></measureExpression> </measure> <measure name="ACTUAL_MANYEARS_QTYMeasure" class="java.math.BigDecimal" calculation="Sum"> <measureExpression><![CDATA[$F{actualApprovedManyears}]]></measureExpression> </measure> <crosstabCell width="50" height="26"> <cellContents backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="-3" width="25" height="29" backcolor="#CCCCFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure} == null ? "0" : $V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="-3" width="25" height="29" backcolor="#CCCCFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_DEGREE_QTYMeasure} == null ? "0" : $V{PROJECTED_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell height="25" rowTotalGroup="courseCategoryCode"> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25"/> <textElement/> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="106" height="26" columnTotalGroup="academicDegreeType"> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="-3" width="25" height="29" backcolor="#CCCCFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="-3" width="25" height="29" forecolor="#000000" backcolor="#CCCCFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="50" y="-3" width="28" height="29" backcolor="#CCCCFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_MANYEARS_QTYMeasure} == null ? "0" : $V{ACTUAL_MANYEARS_QTYMeasure}]]></textFieldExpression> </textField> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="78" y="-3" width="28" height="29" backcolor="#CCCCFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_MANYEARS_QTYMeasure} == null ? "0" : $V{PROJECTED_MANYEARS_QTYMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell rowTotalGroup="courseCategoryCode" columnTotalGroup="academicDegreeType"> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25"/> <textElement/> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> </crosstab> </band> </groupFooter> </group> <group name="CATEGORY SUBTYPE CODE"> <groupExpression><![CDATA[$F{courseCategorySubtypeCode}]]></groupExpression> <groupHeader> <band height="15"/> </groupHeader> <groupFooter> <band height="153"> <crosstab> <reportElement x="14" y="20" width="557" height="96"/> <crosstabDataset> <dataset resetType="Group" resetGroup="CATEGORY SUBTYPE CODE"/> </crosstabDataset> <rowGroup name="courseProgramCode" width="58" totalPosition="End"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{courseProgramCode}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="58" height="25"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{courseProgramCode} == null ? "-" : $V{courseProgramCode}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="121" height="27" backcolor="#CCCCFF"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[Total]]></text> </staticText> </cellContents> </crosstabTotalRowHeader> </rowGroup> <rowGroup name="faculty_code" width="63"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{facultyPrepCode}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents backcolor="#FFFFFF" mode="Transparent"> <textField> <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="63" height="25"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{faculty_code} == null ? "-" : $V{faculty_code}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents backcolor="#FFFFFF"/> </crosstabTotalRowHeader> </rowGroup> <columnGroup name="academicDegreeType" height="41" totalPosition="End"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{academicDegreeType}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="50" height="20" backcolor="#CCCCCC"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{academicDegreeType} == "DOCTORATE" ? "PhD" : $V{academicDegreeType} == "NT MASTER" ? "NT MS" : $V{academicDegreeType} == "MASTER" ? "MS" : $V{academicDegreeType} == "OTHER" ? "Other": $V{academicDegreeType} == "NO DEGREE" ? "Non Degree" : $V{academicDegreeType}]]></textFieldExpression> </textField> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="21" width="25" height="19" backcolor="#CCCCCC"/> <textElement> <font size="7" isBold="true"/> </textElement> <text><![CDATA[A]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="21" width="25" height="19" backcolor="#CCCCCC"/> <textElement> <font size="7" isBold="true"/> </textElement> <text><![CDATA[P]]></text> </staticText> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="120" height="20" backcolor="#CCCCCC"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="8" isBold="true"/> </textElement> <text><![CDATA[Total Approved]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="30" y="21" width="30" height="19" forecolor="#000000" backcolor="#CCCCCC"/> <textElement> <font size="7" isBold="true"/> </textElement> <text><![CDATA[P]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="21" width="30" height="19" backcolor="#CCCCCC"/> <textElement> <font size="7" isBold="true"/> </textElement> <text><![CDATA[A]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="60" y="21" width="30" height="19" backcolor="#CCCCCC"/> <textElement> <font size="7" isBold="true"/> </textElement> <text><![CDATA[ManYears A]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" mode="Opaque" x="90" y="21" width="30" height="19" backcolor="#CCCCCC"/> <textElement> <font size="7" isBold="true"/> </textElement> <text><![CDATA[ManYears P]]></text> </staticText> </cellContents> </crosstabTotalColumnHeader> </columnGroup> <measure name="ACTUAL_DEGREE_QTYMeasure" class="java.math.BigDecimal" calculation="Sum"> <measureExpression><![CDATA[$F{actualDegreeQty}]]></measureExpression> </measure> <measure name="PROJECTED_DEGREE_QTYMeasure" class="java.math.BigDecimal" calculation="Sum"> <measureExpression><![CDATA[$F{projectedDegreeQty}]]></measureExpression> </measure> <measure name="PROJECTED_MANYEARS_QTYMeasure" class="java.math.BigDecimal" calculation="Sum"> <measureExpression><![CDATA[$F{projectedApprovedManyears}]]></measureExpression> </measure> <measure name="ACTUAL_MANYEARS_QTYMeasure" class="java.math.BigDecimal" calculation="Sum"> <measureExpression><![CDATA[$F{actualApprovedManyears}]]></measureExpression> </measure> <crosstabCell width="50" height="25"> <cellContents> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="25" height="25" backcolor="#CCCCCC"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure} == null ? "0" : $V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="0" width="25" height="25" backcolor="#FFFFFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_DEGREE_QTYMeasure} == null ? "0" : $V{PROJECTED_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="134" columnTotalGroup="academicDegreeType"> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="30" height="25" backcolor="#CCCCCC"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="30" y="0" width="30" height="25" forecolor="#000000" backcolor="#FFFFFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="60" y="0" width="30" height="25" backcolor="#CCCCCC"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_MANYEARS_QTYMeasure} == null ? "0" : $V{ACTUAL_MANYEARS_QTYMeasure}]]></textFieldExpression> </textField> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="90" y="0" width="30" height="25" backcolor="#FFFFFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_MANYEARS_QTYMeasure} == null ? "0" : $V{PROJECTED_MANYEARS_QTYMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="50" height="27" rowTotalGroup="courseProgramCode"> <cellContents backcolor="#FFF3E6" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="25" height="25" backcolor="#CCCCFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure} == null ? "0" : $V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="0" width="25" height="25" backcolor="#CCCCFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_DEGREE_QTYMeasure} == null ? "0" : $V{PROJECTED_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="134" height="27" rowTotalGroup="courseProgramCode" columnTotalGroup="academicDegreeType"> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/> </box> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="30" height="25" backcolor="#CCCCFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="30" y="0" width="30" height="25" backcolor="#CCCCFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_DEGREE_QTYMeasure}]]></textFieldExpression> </textField> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="60" y="0" width="30" height="25" backcolor="#CCCCFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_MANYEARS_QTYMeasure}]]></textFieldExpression> </textField> <textField> <reportElement style="Crosstab Data Text" mode="Opaque" x="90" y="0" width="30" height="25" backcolor="#CCCCFF"/> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_MANYEARS_QTYMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell rowTotalGroup="faculty_code"> <cellContents/> </crosstabCell> <crosstabCell rowTotalGroup="faculty_code" columnTotalGroup="academicDegreeType"> <cellContents/> </crosstabCell> </crosstab>