2006 JR Open Discussion

By: stan letarte - sletarte Help: Headers over Rows on crosstabs? 2005-12-29 16:06 Is there a way to place a "column header" over the data that are found in a rowGroup? I have a report in which there are two nested rowGroups and two nested column groups, but wish to add headers over the "columns" that are, in effect, the data from each rowgroup (i.e. put a "Sales Rep" title over the names of sales reps in the provided ProductsReport.jrxml in the crosstab samples app). Thanks, /Stan By: Lucian Chirita - lucianc RE: Help: Headers over Rows on crosstabs? 2006-01-04 02:09 Crosstabs in the CVS version have a header cell that gets rendered in the upper-left corner of the crosstab. You could get the CVS version and see whether this suits your needs. Regards, Lucian By: stan letarte - sletarte RE: Help: Headers over Rows on crosstabs? 2006-01-04 07:24 Thanks, I will check out the CVS version and let you know. /Stan

By: Makarand - mkharche Subreport not showing up 2006-01-04 02:18 Hi, I have a subreport element inside the details section of the master report. This subreport has nothing but the details section, with some text fields in it. The design is pretty much like the following : <detail> | Item related textfields | | Static: Above item consists of the following: | | Subreport element | </detail> In such a design, I could see that the data is getting fetched propoerly on the report, however the subreport doesnt show up. However, if I keep some blank space between the subreport element and the static text, in the design, and then try generating the report, then the report gets generated fine, with alignment issues ofcourse. Any one can help me find out the problem ? Thanks. Following is an excerpt of the details section in my design : <detail> <band height="43" isSplitAllowed="true" > <printWhenExpression><![CDATA[$P{SHOW_QUOTE}]]></printWhenExpression> <elementGroup> <textField isStretchWithOverflow="true" pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="463" y="0" width="69" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField-151" stretchType="RelativeToTallestObject" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[$P{SHOW_QUOTE}]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000" bottomPadding="2"/> <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{item.price.extendedSellingPrice}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="465" y="4" width="14" height="7" forecolor="#000000" backcolor="#FFFFFF" key="textField-152" stretchType="RelativeToTallestObject" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[new Boolean(false)]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000" bottomPadding="2"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{totalLineItemsInItem}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="lineItemGroup" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="2" y="0" width="51" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField-153" stretchType="RelativeToTallestObject" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[$P{SHOW_QUOTE}]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000" bottomPadding="2"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{ITEM_SER_NO}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="53" y="0" width="93" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField-154" stretchType="RelativeToTallestObject" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[$P{SHOW_QUOTE}]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000" bottomPadding="2"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{item.name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="146" y="0" width="128" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField-155" stretchType="RelativeToTallestObject" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[$P{SHOW_QUOTE}]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000" bottomPadding="2"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{item.description}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="335" y="0" width="64" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField-156" stretchType="RelativeToTallestObject" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[$P{SHOW_QUOTE}]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000" bottomPadding="2"/> <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{item.price.extendedListPrice}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="274" y="0" width="61" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField-157" stretchType="RelativeToTallestObject" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[$P{SHOW_QUOTE}]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000" bottomPadding="2"/> <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{item.quantity}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="399" y="0" width="64" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField-158" stretchType="RelativeToTallestObject" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[$P{SHOW_QUOTE}]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="Thin" rightBorderColor="#000000" rightPadding="2" bottomBorder="Thin" bottomBorderColor="#000000" bottomPadding="2"/> <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new java.text.DecimalFormat("##############0.00").format($F{item.price.discountPercent}.doubleValue())+"%"]]></textFieldExpression> </textField> </elementGroup> <subreport isUsingCache="true"> <reportElement mode="Opaque" x="2" y="29" width="531" height="13" forecolor="#000000" backcolor="#FFFFFF" key="subreport-1" stretchType="NoStretch" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[new Boolean(($P{SHOW_QUOTE}.booleanValue() == true) && ($P{SHOW_QUOTE_DETAIL}.booleanValue() == true) && $F{totalLineItemsInItem}.intValue() > 0)]]></printWhenExpression> </reportElement> <subreportParameter name="ITEM_ID"> <subreportParameterExpression><![CDATA[$F{item.id}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="ITEM_SER_NO"> <subreportParameterExpression><![CDATA[$V{ITEM_SER_NO}]]></subreportParameterExpression> </subreportParameter> <dataSourceExpression><![CDATA[$P{ITEMSREPORT_DATASOURCE}]]></dataSourceExpression> <subreportExpression class="net.sf.jasperreports.engine.JasperReport"><![CDATA[$P{ITEMSREPORT_LOCATION}]]></subreportExpression> </subreport> <staticText> <reportElement mode="Transparent" x="1" y="16" width="530" height="13" forecolor="#000000" backcolor="#FFFFFF" key="staticText-138" stretchType="NoStretch" positionType="Float" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[new Boolean(($P{SHOW_QUOTE}.booleanValue() == true) && ($P{SHOW_QUOTE_DETAIL}.booleanValue() == true) && $F{totalLineItemsInItem}.intValue() > 0)]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[Above configuration consists of the following items:]]></text> </staticText> </band> </detail> - Thanks Makarand. By: Yongzi - yongzi How to create a subreport with only Static te 2006-01-04 03:49 If the subreport is nothing else than static images and text, you should NOT place any element into the "Detail" section (actually, it is a good idea to delete the detail section), and then change the "Report Property" --> "When No Data Print" to "All Sections No Detail"; this could, however, ensure the faultless display of the subreport in the master report. And then switch the layout to the master report design, add a "Subreport" element onto the layout, set the "Subreport" --> "Expression" with proper value (in this case, you don't have to (or must not) touch the "Connection Expression" and "Data Source Expression" areas, otherwise, the data in the master report may not be displayed properly). Preview should now display the expected page. PS: It is suggested to set the margins in the subreport to 0!

By: Thomas Ludwig Kast - tomkast sql and subdataset charts 2005-12-31 17:10 hiho, two ideas - 1: for the demo subdataset chart report change the sql from "OrderDate != null" to "OrderDate is not null" (try mysql 4.1) 2: need a better error when a seriesName is null. running the demo subdataset chart report, here was the error that i was working with (below). maybe a sql error could be thrown? thanks tom java.lang.NullPointerException at net.sf.jasperreports.charts.fill.JRFillTimeSeriesDataset.customIncrement(JRFillTimeSeriesDataset.java:133) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:134) at net.sf.jasperreports.engine.fill.JRFillChartDataset.getDataset(JRFillChartDataset.java:57) at net.sf.jasperreports.engine.fill.JRFillChart.evaluateTimeSeriesImage(JRFillChart.java:1327) at net.sf.jasperreports.engine.fill.JRFillChart.evaluateImage(JRFillChart.java:586) at net.sf.jasperreports.engine.fill.JRFillChart.evaluate(JRFillChart.java:534) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:211) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1307) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:639) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:230) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:826) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:697) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.ussrp.web.CachingReportViewController.handle(CachingReportViewController.java:186) at org.springframework.web.servlet.mvc.AbstractCommandController.handleRequestInternal(AbstractCommandController .java:79) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java :44) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625) at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:386) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:346) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) By: Lucian Chirita - lucianc RE: sql and subdataset charts 2006-01-03 08:29 Hi The sub dataset sample was already modified on CVS to use "IS NOT NULL". Regards, Lucian

By: shekar - rudra_tata Problem displaying PDF created using merge 2006-01-02 20:16 Hi All, Iam using merge method to merge different reports generated seperately. And in the final report iam able to get html, but for pdf iam not able to see full details in the report. The report size is so small that iam only able to see one line and iam not able to enlarge it. I tried to increase the pageHeight during merging but that was of no help. can any one please let me know how to solve this issue

By: shekar - rudra_tata Can DSN be eliminated 2006-01-02 20:16 In the JRXML file generated there is a property for DataSource Name and is accepts DSN. Can this be eliminated and can we use JDBC Connection string.

By: Giulio Toffoli - gt78 [ANN] iReport 0.5.3 released 2006-01-02 16:08 The iReport Team is pleased to announce the new iReport release: 0.5.3. The following changes have been made to software since release 0.5.2 Added support for JasperReports 1.1.1 (crosstabs are not yet supported) Added support for frames Added support for styles Added support for subDataset Added support for elementGroup Serveral bug fixes and improvements Thanks for your suggestions and your on going support using iReport! Giulio iReport site: http://ireport.sf.net download: https://sourceforge.net/project/showfiles.php?group_id=64348