[Insert a blank page between two OLE documents in Jasper report]

Thank you. The detail band with the Break elements needs to be placed after the band containing the subreport in the JRXML. Something like:

    <detail>        <band height="20" splitType="Stretch">            <subreport isUsingCache="true" runToBottom="true">                ...            </subreport>        </band>        <band height="50">            <break>                 ...            </break>            <staticText>                 ...            </staticText>            <break>                 ...            </break>       </band>    </detail>

 

[Insert a blank page between two OLE documents in Jasper report]

Well, in this case it would be very useful if you could post your JRXML file here, in order to illustrate the report layout in your case.

Thank you,

Sanda

[Insert a blank page between two OLE documents in Jasper report]

The detail section can contain multiple bands, so you could insert a second detail band that contains 2 Break elements with an empty Static Text element between them. See the attachment.

[display a subreport in the second worksheet]

Hi,

It depends on your report layout. Usually you could place a Break element before the subreport and this will do the job. Also make sure the net.sf.jasperreports.export.xls.one.page.per.sheet flag is turned on.

In case these settings don't solve the problem, please post your JRXML files here.

[Generate one pdf per page with jasper report]

This PAGE_INDEX parameter can be used with JasperReports API directly, as C-Box said.

If you are using Jaspersoft Studio, you could set this parameter by clicking on Report Parameters icon in the Parameters section of the Preview area (see attachment image)

[Formatting $ on left and amount on right.]

As already discussed above, you'll need to set a currency pattern for the textfield, to be considered in output formats other than Excel (PDF, HTML, etc).

For the Excel output, you also need to set the net.sf.jasperreports.export.xls.pattern property for that textfield, in order to generate an Excel-specific accounting pattern when exporting to Excel. Try to use the following expression:

<propertyExpression name="net.sf.jasperreports.export.xls.pattern">    <![CDATA["$\ * #,##0.00;$\ * -#,##0.00"]]></propertyExpression>

 

[Getting error when there are spaces in image path in 6.7.1]

As a workaround you could use the replaceAll() method in the image expression. Something like

<imageExpression> <![CDATA["http://localhost:8070/webdav/Space In Name.jpg".replaceAll(" ","%20")]]></imageExpression>

Or, if your image url is stored in a field named image_url:

<imageExpression><![CDATA[$F{image_url}.replaceAll(" ","%20")]]></imageExpression>

 

[Getting error when there are spaces in image path in 6.7.1]

Spaces need to be URL-encoded in order to be considered. Try with "http://localhost:8070/webdav/Space%20In%20Name.jpg" and see if the problem is solved.

[Can we create group dynamically using JasperReport Library?]

You need to create and customize a JRDesignGroup first.

For instance, see the noxmldesign sample shipped with the JasperReports distro: http://jasperreports.sourceforge.net/sample.reference/noxmldesign/index.html#noxmldesign

[JasperReportsIO: Fusion Reports not working]

Fusion Components are not shipped with JasperReports IO Commercial Edition. In order to process Fusion reports, you'll need to

• place the jasperreports-fusion.jar file into the jrio/WEB-INF/lib folder
• include the Fusion components javascript files into the jrio-client application
• edit the jrio-client/scripts/require.config.js file in order to consider the Fusion components

 

[Report based on a temporary table]

Properties available in "Connection Properties" tab are driver-specific. For instance, if you're using the OracleDriver class, try to set the 'autoCommit' connection property to false (see attachment).

[Report with remote XML Data Source]

Here is an updated wiki article which may be helpful:

https://community.jaspersoft.com/wiki/remote-xml-data-sources-tibco-jasperreports-server

[How can I solve this problem of continuity of a detail (line) in another page?]

The following workaround should help: for each textfield in the detail section place an empty frame with borders, having the same x, y, width and height as the textfield. Set isPrintWhenDetailOverflows="true" for the frame:

<frame>    <reportElement stretchType="ContainerHeight" x="150" y="0" width="100" height="30" isPrintWhenDetailOverflows="true"/>    <box>        <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>        <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>        <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>        <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>    </box></frame><textField>    <reportElement stretchType="ContainerHeight" x="150" y="0" width="100" height="30"/>    <box>        <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>        <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>        <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>        <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>    </box>    <textFieldExpression><![CDATA["text content"]]></textFieldExpression></textField>

Note that the textfield is placed as standalone and not enclosed into the frame.
Also, the <box> element in the textfield should be kept for getting accurate results when using grid exporters (Excel, ODS, etc).

 

[Generate unchangeable pdf files]

You'll need to generate encrypted PDF documents in order to configure different document permissions at export time. The following properties should be set in the JRXML file:

• net.sf.jasperreports.export.pdf.128.bit.key
• net.sf.jasperreports.export.pdf.encrypted
• net.sf.jasperreports.export.pdf.permissions.allowed
• net.sf.jasperreports.export.pdf.permissions.denied

[Getting extra whitepace(padding) at bottom of text field]

The most recommended way to deal with fonts in JasperReports is to use font extensions. There is a built-in font extension based on DejaVu fonts, so all you need is just to choose the 'DejaVu Sans' font name from the element properties drop down list. The font will be automatically embedded during the PDF export.

In this case there is no more need of PDF FontName, PDF Embedded and PDF Encoding settings. They should be removed from textfields.

Also, to get the same text line breaks in PDF as in Java, the following property in the JRXML file will help:

<property name="net.sf.jasperreports.export.pdf.force.linebreak.policy" value="true"/>

[NoSuchMethodError in jasper report after importing a jar file]

Use JFreeChart v. 1.0.19 instead of 1.5.0

Some packages were moved/renamed in 1.5.0: https://github.com/jfree/jfreechart/blob/master/README.md#migration-from-jfreechart-10x

[Import Library in Jasper Studio 5.6.1]

You can also add imports by direct editing the JRXML file. Place this line in your report, after the <property> entries and before the first <style> declaration:

<import value="org.apache.poi.ss.usermodel.DateUtil"/>

[Unwanted Page Break before Summary Band]

Apparently there is a problem with the splitType attribute of the summary band. Try to set it as "Immediate" and see if it works as you need. If the problem is still there, please post the JRXML of the main report too. Thanks.

[Import Library in Jasper Studio 5.6.1]

In Jaspersoft Studio use the Imports section in the Properties pane to import a needed class or package.

[How to set value to REPORT_TIMEZONE parameter in jrxml?]

In case of JasperServer the time zone value in the login page acts as a default REPORT_TIME_ZONE parameter for all reports in the app. In this situation another property might be useful:

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.pattern.timezone

You'll need to set this property for each report element that depends on a timezone value.

Also check this post for another possible solution:

https://community.jaspersoft.com/questions/815702/need-pass-local-browser-timezone-login

[Unwanted Page Break before Summary Band]

Please post your JRXML here, if possible, to help us reproduce the problem. Thank you.

[Getting extra whitepace(padding) at bottom of text field]

Hi, I couldn't reproduce the problem using the JRXML sample. I only noticed that the $F{COLLATERAL} textfield has no stretchType attribute. Try to set the stretchType as "RelativeToTallestObject" like in the other textfields and see if the issue is gone. If the problem persists, please post a screenshot to illustrate where it occurs and for which values. Thank you.

[How to set value to REPORT_TIMEZONE parameter in jrxml?]

You could obtain this behavior by setting the net.sf.jasperreports.default.timezone property in JRXML.

When net.sf.jasperreports.default.timezone property is set in the JRXML file, it will affect only this report, having the same effect as the REPORT_TIME_ZONE parameter.

[How to set value to REPORT_TIMEZONE parameter in jrxml?]

You can set the report timezone dynamically, through JasperReports API:

Map params = new HashMap<String, Object>();params.put(JRParameter.REPORT_TIME_ZONE, TimeZone.getTimeZone("GMT"));...JasperFillManager.fillReportToFile("my_jasper_file", params, new JREmptyDataSource())

Another possibility would be to use this property in the JRXML file:

<property name="net.sf.jasperreports.default.timezone" value="GMT"/>

See http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.default.timezone

[List element with frame element produces blank second page]

Try to set the detail band height to 130 px (the minimum allowed value in order to enclose both the list and the frame element) instead of 554 px. Keep the band split type as 'Stretch'. When the list contains many elements and stretches beyond limits, the detail band will also stretch accordingly.