inditrozen

Hi All, I have a strange issue here with Excel report. Excel report doesnot show the cell formatting sometimes. For e.g. date field is shown sometimes with the correct pattern dd/MM/yyyy but sometimes it is shown like "39157" When this happens, all cells with decimal formatting, bold column headers, borders everything is displayed by ignoring their pattern, alignment and style. JRXML field example is here. <textField isStretchWithOverflow="true" pattern="dd.MM.yyyy" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="170" y="0" width="61" height="24" key="textField-10" stretchType="RelativeToTallestObject"/> <box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="Thin" bottomBorderColor="#000000" bottomPadding="2"/> <textElement textAlignment="Right"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[$F{APPL_DATE}]]></textFieldExpression> </textField> It can be everytime reproducible, After trying to open the report second or third time it started appearing. If use of Pattern is not recommended and I should always use Strings for outputting Date and Double. Has somebody similar problem and know the solution? Thanks and Regards

Hi All, I have a strange issue here with Excel report. Excel report doesnot show the cell formatting sometimes. For e.g. date field is shown sometimes with the correct pattern dd/MM/yyyy but sometimes it is shown like "39157" When this happens, all cells with decimal formatting, bold column headers, borders everything is displayed by ignoring their pattern, alignment and style. JRXML field example is here. <textField isStretchWithOverflow="true" pattern="dd.MM.yyyy" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="170" y="0" width="61" height="24" key="textField-10" stretchType="RelativeToTallestObject"/> <box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="4" bottomBorder="Thin" bottomBorderColor="#000000" bottomPadding="2"/> <textElement textAlignment="Right"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[$F{APPL_DATE}]]></textFieldExpression> </textField> It can be everytime reproducible, After trying to open the report second or third time it started appearing. If use of Pattern is not recommended and I should always use Strings for outputting Date and Double. Has somebody similar problem and know the solution? Thanks and Regards

Solution :- if(exporterType.equals(ExporterType.PDF)) { Map fontMap = new HashMap(); fontMap.put(new FontKey("Arial", true, false), new PdfFont("Helvetica-Bold", "Cp1252", false)); fontMap.put(new FontKey("Arial", false, true), new PdfFont("Helvetica-Oblique", "Cp1252", false)); fontMap.put(new FontKey("Arial", true, true), new PdfFont("Helvetica-BoldOblique", "Cp1252", false)); addParameter(JRExporterParameter.FONT_MAP, fontMap); } http://www.rodiq.ro/?p=53

Hi All, I have a requirement to make a few words BOLD from the text element. I have set the flag isStyledText = true and covered that word with <b>. But it does not show me the effect. Any clue? TIA and Regards, Here is the snippet from jrxml file. <staticText> <reportElement x="172" y="15" width="137" height="17" key="staticText-20"> <printWhenExpression><![CDATA[$P{kunden}]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Bottom" isStyledText="true"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[bla bla <b>MAKE ME BOLD</b> bla bla]]></text> </staticText> Post edited by: inditrozen, at: 2008/02/07 08:32

thx it helped

Hi All, I have a question regarding the subreports. Requirement is to have 5 subreports one below another. If each subreport contains only one row then it shows correctly but for more than one rows in each report (area for one report increases)they started overlapping each other. As there are more rows in the first subreport second subreport should start once first is finished but it does start at the same pixel positions as it started with single row. Any idea how can I ask the subreport to start when last subreport is finshed showing its rows. Thanks in advance

thx.

Hi All, Requirement is to display text having lenth around 40 charecters as one column (field )value of a table. This is the first column of my table which is having 10 columns. Field value inside the map which comes from java Report object contains complete text but pdf export shows only first few charecters of the field. That means rest of the text is getting cut may be due to the space. How can I enable rreport to show the complete text, may be by showing it on multiple rows by keeping the same column size Can somebody help. Best Regards

Hi All, I recently started developing the reports using Jasper and experiencing a problem while showing 0000 String in excel export. Requirement is some id should be shown in the report in four digits like 0000, 0001 and so on. I am passing this Field as a String in a map. It is printed correctly in pdf "0000" but same report in Excel shows it "0". Can somebody help Regards,