hishamkmr

i couldnt understand your question..

Hope ur issue is resolved with above comment form marianol

HI, You can creat a subreport and place some where in the main report and make it hidden with some label box or something. Pass the variable F{Project} to subreport and using this id retireve project_num, name and manager. Then return this three into three other varibale declared in main report. Display it in the title. I think this will work. Let me know. Thanks Hisham.A

Hi Please somebody help on the above topic. Regards Hisham.A

Dear Ankur Gupta, Thanks for your work around. I have tried this in some report earlier. Now it is regarding 12 months :( so it is diff task to create print when expression for each column. Any way thanks for the help

Hi, I have one query. Is it possible to move the position of column heading dynamically. eg: my report has 3 columns 'Name', 'Amount', 'Dept' according to the input sometimes the amount will not be there. So I can hide the 'Amount' column with 'Print When Expression' but is it possible to move the column 'Dept' to the position of 'Amount' at the same time? Regards Hisham.A

Hi, I gone through lot of threads in this community regarding this but couldn't get a proper solution. Sorry for reposting it. Is there any way to sort the crosstab according to the total of measure value ASC/DESC. I-report version is 4.7.0 Please help. Regards Hisham.A

Thanks

Its solved..

Hi, In my jasper report there is a group header containing 4 field Name,Cover Number, Gender and Date of Birth. While executing the report I am getting the below error. Anybody came across this, Please help me to sort the same Error filling print... Error evaluating expression : Source text : $F{NAME}$F{Cover_Number}$F{DOB}$F{Gender} Setting up the file resolver... net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{NAME}$F{Cover_Number}$F{DOB}$F{Gender} at net.sf.jasperreports.engine.fill.JREvaluator.evaluateOld(JREvaluator.java:235) at net.sf.jasperreports.engine.fill.JRCalculator.evaluateOld(JRCalculator.java:573) at net.sf.jasperreports.engine.fill.JRCalculator.estimateGroupRuptures(JRCalculator.java:209) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:290) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:148) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: groovy.lang.MissingMethodException: No signature of method: java.lang.String.call() is applicable for argument types: (java.lang.String) values: [821840016770] Possible solutions: wait(), any(), wait(long), split(java.lang.String), count(java.lang.String), find(java.lang.String) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.unwrap(ScriptBytecodeAdapter.java:54) at org.codehaus.groovy.runtime.callsite.PojoMetaClassSite.call(PojoMetaClassSite.java:46) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:124) at ChronicCompliance_1384066799566_198271.evaluateOld(calculator_ChronicCompliance_1384066799566_198271:353) at net.sf.jasperreports.engine.fill.JREvaluator.evaluateOld(JREvaluator.java:222)

Hi, I am calling jasper report from oracle application express. Till now it is working fine except during one case. If I am running a report for small data it will be exported to excel successfully but if I run the same report for huge amount of data after 20-30 minutes an excel sheet is generated as blank. The same is generated from i-report successfully. I changed the session-timeout in web.config file also but no change. Please help me!!!!!

me too get this error once..it got resolved myself by correcting the jasper server URL..i think ur URL is incorrect..please check

Hi Robert, can you copy + paste the code you tried? is it the same code?

Try this You can use a virtualizer to limit the use of memory (Tools->Options->iReport->Compilation and execution (tab) ->Execution options (tab) check "Use virtualizer". The vitualizer can be configured in the tab "Virtualizer". If the error happens at export time, the virtualizer is not useful, and you have to increase the heap size (meaning set a bigger value for the option -J-Xmx512m change 512 to 1000 or more..may be it will help.. try it..

iam guessing the problem is bcos of trying to compile the jasper file two times..replace the error line with below cod and try JasperReport jasperReport = (JasperReport)JRLoader.loadObject(new File(path2+"OnlineMainReport.jasper")); let me know the result..

Case statement is not supported in i-report You can try this column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3)) >= 0 && column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3))<=0.35 ? '0.25 Ton' : column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3)) >= 0.351 && column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3))<= 0.85 ? '0.5 Ton' : column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3)) >= 0.851 && column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3))<= 1.35 ? '1 Ton' : column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3)) >= between 1.351 && column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3)) <=2.25 ? '2.0 Tons' : column1*Column2*Column3/1000000000*2.5*to_number(substr(Column4,2,3)) > 2.25? '2.5 Tons' : "Unknown" Hope this help

just try a page break between ..may be it will help

creat a parameter in ireport with type java.sql.time in query use it by formating with to_date function eg: - date_from is the parameter with data type java.sql.time query will be select name from employee where joining_date <= to_date($P{date_from},'dd/MM/yyyy HH:MI:SS) hope this will help..let me know the result..

The below code is working for me select student_namefrom studentswhere first_name like '$P!{name}'||'%' wwhere the parameter 'name' has a default value "A". so while we running the report if we use default value it will show all the students name start with A.if we give any other value it will give the students name starting with those value..it's working fine for me. Please let me know is this u need.

can u plsgive more description of code?

can you please tell any default value is assigned to $P!{pLOGIN_LIKE} another thing came to mind is remove the single quotes for $P!{pLOGIN_LIKE}hope it works

u need to use crosstab for acheiving this..

r u trying to parse the xml inside java code with UTF-8 encoding?

can u pls more specific..can't understand the pblm..sorry may be my prblm of understanding..

I am assuming those abc and abc2 are null for other groups. for eg: I have a table TEST with columns GROUP1,SUB,DATA1,DATA2 VALUES in the table Name1, null , one, two NAME2, null, one,two NAME3,ab,one,two NAME3,ac,one,two my query for ireport will be select group1,sub,data1,data2from testgroup by group1,sub,data1,data2order by group1 Then create group band in ireport with group1place group1,data1,data2 in group headerbandand give <printWhenExpression> for data1 and data2 as show only when sub is null then place sub,data1,data2 in detail band of the reportand give <printWhenExpression> for sub,data1, and data2 as show only when sub is not null find the below xml code<?xml version="1.0" encoding="UTF-8"?><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="test2" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"><property name="ireport.zoom" value="1.0"/><property name="ireport.x" value="0"/><property name="ireport.y" value="0"/><queryString><![CDATA[select group1,sub,data1,data2from testgroup by group1,sub,data1,data2order by group1]]></queryString><field name="GROUP1" class="java.lang.String"/><field name="SUB" class="java.lang.String"/><field name="DATA1" class="java.lang.String"/><field name="DATA2" class="java.lang.String"/><group name="GROUP1"><groupExpression><![CDATA[$F{GROUP1}]]></groupExpression><groupHeader><band height="20"><textField><reportElement x="0" y="0" width="100" height="20"/><textElement/><textFieldExpression class="java.lang.String"><![CDATA[$F{GROUP1}]]></textFieldExpression></textField><textField><reportElement x="100" y="0" width="84" height="20"><printWhenExpression><![CDATA[new Boolean($F{SUB}==null)]]></printWhenExpression></reportElement><textElement/><textFieldExpression class="java.lang.String"><![CDATA[$F{DATA1}]]></textFieldExpression></textField><textField><reportElement x="184" y="0" width="100" height="20"><printWhenExpression><![CDATA[new Boolean($F{SUB}==null)]]></printWhenExpression></reportElement><textElement/><textFieldExpression class="java.lang.String"><![CDATA[$F{DATA2}]]></textFieldExpression></textField></band></groupHeader></group><background><band splitType="Stretch"/></background><title><band height="79" splitType="Stretch"/></title><detail><band height="20" splitType="Stretch"><textField><reportElement x="100" y="0" width="100" height="20"><printWhenExpression><![CDATA[new Boolean($F{SUB}!=null)]]></printWhenExpression></reportElement><textElement/><textFieldExpression class="java.lang.String"><![CDATA[$F{SUB}]]></textFieldExpression></textField><textField><reportElement x="200" y="0" width="100" height="20"><printWhenExpression><![CDATA[new Boolean($F{SUB}!=null)]]></printWhenExpression></reportElement><textElement/><textFieldExpression class="java.lang.String"><![CDATA[$F{DATA1}]]></textFieldExpression></textField><textField><reportElement x="300" y="0" width="100" height="20"><printWhenExpression><![CDATA[new Boolean($F{SUB}!=null)]]></printWhenExpression></reportElement><textElement/><textFieldExpression class="java.lang.String"><![CDATA[$F{DATA2}]]></textFieldExpression></textField></band></detail><summary><band height="29" splitType="Stretch"/></summary></jasperReport>-----------------------------------------------------Run the report you will get the output as given in ur question. also find the jrxml file attached with this. let me know whether this helped.