[resolved] tJasperReportExec and Umlauts

One Star

[resolved] tJasperReportExec and Umlauts

Hi all,
I managed to create a job that loops through a MySQL-Table and saves PDFs of a Jasperreport for each ID.
When I have Jaspersoft Studio create the .jasper files, the output of tables aren't correct. For example cells aren't centered or font is too big where I made it smaller to fit the cell.
When I delete all .jasper files and have Talend tJasperReportExec create them, format is perfect, but in text fields I have no Umlauts. Text in tables that comes from Database is fine.
Text Fields are styled and font is Sans serif, nothing special here.
I use:
Jaspersoft Studio 6.04 (with compatibility set to 5.5.1 or other makes no difference)
Talend Open Studio for Data Integration 5.6.1
tJasperReportExec 1.11
All local on Windows 8.1 PC.
If you need more information I'll be happy to provide it.
Thanks a lot in advance.

Accepted Solutions
Seventeen Stars

Re: [resolved] tJasperReportExec and Umlauts

To be in danger driving you creasy here is my own test and it convinced my, there is something wrong with your way to write the jrxml file:

The way the wrong encoding is showing is very typical for a reading of an text file with the wrong char set.
Could you check if the char set of the jrxml file is UTF-8. Perhaps you open it with UltraEdit with fix setup UTF-8 encoding.
Please test if it works if you add a tJava with this code:
System.setProperty("file.encoding", "UTF-8");

before the jasper comp. It changes the default encoding and this way your file should be read correctly.

All Replies
Moderator

Re: [resolved] tJasperReportExec and Umlauts

Hi,
Did you get tJasperReportExec component from Talend Exchange:https://exchange.talend.com/#marketplaceproductoverview:gallery=marketplace%252F1&pi=marketplace%252...?
Have you already checked component reference?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seventeen Stars

Re: [resolved] tJasperReportExec and Umlauts

I will check that. Actually I am convinced it should work because it does it for my current project.
One Star

Re: [resolved] tJasperReportExec and Umlauts

Thank you for your replies. Yes, I've doublechecked the reference and the forums both of Jaspersoft and Talend, but I couldn't find anything helpful.
I opened the binary files in a normal editor and found this, which should be "für" and "Größenverteilung":
.jasper from Jaspersoft Studio:
zur Ausbildung für Ihr Unternehmen and Die Größenverteilung
.jasper from Talend tJasperReportExec
zur Ausbildung für Ihr Unternehmen and Die Größenverteilung
I know it's a binary, but to me it looks as if tJasperReportExec somehow doubles the Umlauts while creating the jasper, so it can't be decoded correctly.
Is this helpful?
Other than that I'm as convinced it should work as you are, jlolling, because nobody else asked for help. This tells me I'm the culprit, but I have no idea where to look.
Thanks again in advance.
Seventeen Stars

Re: [resolved] tJasperReportExec and Umlauts

OK, I have tested it and I can ensure you it works.
 

Back to your problem. 
Did you spot encoding errors in JasperStudio? 
There are always possible problems with the encoding in the MySQL database which is per default set up with charset LATIN1. I suggest you reconfigure the database (or even the tables with UTF-8).
Seventeen Stars

Re: [resolved] tJasperReportExec and Umlauts

OK, I have tested it and I can ensure you it works. The PDF is created by a simple Talend job made of a tMysqlConnection and tJasperReportExec.
 

Back to your problem. 
Did you spot encoding errors in JasperStudio? 
I suggest you build a very simple job - like mine - and test the encoding straight forward to be sure you are at the right place to fix the problem. Perhaps you can post here your job design. 
There are always possible problems with the encoding in the MySQL database which is per default set up with charset LATIN1. I suggest you reconfigure the database (or even the tables with UTF-8).
Here my very simple jrxml:

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.1.0.final using JasperReports Library version 5.5.1  -->
<!-- 2015-05-27T07:49:23 -->
<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="test_umlauts" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="262988c5-a8bf-4cc7-b628-3767e070f2fa">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="local_mysql"/>
<queryString>
<!]>
</queryString>
<field name="umlauts" class="java.lang.String">
<fieldDescription><!]></fieldDescription>
</field>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="79" splitType="Stretch"/>
</title>
<pageHeader>
<band height="35" splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band height="61" splitType="Stretch">
<staticText>
<reportElement x="190" y="20" width="100" height="30" uuid="acad6421-f00d-4552-a092-69974176f454"/>
<text><!]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="125" splitType="Stretch">
<textField>
<reportElement x="0" y="20" width="550" height="90" uuid="f45d6063-16f1-4d35-8cd5-7380e1a7584c"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="26"/>
</textElement>
<textFieldExpression><!]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="45" splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="54" splitType="Stretch"/>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>
One Star

Re: [resolved] tJasperReportExec and Umlauts

Unfortunately it has nothing to do with MySQL. Text coming from Database is fine. I use "Text Field" and those drive me nuts.
Here is the .jrxml I use:
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.0.4.final using JasperReports Library version 6.0.0  -->
<!-- 2015-05-27T15:50:07 -->
<jasperReport xmlns="" xmlns:xsi="" xsi:schemaLocation=" " name="test_pdf" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="9026e51d-fac0-496b-b200-62c15060a142">
<property name="com.jaspersoft.studio.unit." value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="BM_Chemie"/>
<style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="1.5" lineColor="#000000"/>
<topPen lineWidth="1.5" lineColor="#000000"/>
<leftPen lineWidth="1.5" lineColor="#000000"/>
<bottomPen lineWidth="1.5" lineColor="#000000"/>
<rightPen lineWidth="1.5" lineColor="#000000"/>
</box>
</style>
<style name="Table_CH" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="1.5" lineColor="#000000"/>
<topPen lineWidth="0.0" lineColor="#BABABA"/>
<leftPen lineWidth="0.0" lineColor="#BABABA"/>
<bottomPen lineWidth="1.5" lineColor="#BABABA"/>
<rightPen lineWidth="1.5" lineColor="#BABABA"/>
</box>
</style>
<style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="1.5" lineColor="#000000"/>
<topPen lineWidth="1.5" lineColor="#BABABA"/>
<leftPen lineWidth="0.0" lineColor="#BABABA"/>
<bottomPen lineWidth="1.5" lineColor="#BABABA"/>
<rightPen lineWidth="1.5" lineColor="#BABABA"/>
</box>
</style>
<subDataset name="table2013" whenResourceMissingType="Empty" uuid="a59db18c-efc2-4d64-bf4c-0528ec0e3b09">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Testbench"/>
<parameter name="company" class="java.lang.Integer"/>
<queryString language="SQL">
<!]>
</queryString>
<field name="Standort" class="java.lang.Double"/>
<field name="Gesamt" class="java.lang.Double"/>
<field name="Min" class="java.lang.Double"/>
<field name="Max" class="java.lang.Double"/>
<field name="N" class="java.lang.Integer"/>
<field name="eins" class="java.lang.String"/>
</subDataset>
<parameter name="company" class="java.lang.Integer"/>
<queryString language="SQL">
<!]>
</queryString>
<field name="company" class="java.lang.Integer">
<fieldDescription><!]></fieldDescription>
</field>
<field name="f01_other" class="java.lang.String">
<fieldDescription><!]></fieldDescription>
</field>
<field name="f01a_1" class="java.lang.String">
<fieldDescription><!]></fieldDescription>
</field>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="21">
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<textField isStretchWithOverflow="true" bookmarkLevel="1">
<reportElement mode="Opaque" x="0" y="0" width="400" height="21" backcolor="#FFFFFF" uuid="12c64614-fd65-4c5c-9ec9-b112b13f0c82">
<property name="local_mesure_unitwidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement markup="styled"/>
<textFieldExpression><!]></textFieldExpression>
<anchorNameExpression><!]></anchorNameExpression>
</textField>
</band>
</title>
<detail>
<band height="131">
<textField isStretchWithOverflow="true">
<reportElement x="30" y="30" width="455" height="70" forecolor="#006AB3" uuid="74d4617b-f833-4b95-9026-d1ba0e245e22"/>
<textElement textAlignment="Center">
<font size="22"/>
</textElement>
<textFieldExpression><!]></textFieldExpression>
</textField>
</band>
</detail>
<summary>
<band height="178" splitType="Stretch">
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<componentElement>
<reportElement x="20" y="0" width="380" height="70" uuid="a8f1cc99-c706-49fb-8e6c-9c24cdfba4d0">
<property name="local_mesure_unitwidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="local_mesure_unitx" value="pixel"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="net.sf.jasperreports.export.headertoolbar.table.name" value=""/>
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<jr:table xmlns:jr="" xsi:schemaLocation=" ">
<datasetRun subDataset="table2013" uuid="937e09f4-1951-47e8-9505-7ca6dece7b92">
<datasetParameter name="company">
<datasetParameterExpression><!]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><!]></connectionExpression>
</datasetRun>
<jr:columnGroup width="381" uuid="60524045-a7ab-438e-81cd-68047f835810">
<jr:tableFooter style="Table_TD" height="20">
<textField>
<reportElement x="10" y="0" width="371" height="20" uuid="4798c507-70b4-4c10-a1f8-4ecd2bac8f00"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><!]></textFieldExpression>
</textField>
</jr:tableFooter>
<jr:column width="140" uuid="7b015e11-9681-4d3a-9b77-c1e92ac5c6a4">
<jr:columnHeader style="Table_CH" height="20">
<staticText>
<reportElement x="10" y="0" width="130" height="20" uuid="e05f22e8-6691-45e8-8fa8-1604a1713511">
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="8" isBold="true"/>
</textElement>
<text><!]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="10" y="0" width="130" height="30" uuid="2aaebd59-8c54-4244-a154-186d7625c474"/>
<textElement textAlignment="Left" verticalAlignment="Middle" markup="styled"/>
<textFieldExpression><!]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="49" uuid="5e9d8d39-5ac0-4a56-b35f-ccfad2a8cdb6">
<property name="local_mesure_unitwidth" value="pixel"/>
<jr:columnHeader style="Table_CH" height="20">
<staticText>
<reportElement x="0" y="0" width="49" height="20" uuid="35350943-c05b-4eb3-9b95-f1bfe6acd438">
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="local_mesure_unitwidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><!]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField pattern="" isBlankWhenNull="true">
<reportElement x="10" y="0" width="39" height="30" uuid="dc65f757-f645-42a8-b0c5-a1ab011b3dfb"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><!]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="49" uuid="a28b2265-5da8-488b-b683-2674c248b9df">
<property name="local_mesure_unitwidth" value="pixel"/>
<jr:columnHeader style="Table_CH" height="20">
<staticText>
<reportElement x="0" y="0" width="49" height="20" uuid="93753893-be33-415f-9274-b6715048d69c">
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="local_mesure_unitwidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><!]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField pattern="" isBlankWhenNull="false">
<reportElement x="10" y="0" width="39" height="30" uuid="20210ad0-0ded-4c89-8116-0aba1c8ae124"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><!]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="49" uuid="62dac8af-9fb7-44d0-84f0-9321020cccce">
<property name="local_mesure_unitwidth" value="pixel"/>
<jr:columnHeader style="Table_CH" height="20">
<staticText>
<reportElement x="0" y="0" width="49" height="20" uuid="b9c8a623-c6ae-4550-bfbf-fcd8f8bb33b7">
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="local_mesure_unitwidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><!]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField isBlankWhenNull="true">
<reportElement x="10" y="0" width="39" height="30" uuid="a798262a-b81b-41df-8a8e-51bc0788efca"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><!]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="49" uuid="7954d5b6-e477-4ab6-802f-83332f2f51c4">
<property name="local_mesure_unitwidth" value="pixel"/>
<jr:columnHeader style="Table_CH" height="20">
<staticText>
<reportElement x="0" y="0" width="49" height="20" uuid="f97a5f79-b9fc-4499-b588-a8ff7080dfb3">
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="local_mesure_unitwidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><!]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField isBlankWhenNull="true">
<reportElement x="10" y="0" width="39" height="30" uuid="7c8690ff-c905-4f36-95de-c14bb4eb4d60"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><!]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="45" uuid="50f938f3-b283-40ee-b9ad-806006453299">
<property name="local_mesure_unitwidth" value="pixel"/>
<jr:columnHeader style="Table_CH" height="20">
<staticText>
<reportElement x="0" y="0" width="45" height="20" uuid="1ef23c37-3ab3-4368-9aeb-8203b62a9b7d">
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><!></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="10" y="0" width="35" height="30" uuid="b0a94e88-9155-4288-87e0-aaa71cca9fe5"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><!]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
</jr:columnGroup>
</jr:table>
</componentElement>
<textField isStretchWithOverflow="true">
<reportElement positionType="Float" x="20" y="80" width="405" height="70" uuid="5a134bf3-bab9-4823-97ff-14c9db008ba1">
<property name="local_mesure_unitx" value="pixel"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="local_mesure_unity" value="pixel"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="local_mesure_unitwidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement markup="styled">
<font fontName="SansSerif"/>
</textElement>
<textFieldExpression><!]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>

For the MySQL-Database called testbench:
CREATE TABLE IF NOT EXISTS `jan15` (
 `id` int(11) DEFAULT NULL,
 `company` int(11) DEFAULT NULL,
 `f01_other` varchar(50) DEFAULT NULL,
 `f01a_1` varchar(50) DEFAULT NULL,
 `Jahr` int(11) DEFAULT NULL,
 `share_f07_0` decimal(6,1) DEFAULT NULL,
 `share_f07_8` decimal(6,1) DEFAULT NULL,
 `share_f07_15` decimal(6,1) DEFAULT NULL,
 `share_f07_0_min` decimal(6,1) DEFAULT NULL,
 `share_f07_0_max` decimal(6,1) DEFAULT NULL,
 `share_f07_0_N` int(11) DEFAULT NULL,
 `share_f07_8_min` decimal(6,1) DEFAULT NULL,
 `share_f07_8_max` decimal(6,1) DEFAULT NULL,
 `share_f07_8_N` int(11) DEFAULT NULL,
 `share_f07_15_min` decimal(6,1) DEFAULT NULL,
 `share_f07_15_max` decimal(6,1) DEFAULT NULL,
 `share_f07_15_N` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `jan15`
--
INSERT INTO `jan15` (`id`, `company`, `f01_other`, `f01a_1`, `Jahr`, `share_f07_0`, `share_f07_8`, `share_f07_15`, `share_f07_0_min`, `share_f07_0_max`, `share_f07_0_N`, `share_f07_8_min`, `share_f07_8_max`, `share_f07_8_N`, `share_f07_15_min`, `share_f07_15_max`, `share_f07_15_N`) VALUES
(26, 7, ', Standort dahinten', 'Beispiel 1', 2013, '57.5', '15.2', '19.2', '31.2', '85.9', 15, '2.3', '47.8', 15, '7.0', '30.8', 15),
(35, 11, '', 'Beispiel 2', 2013, '40.3', '45.4', '8.2', '31.2', '85.9', 15, '2.3', '47.8', 15, '7.0', '30.8', 15),
(37, 6, '', 'Beispiel 3', 2013, '47.2', '35.5', '6.1', '31.2', '85.9', 15, '2.3', '47.8', 15, '7.0', '30.8', 15),
(38, 666666, 'Gesamt', 'Gesamt', 2013, '44.0', '27.5', '16.6', '31.2', '85.9', 15, '2.3', '47.8', 15, '7.0', '30.8', 15);

And:
CREATE TABLE IF NOT EXISTS `label` (
 `id` int(11) DEFAULT NULL,
 `company` int(11) DEFAULT NULL,
 `eins` varchar(50) DEFAULT NULL,
 `drei` varchar(50) DEFAULT NULL,
 `fünf` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `label`
--
INSERT INTO `label` (`id`, `company`, `eins`, `drei`, `fünf`) VALUES
(14, 6, 'eins', 'drei', 'fünf'),
(15, 11, 'eins', 'drei', 'fünf'),
(17, 7, 'eins', 'drei', 'fünf'),
(20, 666666, 'eins', 'drei', 'fünf');

When Jaspersoft Studio created the .jasper file and I use Talend to create a pdf, it looks like this:


Text is fine, but the table does not look like it should, for example the cells aren't centered.
When I then delete the .jasper file to have Talend create it by itself, it looks like this:


Table looks like it should, Text from Mysql looks like it should, but Text from Text Field not.
I don't know what might be wrong here.
This is my Talend job:
Seventeen Stars

Re: [resolved] tJasperReportExec and Umlauts

Did you trieb to Let the component create the jasper file? please provide only the jrxml file and Run the Job again.
Seventeen Stars

Re: [resolved] tJasperReportExec and Umlauts

Sorry I didnt read your post  fully. My last answer is useless. Are the Talend Job runs  on the same Maschine like your Jasperstudio?
where Do you Run the talend job?
Did you try to run a small  test Report like my suggestion?
One Star

Re: [resolved] tJasperReportExec and Umlauts

Yes, both Jaspersoft Studio and Talend run on the same office computer.
The small test I made first was an extract from a report I made and already delivered before. My first report, though.
This was made out of a lot of graphics and tables, numbers coming from database, and text as introduction to chapters, which I wrote directely into text fields. When I realized that tJasperReportExec created pdfs do not look like Jaspersoft pdfs I made that extract with one table and a text field from my report to test.
Now I tested your .jrxml file. I added a "fünf" to the "umlauts" in your static field. Connected to my database in your text field and added a text field with text. When tJasperReportExec creates the .jasper file it looks like this:


Surprisingly text written in Static Text is fine, text coming from database is fine, text written in Text Field is not.
Not to mention that pdfs from Jaspersoft Studio are always correct. So I'm lost here. Do I miss some settings?
Seventeen Stars

Re: [resolved] tJasperReportExec and Umlauts

Ah, ok this could be caused by the read of the jrxml file with the wrong character set. I have dived in the source code of the library and see there is no file encoding setting and also not for the writing of the file. I will check if I can take care the file will always read with UTF-8.
I come back here when I can reproduce this and have a solution.
As long as we have a solution you could try bundles to add localised texts.  
Seventeen Stars

Re: [resolved] tJasperReportExec and Umlauts

To be in danger driving you creasy here is my own test and it convinced my, there is something wrong with your way to write the jrxml file:

The way the wrong encoding is showing is very typical for a reading of an text file with the wrong char set.
Could you check if the char set of the jrxml file is UTF-8. Perhaps you open it with UltraEdit with fix setup UTF-8 encoding.
Please test if it works if you add a tJava with this code:
System.setProperty("file.encoding", "UTF-8");

before the jasper comp. It changes the default encoding and this way your file should be read correctly.
Seventeen Stars

Re: [resolved] tJasperReportExec and Umlauts

I have made some slight changes to this component to be sure the JRXML file will be read in UTF-8 encoding regardless what is set as default encoding. I habe uploaded an new test release (1.16) here:
http://jan-lolling.de/talend/components/tJasperReportExec.zip
Could you give it a try?
One Star

Re: [resolved] tJasperReportExec and Umlauts

Perfect, that's the solution. Thank you very much indeed. The reports run fine and show Umlauts in all their glory.
In my "real" report only one damn Text Field refused cooperation, but with this one I started to play with the encodings, so no problem here. The rest is as it should.
So thanks again and have a nice weekend!
Seventeen Stars

Re: [resolved] tJasperReportExec and Umlauts

Great to hear. Did you tried the piece of code or the new release of the component. Actually both ways handles the same problem (the new release does not need the global setting and should be the one for further development).
One Star

Re: [resolved] tJasperReportExec and Umlauts

I tried the 1.16 Release from your link, because I missed your other post (and was wondering which piece of code you were talking about).
But I'll test the code, too, just a little bit busy at the moment.
The .jrxml files are all utf-8, I checked this when I started. All I can say is I didn't change anything in configuration, but that doesn't say I can't do anything wrong.
I'll test the code tomorrow!
Seventeen Stars

Re: [resolved] tJasperReportExec and Umlauts

I meant this piece of code in a tJava:
System.setProperty("file.encoding", "UTF-8");
But you do not have to test it. The update of the component is the better way.
I will update the release also in Talend Exchange.
Thanks a lot for your tests and your feedback!
One Star

Re: [resolved] tJasperReportExec and Umlauts

Thank you very much for your help Smiley Happy I'll set the thread as solved then. 
One Star

Re: [resolved] tJasperReportExec and Umlauts

gsczuka....can you post a screenshot of your tJasperReportExec component settings?  i'm trying to do the same thing as you, but am having a difficult time with the parameters