dschafer

The stack trace for the error is (had to paste an image because the actual text was triggering cloudfront)

This issue seemed to arrive out of the blue.We have a japserserver install that is accessed via non-admin users. About a week ago we started getting security errors when these users run reports. I've tried giving users admin permissions to the reports but the same error occurs. (I removed a stack trace because it was being blocked by cloudfront) Has anyone dealt with this before? We're running on EC2. Thanks

HI This is not related but how were you able to start this topic. I continually get the following: 403 ERROR The request could not be satisfied. Request blocked. We can't connect to the server for this app or website at this time. There might be too much traffic or a configuration error. Try again later, or contact the app or website owner. If you provide content to customers through CloudFront, you can find steps to troubleshoot and help prevent this error by reviewing the CloudFront documentation. Generated by cloudfront (CloudFront) Request ID: WqUtYItXPWIIesUQ7WhpnYJqNe9MLhffSSaCk7NxYErhcJsZAUbo1A== Thanks

I have several reports that use the following module The main reports selects a group of records. There is a dataset of detail data linked to the primary list through a unique id. Each time the report a different set of of rows display blank data in the datalist. For example first run of the report rows 100 - 105 may have nothing printed in the list element, Run the report again immediately and rows 30 - 33 may be missing the data in the list element but row 100-105 display correctly. The underlying data is not changing at all. If doesn't matter how we view the data (html, pdf) or if the report is generated through jaspersever or within iReport The report was built in iReport 3.7.6. I've include the list xml below. Any suggestions. Thanks Code: <componentElement> <reportElement positionType="Float" x="151" y="0" width="421" height="12" isRemoveLineWhenBlank="true"/> <jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical" ignoreWidth="false"> <datasetRun subDataset="Appointment"> <datasetParameter name="contact_id"> <datasetParameterExpression><![CDATA[$F{civicrm_contact_id}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:listContents height="12" width="421"> <textField isStretchWithOverflow="true"> <reportElement positionType="Float" x="0" y="0" width="141" height="12"/> <textElement> <font fontName="Lucida Sans" size="9"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{organization_name}]]></textFieldExpression> </textField> <textField pattern="¤ #,##0" isBlankWhenNull="true"> <reportElement x="357" y="0" width="54" height="12"/> <textElement textAlignment="Right"> <font fontName="Lucida Sans" size="9"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{compensation}]]></textFieldExpression> </textField> <textField pattern="¤ #,##0" isBlankWhenNull="true"> <reportElement x="303" y="0" width="41" height="12"/> <textElement textAlignment="Right"> <font fontName="Lucida Sans" size="9"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[($F{housing_allowance} > 0.0) ? $F{housing_allowance} : null]]></textFieldExpression> </textField> <textField pattern="¤ #,##0" isBlankWhenNull="true"> <reportElement x="202" y="0" width="41" height="12"/> <textElement textAlignment="Right"> <font fontName="Lucida Sans" size="9"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[($F{ecf} > 0.0) ? $F{ecf} : null]]></textFieldExpression> </textField> <textField> <reportElement x="249" y="0" width="45" height="12"/> <textElement textAlignment="Center"> <font fontName="Lucida Sans" size="9"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{parsonage}]]></textFieldExpression> </textField> <textField> <reportElement x="141" y="0" width="61" height="12"/> <textElement textAlignment="Center"> <font fontName="Lucida Sans" size="9"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{district}]]></textFieldExpression> </textField> </jr:listContents> </jr:list> </componentElement> Post Edited by dschafer at 02/10/2011 10:31

It appears that the printOrder attribute for a list element is ignored. Can anyone confirm this? It does not seem to be possible to get horizontal printing. If someone has a working example please post the code. Thanks

OK so I determined this as the solution. 1 - I didn't need the group since there was a 1-1 relationship between the records in the main query and the sub reports 2 - however when putting the master data in the column header the data on each following page was the same a the previous page. The resolution to item 2 was to change the evaluation time to "page" This way the master data lined up with the subreport data. good luck.

Hi I haven't found a solution yet but the behavior seem to be very specific. If the actual output of the subreport is taller that the height of the subreport design element, then it will force a new page. I've tried various combinations of stretch and report size but no solution yet. -- Dave

Hi, I have a report with a group consisting of a text field from the main query and 5 sub reports. 4 of the sub reports are only 10 or less lines each. The other may be up to 3 pages long. The layout generally works great. There is a group header that is displayed on every page. The problem is there is always an additional blank page (group header only) following each group. I've tried various heights for the large subreport. but nothing has much affect. The stretch is set to "no stretch" iReport seems like a nice tool except for this issue. Thanks.