[How to Stop Repeating Column Headers]

Hi,

set the elements of the column to print once.

[How to create Excel File direct to disk]

Hi,

This is easy...set a path for the file with a filename and export it to that file using the option OUTPUT_FILE_NAME in the exporter parameter.

Your file will be exported to the location specified in the file.(and dont forget to remove response code)

[Securing a PDF]

Hi,

Are you using Jasper Reports to export PDF files

[Hide field values in detail band? Show them once?]

Hi,

There is an option you need to set which is "printRepeatedValues" set this to false and you will get the report as you desired(you have to set this in the textfield properties)If you are using any of the report designer it is easy.

[poblem in jasper when shown as html file]

use this parameter to remove unncessary empty spaces between rows exporter.setParameter(JRHtmlExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS ,Boolean.TRUE);

[Reports in XLS (Excel) are not as cool as PDF ones]

This is purely related to the alignment problems in your design make sure you have read the tips and tricks of jasper assistant which is available on their website...go and check it out.

[Printing bold with special characters]

refer to the styled text example

[Empty report - recompile needed to fill report]

Compile the reports externally using Jasper Assistant or iReport and use the .japer files in your project...and remove the compilation codes when you request for a report.

[Jasper Report perfromance]

Currently how are you exporting it to PDF

[help with jasperreport jsp empty pdf]

Hi,

These are the corrections you need to know

 

Number 1: you are filling the report with the report design and parameters, you are missing the datasource which contains the data.

 

Number 2: If you use an Empty Data Source your report will be filled with no data but the static fields will be exported to the file.

 

Use a compiled report file ie use a .jasper file and try to avoid compiling reports on the fly, this will reduce the export time of the report.

[I need a solution]

Thanks for the reply i will try to do the same way as you said

[I need a solution]

I am using Jasper reports to generate reports for my web-based application, the user requirement is to download the report in different formats,

How to give the user an option to select which format does he wants to download,

The solution i am looking for has to be generic to all the reports like the jasper viewer which has an option to export the report in any format.

[How Report of this Type is Designed]

Use the same query(group by emp id)as you told and divide that in your report...like this

 

1. Divide the report into main and subreport(ie use 2 reports)

2. Display the employee info in the main report(make sure that you do not print repeated values)

3. Display the projects by calling the subreport from the main report (using the subreport parameter)

 

This will give you the report what you are trying to get.

 

Regards,

Arun.v

[Problem with Internet Explorer 7]

Hi,

I am using Jasper reports 1.2.4 and exporting the reports to HTML format.

Recently I found out that the reports which are printed from IE7 does not have the correct page break than the reports printed from older version of IE.....

 

Why is it so????

 

Is this a bug in Jasper reports or the IE7

[Change Text direction]

I too am trying the same thing but HTML is not supporting I dont know why

 

Can any one tell how to change the direction of the static text in HTML

[Text export]

problem solved...I experimented with the page widht and height to get the the desired page size and the elements are coming in a single line

[Text export]

and also I am exporting my fields in a single line but I am getting in two different line why is it so??

[Text export]

Hi,

I am trying to export my report to plain text format using the JRTextExporter...one thing I did not understand is that the page width of the text does not change to landscape even I specified a value more than the portrait size in the PAGE_WIDTH parameter of the exporter.

 

why is this or am I going wrong somewhere....

 

this is my export logic:

 

String fileName = new String("FEDFileFormat" +

lDateTimeFormatter.format(new Date()) + ".txt");

JRTextExporter jrtxt = new JRTextExporter();

File destFile = new File(fileName);

 

jrtxt.setParameter(JRExporterParameter.JASPER_PRINT, jrPrint);

jrtxt.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());

jrtxt.setParameter(JRTextExporterParameter.CHARACTER_WIDTH, new Integer(10));

jrtxt.setParameter(JRTextExporterParameter.CHARACTER_HEIGHT, new Integer(10));

jrtxt.setParameter(JRTextExporterParameter.PAGE_WIDTH, new Integer(845));

jrtxt.exportReport();

[First page is empty]

this is the jrxml of my report

 

***********************************************************************MainReport*********************************************************************************

<?xml version="1.0" encoding="UTF-8"?>

<!-- Created using JasperAssistant (http://www.jasperassistant.com) -->

<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

 

<jasperReport name="XFCDealPartyObligationsReportHelper" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="822" leftMargin="20" rightMargin="0" topMargin="20" bottomMargin="28">

<property name="com.jasperassistant.designer.GridWidth" value="5"/>

<property name="com.jasperassistant.designer.GridHeight" value="5"/>

<property name="com.jasperassistant.designer.Rulers" value="true"/>

<property name="com.jasperassistant.designer.DataSource" value="XFCDealGenericReportHelperDS"/>

<property name="com.jasperassistant.designer.SnapToGrid" value="true"/>

<property name="com.jasperassistant.designer.Margins" value="true"/>

<property name="com.jasperassistant.designer.Units" value="Millimeters"/>

<property name="com.jasperassistant.designer.Grid" value="true"/>

<property name="com.jasperassistant.designer.SnapToGuides" value="true"/>

<reportFont name="XFCDealPartyObligationsReportHelper" isDefault="true" fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

<parameter name="XFCDealPartyObligationsReportDetailDataSource" class="net.sf.jasperreports.engine.data.JRBeanCollectionDataSource" isForPrompting="false"/>

<parameter name="XFCDealPartyObligationsReportDetail" class="net.sf.jasperreports.engine.JasperReport" isForPrompting="false"/>

<field name="fromDate" class="java.sql.Timestamp"/>

<field name="fromDateDisplay" class="java.lang.String"/>

<field name="paymentMode" class="java.lang.String"/>

<field name="reportAgentAddressCity" class="java.lang.String"/>

<field name="reportAgentAddressCityAndPhone" class="java.lang.String"/>

<field name="reportAgentCode" class="java.lang.String"/>

<field name="reportAgentCodeAndName" class="java.lang.String"/>

<field name="reportAgentName" class="java.lang.String"/>

<field name="reportAgentPhone" class="java.lang.String"/>

<field name="reportDate" class="java.sql.Timestamp"/>

<field name="reportDateDisplay" class="java.lang.String"/>

<field name="reportHeader" class="java.lang.String"/>

<field name="toDate" class="java.sql.Timestamp"/>

<field name="toDateDisplay" class="java.lang.String"/>

<pageHeader>

<band height="47" isSplitAllowed="false">

<textField>

<reportElement positionType="Float" x="0" y="0" width="231" height="11"/>

<textElement/>

<textFieldExpression class="java.lang.String"><![CDATA[$F{reportAgentCodeAndName}]]></textFieldExpression>

</textField>

<textField>

<reportElement positionType="Float" x="0" y="16" width="177" height="11"/>

<textElement/>

<textFieldExpression class="java.lang.String"><![CDATA[$F{reportAgentAddressCityAndPhone}]]></textFieldExpression>

</textField>

<staticText>

<reportElement positionType="Float" x="674" y="15" width="27" height="11"/>

<textElement textAlignment="Right"/>

<text><![CDATA[Page:]]></text>

</staticText>

<textField evaluationTime="Page" pattern="0" isBlankWhenNull="true">

<reportElement positionType="Float" x="702" y="15" width="14" height="11"/>

<textElement/>

<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>

</textField>

<textField>

<reportElement positionType="Float" x="660" y="0" width="84" height="11"/>

<textElement/>

<textFieldExpression class="java.lang.String"><![CDATA[$F{reportDateDisplay}]]></textFieldExpression>

</textField>

<textField>

<reportElement positionType="Float" x="359" y="18" width="57" height="11"/>

<textElement textAlignment="Right">

<font size="8" isBold="true"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{fromDateDisplay}]]></textFieldExpression>

</textField>

<textField>

<reportElement positionType="Float" x="429" y="18" width="57" height="11"/>

<textElement>

<font size="8" isBold="true"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{toDateDisplay}]]></textFieldExpression>

</textField>

<staticText>

<reportElement positionType="Float" x="417" y="18" width="11" height="11"/>

<textElement>

<font size="8" isBold="true"/>

</textElement>

<text><![CDATA[To]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="717" y="15" width="11" height="11"/>

<textElement/>

<text><![CDATA[of]]></text>

</staticText>

<textField evaluationTime="Report">

<reportElement positionType="Float" x="729" y="15" width="14" height="11"/>

<textElement/>

<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>

</textField>

<staticText>

<reportElement positionType="Float" x="616" y="0" width="44" height="11"/>

<textElement textAlignment="Right">

<font size="8"/>

</textElement>

<text><![CDATA[ReportDate:]]></text>

</staticText>

<textField>

<reportElement positionType="Float" x="330" y="0" width="187" height="14"/>

<textElement textAlignment="Center">

<font size="12" isBold="true"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{reportHeader}]]></textFieldExpression>

</textField>

<line>

<reportElement positionType="Float" x="2" y="40" width="744" height="1"/>

<graphicElement/>

</line>

</band>

</pageHeader>

<detail>

<band height="20">

<subreport>

<reportElement positionType="Float" x="0" y="0" width="744" height="20"/>

<parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression>

<dataSourceExpression><![CDATA[(net.sf.jasperreports.engine.data.JRBeanCollectionDataSource)$P{XFCDealPartyObligationsReportDetailDataSource}]]></dataSourceExpression>

<subreportExpression class="net.sf.jasperreports.engine.JasperReport"><![CDATA[$P{XFCDealPartyObligationsReportDetail}]]></subreportExpression>

</subreport>

</band>

</detail>

</jasperReport>

 

 

***********************************************************************SubReport**********************************************************************************

 

<?xml version="1.0" encoding="UTF-8"?>

<!-- Created using JasperAssistant (http://www.jasperassistant.com) -->

<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

 

<jasperReport name="XFCDealPartyObligationsReportDetail" language="java" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="842" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">

<property name="com.jasperassistant.designer.GridWidth" value="5"/>

<property name="com.jasperassistant.designer.GridHeight" value="5"/>

<property name="com.jasperassistant.designer.Rulers" value="true"/>

<property name="com.jasperassistant.designer.DataSource" value="XFCDealPartyObligationsRptDS"/>

<property name="com.jasperassistant.designer.SnapToGrid" value="true"/>

<property name="com.jasperassistant.designer.Margins" value="true"/>

<property name="com.jasperassistant.designer.Units" value="Millimeters"/>

<property name="com.jasperassistant.designer.Grid" value="true"/>

<property name="com.jasperassistant.designer.SnapToGuides" value="true"/>

<reportFont name="XFCDealPartyObligationsReportDetail" isDefault="true" fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

<field name="agentCode" class="java.lang.String">

</field>

<field name="agentName" class="java.lang.String">

</field>

<field name="amountInFC" class="java.lang.Double">

</field>

<field name="amountInFCDelivered" class="java.lang.Double">

</field>

<field name="amountInFCDeliveredDisplay" class="java.lang.String">

</field>

<field name="amountInFCDisplay" class="java.lang.String">

</field>

<field name="dealCustomerCode" class="java.lang.String">

</field>

<field name="dealCustomerName" class="java.lang.String">

</field>

<field name="dealDate" class="java.sql.Timestamp">

</field>

<field name="dealDateDisplay" class="java.lang.String">

</field>

<field name="dealDateLocal" class="java.sql.Timestamp">

</field>

<field name="dealDateLocalDisplay" class="java.lang.String">

</field>

<field name="dealGroupNo" class="java.lang.String">

</field>

<field name="dealGroupTxnStatus" class="java.lang.Integer">

</field>

<field name="dealMethod" class="java.lang.String">

</field>

<field name="dealMethodName" class="java.lang.String">

</field>

<field name="dealNo" class="java.lang.String">

</field>

<field name="dealPartyCode" class="java.lang.String">

</field>

<field name="dealReferenceNo" class="java.lang.String">

</field>

<field name="dealReferenceNoParty" class="java.lang.String">

</field>

<field name="dealRemarks" class="java.lang.String">

</field>

<field name="dealType" class="java.lang.String">

</field>

<field name="dealTypeName" class="java.lang.String">

</field>

<field name="dealerCode" class="java.lang.String">

</field>

<field name="fccyCode" class="java.lang.String">

</field>

<field name="fccyName" class="java.lang.String">

</field>

<field name="fccyRounding" class="java.lang.Integer">

</field>

<field name="fccyRoundingDisplay" class="java.lang.String">

</field>

<field name="fccyUnit" class="java.lang.String">

</field>

<field name="partyDealerCode" class="java.lang.String">

</field>

<field name="partyDeliveryDate" class="java.sql.Timestamp">

</field>

<field name="partyDeliveryDateDisplay" class="java.lang.String">

</field>

<field name="partyDeliveryMethod" class="java.lang.String">

</field>

<field name="partyDeliveryMethodName" class="java.lang.String">

</field>

<field name="partyObligationTxnStatus" class="java.lang.Integer">

</field>

<field name="serviceProviderCode" class="java.lang.String">

</field>

<field name="sessionKey" class="java.lang.String">

</field>

<field name="valueDate" class="java.sql.Timestamp">

</field>

<field name="valueDateDisplay" class="java.lang.String">

</field>

<group name="DateGroup" isReprintHeaderOnEachPage="true">

<groupExpression><![CDATA[$F{dealDateDisplay}]]></groupExpression>

<groupHeader>

<band height="17" isSplitAllowed="false">

<staticText>

<reportElement positionType="Float" x="0" y="0" width="29" height="11"/>

<textElement>

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<text><![CDATA[Date : ]]></text>

</staticText>

<textField>

<reportElement positionType="Float" x="30" y="0" width="193" height="16"/>

<textElement>

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{dealDateDisplay}]]></textFieldExpression>

</textField>

</band>

</groupHeader>

</group>

<group name="AgentGroup">

<groupExpression><![CDATA[$F{agentCode}]]></groupExpression>

<groupHeader>

<band height="19">

<textField>

<reportElement positionType="Float" x="30" y="0" width="193" height="16"/>

<textElement>

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{agentName}]]></textFieldExpression>

</textField>

<staticText>

<reportElement positionType="Float" x="0" y="0" width="29" height="11"/>

<textElement>

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<text><![CDATA[Agent : ]]></text>

</staticText>

</band>

</groupHeader>

</group>

<group name="PartyGroup">

<groupExpression><![CDATA[$F{dealCustomerCode}]]></groupExpression>

<groupHeader>

<band height="16">

<textField>

<reportElement positionType="Float" x="30" y="0" width="193" height="16"/>

<textElement>

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{dealCustomerCode} + " - " + $F{dealCustomerName}]]></textFieldExpression>

</textField>

<staticText>

<reportElement positionType="Float" x="0" y="0" width="29" height="11"/>

<textElement>

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<text><![CDATA[Party: ]]></text>

</staticText>

</band>

</groupHeader>

</group>

<group name="FCcyGroup">

<groupExpression><![CDATA[$F{fccyCode}]]></groupExpression>

<groupHeader>

<band height="17">

<staticText>

<reportElement positionType="Float" x="0" y="0" width="29" height="11"/>

<textElement>

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<text><![CDATA[FC: ]]></text>

</staticText>

<textField>

<reportElement positionType="Float" x="30" y="0" width="193" height="16"/>

<textElement>

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{fccyName}]]></textFieldExpression>

</textField>

</band>

</groupHeader>

</group>

<group name="DealGroup">

<groupExpression><![CDATA[$F{dealGroupNo}]]></groupExpression>

</group>

<columnHeader>

<band height="44">

<staticText>

<reportElement positionType="Float" x="0" y="5" width="62" height="11"/>

<textElement>

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<text><![CDATA[DealGroup]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="242" y="5" width="43" height="11"/>

<textElement>

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<text><![CDATA[DealType]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="73" y="5" width="37" height="11"/>

<textElement>

<font size="8" isBold="true"/>

</textElement>

<text><![CDATA[DealNo]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="592" y="18" width="46" height="11"/>

<textElement textAlignment="Center">

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<text><![CDATA[Method]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="337" y="5" width="46" height="11"/>

<textElement>

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<text><![CDATA[ValueDate]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="290" y="5" width="47" height="11"/>

<textElement>

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<text><![CDATA[DealMethod]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="559" y="5" width="72" height="11"/>

<textElement textAlignment="Center">

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<text><![CDATA[Delivery]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="546" y="18" width="46" height="11"/>

<textElement textAlignment="Center">

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<text><![CDATA[Date]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" x="388" y="5" width="73" height="11"/>

<textElement textAlignment="Right">

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<text><![CDATA[DeliveryAmount]]></text>

</staticText>

<line>

<reportElement positionType="Float" x="2" y="40" width="744" height="1"/>

<graphicElement/>

</line>

<staticText>

<reportElement positionType="Float" x="465" y="5" width="73" height="11"/>

<textElement>

<font fontName="Arial" size="8" isBold="true"/>

</textElement>

<text><![CDATA[Amount Delivered]]></text>

</staticText>

</band>

</columnHeader>

<detail>

<band height="11">

<textField>

<reportElement positionType="Float" x="0" y="0" width="73" height="11"/>

<textElement>

<font fontName="Arial" size="8"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{dealGroupNo}]]></textFieldExpression>

</textField>

<textField>

<reportElement positionType="Float" x="248" y="0" width="43" height="11"/>

<textElement>

<font fontName="Arial" size="8"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{dealTypeName}]]></textFieldExpression>

</textField>

<textField pattern="#,##0.00#">

<reportElement positionType="Float" x="291" y="0" width="46" height="11"/>

<textElement>

<font fontName="Arial" size="8"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{dealMethodName}]]></textFieldExpression>

</textField>

<textField>

<reportElement positionType="Float" x="337" y="0" width="43" height="11"/>

<textElement>

<font fontName="Arial" size="8"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{valueDateDisplay}]]></textFieldExpression>

</textField>

<textField>

<reportElement positionType="Float" x="75" y="0" width="73" height="11"/>

<textElement/>

<textFieldExpression class="java.lang.String"><![CDATA[$F{dealNo}]]></textFieldExpression>

</textField>

<textField>

<reportElement positionType="Float" x="549" y="0" width="43" height="11"/>

<textElement textAlignment="Right">

<font fontName="Arial" size="8"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{partyDeliveryDateDisplay}]]></textFieldExpression>

</textField>

<textField>

<reportElement positionType="Float" x="592" y="0" width="58" height="11"/>

<textElement>

<font fontName="Arial" size="8"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{partyDeliveryMethodName}]]></textFieldExpression>

</textField>

<textField>

<reportElement positionType="Float" x="394" y="0" width="53" height="11"/>

<textElement textAlignment="Right">

<font fontName="Arial" size="8"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{amountInFCDisplay}]]></textFieldExpression>

</textField>

<textField>

<reportElement positionType="Float" x="465" y="0" width="53" height="11"/>

<textElement textAlignment="Right">

<font fontName="Arial" size="8"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{amountInFCDeliveredDisplay}]]></textFieldExpression>

</textField>

</band>

</detail>

</jasperReport>

[First page is empty]

Hi,

I am using Jasper Reports 1.2.4 for generating reports, The report contains a main report and a subreport...while exporting to HTML and PDF the first page gets empty and the data starts printing on the second page...we have almost 22reports in our project this is the only report which has this type of output...the design layouts are same for all our reports...

 

I am not getting is this the error or because of our design or a bug(may be)...

 

If anyone founded the solution can you please share it with us.

 

Regards,

Arun

[multiple subreport]

thanks for your fast reply I will try it and let you know if this works or not

[Report Download]

I am using Jasper reports and exporting reports to HTML for viewing and printing the reports, now I need to export the report in order to get report in other formats like pdf,rtf,xls etc., I refered the webapps sample which uses servelet to export the report to a file,but is there any other way to export the file to the client side...

 

regards,

Arun

[Report Download]

I am using Jasper reports and exporting reports to HTML for viewing and printing the reports, now I need to export the report in order to get report in other formats like pdf,rtf,xls etc., I refered the webapps sample which uses servelet to export the report to a file,but is there any other way to export the file to the client side...

 

regards,

Arun

[multiple subreport]

hi,

I am using Jasper reports to develop a report which has 2 subreports, I want the subreports to oscillate that is:-

page 1

Header

sub1:

sub2:

------

sub1:

sub2:

page2

sub1:

sub2:

------

sub1:

sub2:

 

how to get this type of result

can anyone help me

 

regards,

Arun

[View & print report at client site in web app]

me too facing the problem of displaying the report and saving it at the client side...tried the Jasperviewer but it is opening at the server side and not the client side...

 

any body knows the solution to this please be kind and respond ASAP we are desperately seeking for any result