[SQL data rounding]

I would use scriptlets:

https://community.jaspersoft.com/blog/all-you-want-know-about-scriptlets

[Subreport Reference back to Main Report?]

Have you tried to pass the information as a parameter to the subreport?

https://stackoverflow.com/questions/13843167/passing-parameters-from-main-report-to-subreport-in-jasper

[Report Book calling wrong subreport]

Maybe you are mixing the subreports parameter names.

[Can I run an Ant Task from iReport?]

 I has installed the And plug-in in iReport,, I can add/edit the ant tasks xml, but I don't know how to run the tasks from iReport. Can someone explain how to execute the targets please?

Post Edited by asejas at 12/28/2011 21:18

[¿How to use patternExpression?]

And the xsd in this location:

http://jasperreports.sourceforge.net/xsd/jasperreport.xsd

 

Don´t contains the patternExpression element.

[¿How to use patternExpression?]

I am using this header:

<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"

[¿How to use patternExpression?]

This may be a problem with the xsd, in IntelliJ Idea, the xsd used don´t contains the <patternExpression>, I had added it manually and it works. This should be an obsolete xsd problem

Post Edited by asejas at 12/22/2011 13:54

[PDF does not support font]

You need to add the not supported font as a jasperreports font extension. See the fonts sample and try to generate your own jasperreports-fonts extension jar with the needed font as ttf embedded.

[Boolean expressional doesn't work]

Or you can use two textFields (one with "YES" text and another with "NO") with "showWhenExpression" selection.

[Set specific date as default value]

I think you should use scripting in the parameter default value expression. e.g.: new java.util.Date("01-01-1970");

Post Edited by asejas at 12/22/2011 13:21

[Excel export problem with jasperreports]

I think, this should be a problem with the extension fonts jar. Perhaps the locales section in the fontFamily

Sample:

<locales>

<locale>en_US</locale>

<locale>de_DE</locale>

</locales>

 

See this: http://www.jaspersoft.com/sites/default/files/jw-presentations/JW11_JasperReports_Tips_And_Tricks_TeodorDanciu%2002.pdf

[How to load a property file in/for scriptlet]

I think, you should pass the properties file path as a report parameter (add a parameter to the template), and load the path in the scriptlet with: this.this.getParameterValue("propertiesFilePath");

[¿How to use patternExpression?]

I was reviewing the changes log, and I see the JasperReports 4.1.1 Change Log:

- pattern expression added to text fields elements to allow for more flexible
dates and numbers formatting;

But I notice that no one tag or property "patternExpression"  was added to the template xsd, the "patternExpression" field was only added in the JasperReports API.

So, ¿can I use the patternExpression through the API only?

 

Regards.

Alvaro

[Missing day in date?]

 Can you post a piece of your report template in order to explain your problem?

I think you can be missing the pattern for the date.

Code:

<textField isBlankWhenNull="true" isStretchWithOverflow="true" pattern="dd/MM/yyyy">                        <reportElement x="400" y="0" width="150" height="12" style="detailStyle"                                       stretchType="RelativeToTallestObject" mode="Opaque"/>                        <box padding="1">                            <pen lineColor="#000000" lineStyle="Solid"/>                        </box>                        <textElement textAlignment="Left"/>                        <textFieldExpression class="java.util.Date">                            <![CDATA[$F{purchaseDate}]]></textFieldExpression>                    </textField>

[Problem with evaluationTime and box padding?]

 Hi, I have a textBox in order to show the page number (e.g. 1 / 10 pages). In this textBox I show the PAGE_NUMBER variable, with a "Report" time evaluation. But when I add a box for the field padding, then the number is not rendered at all, but if I remove the box tag or I remove the evaluationTime, then the number is rendered in the report.

I am using JasperReports3.7.0 in a JEE web application.

Code:

Post Edited by asejas at 05/19/2010 13:33

[Font\'s problem in JBoss and Seam]

 I remember that spring-beans (and spring-core if required).

[Multilingual Reports and Batch Printing]

 For the text, you should use java resource bundle and setting the REPORT_LOCALE dinamically (when you ran the report).

You can see the "Internacionalization" section in the jasper reports tutorial

http://jasperforge.org/website/jasperreportswebsite/trunk/tutorial.html

For numbers formatting, you should use patterns int he textFields.

 

Regards.

 

Alvaro

[Stretch problem]

All the content you put in a band is a line, regardless of its "y" position, i.e. If you put three elements in the detail band:

A: x=0, y=0

B: x=20, y=0

C: x=50, y=20

The three elements are a line in the report, the "C" element is not another line.

If you want to have more control over the layout, you can put the elements in frames (see frame element documentation), If you put the Journal element in a frame, then it will not stretch when another element outside the frame overflows.

Post Edited by asejas at 02/09/2010 20:32

Post Edited by asejas at 02/09/2010 20:32

[install on mac not working]

 I add the permissions to the two files but not working yet.

Then I click in JasperETL-All-r12707-V2.3.2/JasperETL-macosx-carbon.app/Contents/MacOS/JasperETL-macosx-carbon and works!

[Evaluation time for a variable from a subreport]

 I have a variable when I store the value of the records processed in a subreport.

The subreport is into a group header, and I need to get the value of the variable in the same group header, I try to evaluate the variable value with evaluationTime="Group" but I only gets an empty textfield.

Is feasible to get the value of the variable in the group header? or should I move the textfield to another band?

(In the code, the problem is with the 'pollPersonCountVar' variable).

Code:

...<variable name="pollPersonCountVar" class="java.lang.Integer" calculation="System"/>...<group name="teacherGroup">        <groupExpression><![CDATA[$F{personId}]]></groupExpression>        <groupHeader>            <band height="114">                <subreport isUsingCache="true">                    <reportElement key="subreportpollByPersonSubReport" positionType="Float" x="0" y="0" width="562"                                   height="54"/>                    <parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression>                    <subreportParameter name="personIdParam">                        <subreportParameterExpression><![CDATA[$F{personId}]]></subreportParameterExpression>                    </subreportParameter>                    <subreportParameter name="JPA_ENTITY_MANAGER">                        <subreportParameterExpression><![CDATA[$P{JPA_ENTITY_MANAGER}]]></subreportParameterExpression>                    </subreportParameter>                    <returnValue subreportVariable="personGroup_COUNT" toVariable="pollPersonCountVar"/>                    <subreportExpression class="net.sf.jasperreports.engine.JasperReport">                        <![CDATA[$P{pollByPersonHeaderSubReport}]]></subreportExpression>                </subreport>                .....                 <textField isStretchWithOverflow="true" evaluationTime="Group" evaluationGroup="teacherGroup"                               isBlankWhenNull="true">                        <reportElement style="detailStyle" positionType="Float" mode="Opaque" x="450" y="30" width="112"                                       height="12"/>                        <box padding="1">                            <pen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                        </box>                        <textElement textAlignment="Right"/>                        <textFieldExpression class="java.lang.Integer">                            <![CDATA[$V{pollPersonCountVar}]]></textFieldExpression>                    </textField>            </band>        </groupHeader>        <groupFooter>.....

[Value to tallest]

 I think you forgot to set the 'stretchType' and 'positionType' properties. See sample code.

Code:

<textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement style="headerStyle" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="256" height="12"/>     <box padding="1">        <pen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>     </box>     <textElement textAlignment="Left"/>     <textFieldExpression class="java.lang.String">        <![CDATA[$R{SomeResource}]]></textFieldExpression></textField>

[Hibernate HQL query in jasper report]

 I think, when you use more than one object as result of a query, you need some like this:

http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=69898

[Referencing data in .jrxml file.]

 You can see the datasource sample in the demo directory of the JasperReports projects.

Also, I am using JR with JPA queries, some queries return an objects List, then I add the fields to the reports using a prefix and a column number, the number is the position of the field in the JPA Query (see sample code).

"COLUMN_1" maps to "someEntity.person.id" in the JPA Query, and has an alias: "person.id"

"COLUMN_2" maps to "someEntity.person.name" in the JPA Query, and has an alias: "person.name"

Hope this helps you.

Code:

QuerySELECT DISTINCT someEntity.person.id, someEntity.person.name, someEntity.person.name2 ....Fields               <field name="person.id" class="java.lang.Long">        <fieldDescription><![CDATA[COLUMN_1]]></fieldDescription>    </field>    <field name="person.name" class="java.lang.String">        <fieldDescription><![CDATA[COLUMN_2]]></fieldDescription>    </field>    <field name="person.lastName" class="java.lang.String">        <fieldDescription><![CDATA[COLUMN_3]]></fieldDescription>    </field>

[Problem with number pattern in xls report]

 IReport 3.6.2 for design. But I am setting some properties in an exporter helper class (for some reason that I don't remember now).  Should I remove this properties?

 

Code:

exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE,Boolean.TRUE);exporter.setParameter(JRXlsExporterParameter.IS_AUTO_DETECT_CELL_TYPE,Boolean.FALSE);

Post Edited by asejas at 01/20/2010 16:17

[Font 'Arial' is not available to the JVM. See the]

 This post could help:

http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=68624