nairsunil

I am facing some performance issue while generating reports in Excel. I have a query which when I run it from Oracle SQL returns me 45,000 records in about a min but when I use them to generate reports in jasper it takes a long time and it also throws me java.lang.OutOfMemoryError: PermGen space Any ideas how to improve the performance of Excel reports?

Hi I amtrying to generate a simple report with 3 fields. The problem that I am facing is that if the value of the field is long then it does not wrap the data. I am using isStretchWithOverflow="true". For example if the value for Account No is XYZ-12345678912345 then it does not show the complete act no. Please help. [file name=tab.jrxml size=11344]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/tab.jrxml[/file]

Passing param = null gives you different results in oracle. select x , y , z from table where x is null gives different result than select x , y , z from table where x = null This is the problem i am facing. Any help

I am facing some issues when we pass in null as value for the parameter in the query. Query Executed by Jasper when we pass in the parameter Business Unit select * from tx_acct_details_merged where BUSINESS_UNIT = $P{param1} It executes select * from tx_acct_details_merged where BUSINESS_UNIT = null Returns me 0 records Correct Query select * from tx_acct_details_merged where business_unit is null Returns me 10 records How do I dynamically change the query to replace BUSINESS_UNIT = $P{param1} with BUSINESS_UNIT is $P{param1} in case the value for $P{param1} is null?

Getting error when we are running Jasper reports in linux. We have a reportMgmt application deployed on tomcat in linux and we are accessing this from another application deployed in Jboss in linux. This works fine when both the applications are deployed in JBOSS windows. Any ideas? First it complained about some issues related to permission where it was trying to create the temp file i think , and after we gave write permission to the directory that issue was solved and now getting a new error. net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: /dnbusr1/dnbi/logs/Report_1180739398441_688453.java:4: package net.sf.jasperreports.engine does not exist import net.sf.jasperreports.engine.*; ^ /dnbusr1/dnbi/logs/Report_1180739398441_688453.java:5: package net.sf.jasperreports.engine.fill does not exist import net.sf.jasperreports.engine.fill.*; ^ /dnbusr1/dnbi/logs/Report_1180739398441_688453.java:18: cannot find symbol symbol: class JREvaluator public class Report_1180739398441_688453 extends JREvaluator ^ /dnbusr1/dnbi/logs/Report_1180739398441_688453.java:25: cannot find symbol symbol : class JRFillParameter location: class Report_1180739398441_688453 private JRFillParameter parameter_REPORT_RESOURCE_BUNDLE = null;

I am facing the same issue , I need to pass in the value from a field to the hyperlink that I create on second field. Example My report looks like 10 Dallas 20 California Now when I click on 10 I need my hyperlink to look like http://localhost:8080/reportMgmt?repid=1?param1=10 Similary when I click on 20 http://localhost:8080/reportMgmt?repid=1?param1=20 Please help

I have my field that needs hyperlink as <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="ReportExecution" hyperlinkTarget="Blank" > <reportElement x="150" y="0" width="150" height="20" key="textField"/> <box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="1Point" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textElement textAlignment="Justified"> <font reportFont="Arial_Normal" fontName="Verdana"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{FIELD0}]]></textFieldExpression> <hyperlinkReferenceExpression><![CDATA["http://localhost:8080/reportMgmt/report?reportId=E987272733424997BD18A67FCD6EFE60&reporttype=htm"]]></hyperlinkReferenceExpression> <hyperlinkParameter name="FIELD0"> <hyperlinkParameterExpression>$F{FIELD0}</hyperlinkParameterExpression> </hyperlinkParameter> </textField> How do I access my parameter FIELD0 in my servlet? Also is there anything else we need to do so that this custom parameter works? i read somewhere we need to export something to have this work. Please help

What property can I set in the Jasper XML so that when we compile and run the report the data gets wrapped rather than get cut. I have set the width for column A as say 250 and when the reports gets generated say the data is longer than that can fit in the width specified of 250. What property can i specify in the XML so that the data gets wrapped rather than getting cut. - Any help would be appreciated

We are using oracle 10g and I am facing some issues when we specify TABLE_NAME.COLUMN_NAME in the field element. Example: Works <field class="java.lang.String" name="ACCT_NO"/> Does not work <field class="java.lang.String" name="TX_ACCOUNT.ACCT_NO"/> Any ideas how this can be solved? Also in case we have ACCT_NO from 2 tables then we cannot specify <field class="java.lang.String" name="ACCT_NO"/> <field class="java.lang.String" name="ACCT_NO"/> this is also throwing error. Any solution to either of the issue ?

We have a requirement to create a drill down report from a summary report. Does Jasper supprt this? Example: We have a summary report like East 10 West 20 North 50 South 15 Now clicking on 10 ,20 ,50 and 15 we need to launch another report which represents each of the value. Example clicking on 10 will take you to a report which shows all the accounts , name , address for all the 10 accounts of East. Any suggestions help will be appreciated.