Hallo everybody.
[Using Jaspertudio 6.1] I'm currently having issues with a report that must be presented on the browser through the jasper user interface.
We can not use the default page formats (ISO standards) and we want the report to flow beyond the botton of the page, so that the user can read data without hitting next continuously.
Now the problem is that, on chrome, the report is sluggish as hell because too much data is loaded into the page (when rendering with "ignorePagination").
So, we'd like to set page breaks but also that those page breaks will not be commanded by page format, so that the page can flow beyond an A3 page and break when a particular Group resets.
Is a behaviour like this possible without touching java code?
Thanks
1 Answer:
Check this jrxml. the page breaks at each year... this is oracle sql.
The height is set at 15000 pixels which i believe is totally sufficient for any requirement.
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0 -->
<!-- 2016-12-02T14:03:08 -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="sss" pageWidth="2000" pageHeight="15000" orientation="Landscape" columnWidth="1960" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="d636513c-6fad-4279-973d-754c6d542965">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="PRODSUP"/>
<property name="com.jaspersoft.studio.unit." value="pixel"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<queryString>
<![CDATA[select (trunc(sysdate+1) + level -1) as business_date, extract(year from (trunc(sysdate+1) + level -1)) year
from dual
connect by sysdate + level -1 < sysdate + 5000]]>
</queryString>
<field name="BUSINESS_DATE" class="java.sql.Timestamp"/>
<field name="YEAR" class="java.math.BigDecimal"/>
<group name="YEAR" isStartNewPage="true">
<groupExpression><![CDATA[$F{YEAR}]]></groupExpression>
<groupHeader>
<band height="30">
<textField>
<reportElement mode="Opaque" x="0" y="0" width="100" height="30" backcolor="#FF0400" uuid="59706528-fe71-4ae4-8d62-ed22c89b0b51"/>
<textFieldExpression><![CDATA[$F{YEAR}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
</group>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="30">
<textField pattern="MMM dd, yyyy">
<reportElement x="0" y="0" width="392" height="30" uuid="7e28de3c-2a78-4a36-8b56-419c431512de"/>
<textFieldExpression><![CDATA[$F{BUSINESS_DATE}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>
