jhertz

Hi, I revisited the issue, and without me changing anything it wraps to another row now. To be honest I really don’t know what I have changed. I updated my version of ireport and maybe it did set some attribute that I had previously over looked. Sorry for wasting your time, and once again thanks for the help. Regards jhertz

Hi, Sorry for the late reply, the sub report is in the detail band. Do you want a sample as in a rendered report or as in the XML? I have added the detail bands XML in the code section.Thanks Code: <detail> <band height="28" splitType="Stretch"> <staticText> <reportElement style="Headin01" x="0" y="0" width="100" height="15"/> <textElement/> <text><![CDATA[breaks:]]></text> </staticText> <line> <reportElement x="0" y="15" width="515" height="1"/> </line> <staticText> <reportElement style="Headin04" x="0" y="16" width="100" height="12"> <printWhenExpression><![CDATA[new Boolean($P{printBreaks}.booleanValue() == false)]]></printWhenExpression> </reportElement> <textElement/> <text><![CDATA[no current breaks]]></text> </staticText> </band> <band height="60" splitType="Stretch"> <subreport> <reportElement positionType="Float" x="0" y="0" width="515" height="60" isRemoveLineWhenBlank="true"> <printWhenExpression><![CDATA[$P{printBreaks}]]></printWhenExpression> </reportElement> <parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression> <dataSourceExpression><![CDATA[$P{breaks}]]></dataSourceExpression> <subreportExpression class="java.lang.String"><![CDATA[$P{reportFolder} + "/PositionLimits_BW.jasper"]]></subreportExpression> </subreport> </band> <band height="70" splitType="Stretch"> <staticText> <reportElement style="Headin01" x="0" y="42" width="100" height="15"/> <textElement/> <text><![CDATA[Warnings:]]></text> </staticText> <line> <reportElement x="0" y="57" width="515" height="1"/> </line> <staticText> <reportElement style="Headin04" x="0" y="58" width="100" height="12"> <printWhenExpression><![CDATA[new Boolean($P{printWarnings}.booleanValue() == false)]]></printWhenExpression> </reportElement> <textElement/> <text><![CDATA[no current warnings]]></text> </staticText> </band> <band height="60" splitType="Stretch"> <subreport> <reportElement positionType="Float" x="0" y="0" width="515" height="60" isRemoveLineWhenBlank="true"> <printWhenExpression><![CDATA[$P{printWarnings}]]></printWhenExpression> </reportElement> <parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression> <dataSourceExpression><![CDATA[$P{warnings}]]></dataSourceExpression> <subreportExpression class="java.lang.String"><![CDATA[$P{reportFolder} + "/PositionLimits_BW.jasper"]]></subreportExpression> </subreport> </band> <band height="140" splitType="Stretch"> <subreport> <reportElement positionType="Float" x="0" y="0" width="515" height="140"/> <parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression> <dataSourceExpression><![CDATA[$P{all}]]></dataSourceExpression> <subreportExpression class="java.lang.String"><![CDATA[$P{reportFolder} + "/PositionLimits_All.jasper"]]></subreportExpression> </subreport> </band> </detail>

Hi, I have a report that two sub-reports in it. It gets rendered to a PDF, the problem is that the text fields that are tagged as isStretchWithOverflow does not stretch. I have tried to run just the sub-report and then it works fine. So how do I get it to behave the same when part of the master report? Regards jhertz

Hi Teodor, Thank you for the quick reply. I agree that I probably need to learn more. However when it comes to this issue the parameter that you suggest is the one that I used in the first place. The problem with it, is that it does not set the background of the whole excel file to white, just the part witch the report uses. So the question is really is there away to set all the excel file to have no grid lines? If you feel that this question does not belong in this forum, feel free to ignore it or remove it. Regards Johan

Hi, Thanks for the reply, I don't know if you can answer this but would I set this parameter in the JRXlsExporter setParameter function? Also, the package JRXlsExporter net.sf.jasperreports.export does not seem to be part of the standard jasper jars or? Regards Johan Post Edited by jhertz at 08/27/2009 10:38

Hi, I know I can remove the excel grid lines in the cells that have content, but is there a way to set all of the excel document to have a white background? Regards Johan