bbalmer Posted September 8, 2006 Share Posted September 8, 2006 I've checked the forum and this seems pretty easy but for some reason I keep getting a null returned from the sum of my subreport. I have a 'totalDue' java.lang.Double variable in my subreport doing a sum. If I print this out in the subreport it shows the total being calculated correctly as the rows are printed. I have this mapped to a totalDueGroceryTotal variable in the master report (java.lang.Double). This ALWAYS comes back as null. Any ideas? Here is the master report:Code:<jasperReport name="OrderDetail" pageWidth="594" pageHeight="791" whenNoDataType="AllSectionsNoDetail" columnWidth="590" leftMargin="2" rightMargin="2" topMargin="5" bottomMargin="5"> <property name="com.jasperassistant.designer.DataSource" value="OrderDetailsDataSource"/> <parameter name="GroceryTotals_Subreport" class="net.sf.jasperreports.engine.JasperReport"/> <variable name="totalDueGroceryTotal" class="java.lang.Double" calculation="System"/> <detail> <band height="279"> <frame> <reportElement x="2" y="60" width="583" height="97"/> <box border="1Point" padding="0"/> <frame> </frame> <frame> </frame> <frame> <reportElement stretchType="RelativeToBandHeight" x="370" y="0" width="211" height="95"/> <box border="None" padding="0"/> <subreport> <reportElement x="2" y="2" width="207" height="63"/> <dataSourceExpression> <![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{citOrdDtls})]]> </dataSourceExpression> <returnValue subreportVariable="totalDue" toVariable="totalDueGroceryTotal"/> <subreportExpression class="net.sf.jasperreports.engine.JasperReport"><![CDATA[$P{GroceryTotals_Subreport}]]> </subreportExpression> </subreport> <rectangle> <reportElement positionType="FixRelativeToBottom" x="0" y="78" width="211" height="17" backcolor="#DFDFDF"/> <graphicElement/> </rectangle> <staticText> <reportElement positionType="FixRelativeToBottom" x="2" y="80" width="80" height="13"/> <textElement verticalAlignment="Middle"> <font fontName="Courier New" size="11" isBold="true" pdfFontName="Courier-Bold" isPdfEmbedded="true"/> </textElement> <text><![CDATA[Total Due:]]></text> </staticText> <textField pattern="¤#,##0.00;(¤#,##0.00)" isBlankWhenNull="true"> <reportElement positionType="FixRelativeToBottom" x="92" y="80" width="118" height="13"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Courier New" size="11" isBold="true" pdfFontName="Courier-Bold" isPdfEmbedded="true"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{totalDueGroceryTotal}]]></textFieldExpression> </textField> </frame> </frame> </band> </detail></jasperReport> Link to comment Share on other sites More sharing options...
lucianc Posted September 8, 2006 Share Posted September 8, 2006 The subreport doesn't return null, but you need to use evaluationTime="Band" for the text field in which you display the returned value. Check the "subreport" sample incuded in the JR distribution. HTH,Lucian Link to comment Share on other sites More sharing options...
bbalmer Posted September 8, 2006 Author Share Posted September 8, 2006 Beautiful! Thank you very much. Link to comment Share on other sites More sharing options...
bbalmer Posted September 8, 2006 Author Share Posted September 8, 2006 Beautiful! Thank you very much. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now