[View report in XLS format]

Below is the list of properties that can accommodate the report export to excel format.

Also, check to make sure all fields on the report are aligned vertically and horizontally and remove any spaces in between including page mergings.

<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns"value="true"/>

<property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="false"/>

<property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.1" value="pageHeader"/>
<property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.2" value="pageFooter"/>
<property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.3" value="lastPageFooter"/>
<property name="net.sf.jasperreports.export.xlsx.ignore.cell.background" value="true"/>
<property name="net.sf.jasperreports.export.xlsx.white.page.background" value="false"/>
<property name="net.sf.jasperreports.export.xlsx.ignore.graphics" value="true"/>
<property name="net.sf.jasperreports.export.xlsx.detect.cell.type=true"/>
<property name="net.sf.jasperreports.export.xlsx.remove.empty.space.between.rows=true"/>
<property name="net.sf.jasperreports.export.xlsx.remove.empty.space.between.columns=true"/>
<property name="net.sf.jasperreports.export.xlsx.collapse.row.span" value="true"/>
<property name="net.sf.jasperreports.export.xlsx.ignore.page.margins=true"/>
<property name="net.sf.jasperreports.export.xlsx.one.page.per.sheet=true"/>
<property name="net.sf.jasperreports.export.xlsx.wrap.text" value="true"/>
<property name="net.sf.jasperreports.export.xls.column.width.ratio" value="1.10f"/>
<property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/>

<property name="net.sf.jasperreports.export.xls.freeze.row" value="2"/>

<property name="net.sf.jasperreports.exports.xls.font.size.fix.enabled" value="false"/>

<property name="net.sf.jasperreports.export.xls.sheet.names.all" value="Data/Footnotes"/>

[Report Grouping]

................................................................................................

 

[Query work, but no in Jaspersoft]

It looks like the CA-158 error (SAP) is the same as the HTTP 408 error. Check the article: What Is a 408 Request Timeout and How to Fix It (https://www.exai.com/blog/408-request-timeout-error). I hope this helps.

[Query work, but no in Jaspersoft]

Would you be able to provide the full TEXT error ?

Also,check to make sure the sas.Servis and Pocet are not Zero; otherwise, it will be an endless loop in your formula (100/Pocet*sas.Servis). Use NULLIF function - NULLIF(expression1, expression2) to avoid division by zero.

[How to transfer the Scheduler of Jaspersoft reports from one user to another user.]

Any roles with read-only permission can schedule a report.

[Query work, but no in Jaspersoft]

Would you be able to provide the error you see in  Jasper? I am just guessing here that Jasper doesn’t like the query line with .object. ( ae.object.objectId) , the error may provide more info on why the query doesn’t work in Jasper.

[if field 1 is not empty then field 1 else field 2.]

Use Print When Expression. Please see the example below.

Assuming that VAR1 in Field 1 and VAR2 in Field 2, then add expression to Print When Expression: $F{VAR1}!=null   will display  field 1 when it is not empty. The same for field 2.

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.16.0.final using JasperReports Library version 6.16.0-48579d909b7943b64690c65c71e07e0b80981928  -->
<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="2fields" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="8d2657b1-69a0-45dc-95f3-d1f76163e412">
    <parameter name="Field1" class="java.lang.String"/>
    <parameter name="Field2" class="java.lang.String"/>
    <queryString>
        <![CDATA[]]>
    </queryString>
    <background>
        <band splitType="Stretch"/>
    </background>
    <pageHeader>
        <band height="81" splitType="Stretch">
            <textField evaluationTime="Report">
                <reportElement mode="Opaque" x="10" y="8" width="460" height="30" forecolor="#FFFFFF" backcolor="#FA100C" uuid="e7344090-e068-42b3-a60e-1199c653d487">
                    <printWhenExpression><![CDATA[$P{Field1}!=null]]></printWhenExpression>
                </reportElement>
            </textField>
            <textField evaluationTime="Report">
                <reportElement mode="Opaque" x="10" y="40" width="460" height="30" forecolor="#050505" backcolor="#07FAE6" uuid="c81b9400-78e0-4840-964a-ae69d67644c3">
                    <printWhenExpression><![CDATA[$P{Field2}!=null]]></printWhenExpression>
                </reportElement>
            </textField>
        </band>
    </pageHeader>
</jasperReport>

 

[How to dynamic pass Datasource to subreports]

The only way I know of to have a connection to multiple data sources is to use connection parameter(s).

Suggestion is:

• Use one of the subreports as the main report or at least use the same data source

(you can select the data source and then place on the main report query  something like- Select 1 from dual )

• Create Parameter (i.e., $P{Subreport2_conn}) on the main report  to use for connection to the data source in Subreport2:
  • Class: java.sql.Connection
  • Is For Promting: Uncheck
  • Default value Expression: java.sql.DriverManager.getConnection("jdbc:oracle:thin:@YourServerIP:YourServerPort/yourdatabase","UserID","Password")

Not sure what your drive is; in my case, it is   jdbc:oracle:thin

• Set the Connection Expression in Subreport2 to $P{Subreport2_conn}

I was using the same approach to connect five different data sources from one report.

I hope this helps.

[Report Number Fields]

Have you tried to change the Class Type (i.e. dollar amounts - to java.lang.Double)  in JasperStudio Dataset and Query Dialog window?

[Jaspersoft Studio File Naming issue]

JasperStudio adds _# to the file name if the same file name exists in derctory.

Tip: To stay organized, create a separate folder for each report in JasperSoft Studio (MyReports).

[How to create waffle chart?]

Unfortunately, there is no such chart that exists in JasperStudio.

See if the visualization element can help you achieve your goal.

[report list]

https://yourjasperserver.com/jasperserver/rest/resources/reports?type=reportUnit&recursive=1

You may need to copy and paste it to the notepad++ to remove unwanted tags. Of course, this is not an ideal solution, but you will get  list of all reports from the JasperServer.

[Error while trying to publish to JasperReports Server]

Try to publish the report  again by click on the Publish icon in the Jasper Studio and then point the parameter to the  correct resource reference.

Tip: Create an Archive folder on the server (with only access by admin role), then copy the folder with the reports you want to update and paste it into Archive. This way, you will have a previous copy of the report for tracking and recovery purposes.

[Pull report data queries from Jasper Reports]

In order to edit queries in Jasper reports you need to install JasperSoft studio and then you will be able to transfer reports from the server ( repository explorer ) to JasperSoft on your computer (Project Explorer).

[remove line when blank in detail of subreport]

In order to use "Remove Line When Blank" in Detail band,  the whole line must be empty. In your case, there is a Static text filed on the first line. You may try to put all variables in one field and use "n"  between the records, however it will required to validate the variable and verify  if it is empty or not.

[How to prevent group footer starting on new page?]

If the report is not set as Ignore Pagination, it is all about setting the correct height in all bands. That means you should know how many rows in the Detail band will occupy available space on the first page. Adding a border to the field may help see how much space the area is occupied.

[textfield textAdjust="stretchHeight" is not stretching for dynamic text]

Try to change the Reset type for  $V{signedInfo}  , I am not sure if it is appropriate for your report

Please see the example below where variable Reset Type is set to None insted of Report

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.16.0.final using JasperReports Library version 6.16.0-48579d909b7943b64690c65c71e07e0b80981928  -->
<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="Blank_A4_2" pageWidth="595" pageHeight="400" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="b736cbc8-581d-4f10-985f-78b77784ea4c">
    <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">
        <box>
            <pen lineWidth="0.5" lineColor="#000000"/>
            <topPen lineWidth="0.5" lineColor="#000000"/>
            <leftPen lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
            <rightPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF">
        <box>
            <pen lineWidth="0.5" lineColor="#000000"/>
            <topPen lineWidth="0.5" lineColor="#000000"/>
            <leftPen lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
            <rightPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
        <box>
            <pen lineWidth="0.5" lineColor="#000000"/>
            <topPen lineWidth="0.5" lineColor="#000000"/>
            <leftPen lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
            <rightPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <parameter name="signedInfo" class="java.lang.String">
        <defaultValueExpression><![CDATA["I have tried every cobination of positionType and stretchType and evaluation time. Nothing has worked. I even made sure the print order is vertical. I used jasper version 6.11 and even upgraded to 6.17. No success. Whenever the dynamic text from the variable is longer than the text field and takes up a second line, it only shows the first line."]]></defaultValueExpression>
    </parameter>
    <queryString>
        <![CDATA[]]>
    </queryString>
    <variable name="signedInfo" class="java.lang.String" resetType="None">
        <variableExpression><![CDATA[$P{signedInfo}]]></variableExpression>
    </variable>
    <variable name="signedInfo_1" class="java.lang.String">
        <variableExpression><![CDATA[$P{signedInfo}]]></variableExpression>
    </variable>
    <pageHeader>
        <band height="43" splitType="Prevent">
            <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/>
            <textField textAdjust="StretchHeight" evaluationTime="Auto">
                <reportElement positionType="Float" stretchType="ContainerHeight" x="110" y="0" width="120" height="16" uuid="939ca8a9-5c57-445a-8992-54babc9c7302">
                    <property name="com.jaspersoft.studio.unit.height" value="px"/>
                    <property name="com.jaspersoft.studio.unit.width" value="px"/>
                </reportElement>
                <textFieldExpression><![CDATA[$V{signedInfo}]]></textFieldExpression>
            </textField>
            <textField textAdjust="StretchHeight" evaluationTime="Auto">
                <reportElement positionType="Float" stretchType="ContainerHeight" x="360" y="0" width="190" height="16" uuid="1548eef7-f54a-4b53-945f-29552fcb6bee">
                    <property name="com.jaspersoft.studio.unit.height" value="px"/>
                    <property name="com.jaspersoft.studio.unit.width" value="px"/>
                </reportElement>
                <textFieldExpression><![CDATA[$V{signedInfo_1}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement x="0" y="0" width="100" height="16" uuid="fb7b2e39-2bdf-4ddc-ab71-2bae725aa85b"/>
                <text><![CDATA[Reset Type =None]]></text>
            </staticText>
            <staticText>
                <reportElement x="250" y="0" width="100" height="16" uuid="288d8362-f38c-4d8b-b023-046cbc9883ac"/>
                <text><![CDATA[Reset Type =Report]]></text>
            </staticText>
        </band>
    </pageHeader>
</jasperReport>
 

[Replace character with new line]

$F{Intervenant(s)}.replace("/","n")

[compare 2 string while one does an int operation returns error]

 

Variables ANO and ANO_ACT cannot be null  and must be evaluated. 

Expression:  $P{ANO}!=null? ($P{ANO}.equals($P{ANO_ACT}!=null ? (Integer.parseInt($P{ANO_ACT})-1+""): "ANO_ACT is Null")?$V{CAN}:new BigDecimal("0")): "ANO is empty"

See example below:

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.16.0.final using JasperReports Library version 6.16.0-48579d909b7943b64690c65c71e07e0b80981928  -->
<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="String to Integer" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="c5f3f90c-4936-41e8-a034-b7a768ac9060">
    <parameter name="ANO" class="java.lang.String"/>
    <parameter name="ANO_ACT" class="java.lang.String"/>
    <queryString>
        <![CDATA[]]>
    </queryString>
    <variable name="CAN" class="java.lang.String">
        <initialValueExpression><![CDATA["CAN"]]></initialValueExpression>
    </variable>
    <background>
        <band splitType="Stretch"/>
    </background>
    <pageHeader>
        <band height="35" splitType="Stretch">
            <textField>
                <reportElement x="80" y="5" width="430" height="30" uuid="d99f10a3-6103-4987-ab25-33932aa27d2c"/>
                <textFieldExpression><![CDATA[$P{ANO}!=null? ($P{ANO}.equals($P{ANO_ACT}!=null ? (Integer.parseInt($P{ANO_ACT})-1+""): "ANO_ACT} is Null")?$V{CAN}:new BigDecimal("0")): "ANO is empty"
]]></textFieldExpression>
            </textField>
        </band>
    </pageHeader>
    <summary>
        <band height="42" splitType="Stretch"/>
    </summary>
</jasperReport>
 

 

[How to prevent group footer starting on new page?]

Please provide the code of your report.

[Page overflows with empty space when textfield stretches]

To keep the page format you may need to uncheck "Ignore Pagination".

Values

true   The report will be generated on one long page. The specified page height will still be used for report design. false   The report will be paginated according to the pageHeight attribute.

[Page overflows with empty space when textfield stretches]

You may expand other bands like header or footer to accommodate the visual format, but expanding the Detail band only adds space between rows.

[Display a text on jasperstudio using balise HTML in expression]

Change the text field “Markup” to HTML 

Expression:  "This is my "+ " " +"<"+"<"+"Report"+">"+">"

or "This is my  "+"<<Report>>"

 

See Example below:

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.16.0.final using JasperReports Library version 6.16.0-48579d909b7943b64690c65c71e07e0b80981928  -->
<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="Blank_A4_5" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="63aa31c7-2c3f-4f3e-aabd-cb707c3743db">
    <queryString>
        <![CDATA[]]>
    </queryString>
    <background>
        <band splitType="Stretch"/>
    </background>
    <pageHeader>
        <band height="107" splitType="Stretch">
            <textField>
                <reportElement x="120" y="10" width="310" height="30" uuid="ffee2868-50ed-4d72-82a4-b4c5d6d35885"/>
                <box>
                    <pen lineWidth="0.25"/>
                </box>
                <textElement markup="html"/>
                <textFieldExpression><![CDATA["This is my "+ " " +"<"+"<"+"Report"+">"+">"]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement x="20" y="10" width="100" height="30" uuid="b06091aa-b4a7-40e2-b557-1d6b6899b85d"/>
                <box>
                    <pen lineWidth="0.25"/>
                </box>
                <text><![CDATA

]></text>
            </staticText>
            <staticText>
                <reportElement x="20" y="50" width="100" height="30" uuid="f975511e-1abd-4952-8286-37f21e8d9876"/>
                <box>
                    <pen lineWidth="0.25"/>
                </box>
                <text><![CDATA[Default]]></text>
            </staticText>
            <textField>
                <reportElement x="120" y="50" width="310" height="30" uuid="ed073ad1-4d38-427f-855b-710a8fa8125b"/>
                <box>
                    <pen lineWidth="0.25"/>
                </box>
                <textFieldExpression><![CDATA["This is my "+ " "+"<<Report>>"]]></textFieldExpression>
            </textField>
        </band>
    </pageHeader>
</jasperReport>

[How to do a line break on the expression?]

Option one:  use only  "n".

Option 2: Change the text field “Markup” to HTML and use "<br>"

[Page overflows with empty space when textfield stretches]

Keep the Detail band height within height of the contents. Double click on the Detail band will shrink the band.