[hello i need help with this ireport code]

i couldnt understand your question..

[Multiple query's mongodb - Jasper reports]

Hope ur issue is resolved with above comment form marianol

[Multiple query's mongodb - Jasper reports]

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

[Sorting Crosstab according to total of measure value]

Hi

 

Please somebody help on the above topic.

 

Regards

Hisham.A

[Dynamically move the column heading]

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

[Dynamically move the column heading]

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

[Sorting Crosstab according to total of measure value]

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

[Error filling print]

Thanks

[Error filling print]

Its solved..

[Error filling print]

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)

[Big data exporting is coming blank in excel]

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!!!!!

[Unable to connect Jasperserver repository in iReport]

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

[Case Statement in Jaspersoft Domain Calculated field?]

Hi Robert,

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

[[SOLVED][JasperReports Server] Handler processing failed; nested exception is java.lang.OutOfMemoryError: Java heap space]

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..

 

[how i solve this error]

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 in Jaspersoft Domain Calculated field?]

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

[Exporting Report to Excel - Multiple pages]

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

[iReport Timestamp question]

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..

 

 

 

[Optional Prompt - Condition IN or LIKE]

The below code is working for me

select student_name

from students

where 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.

[Optional Prompt - Condition IN or LIKE]

can u plsgive more description of code?

[Optional Prompt - Condition IN or LIKE]

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

 

[Displaying Grouped Column In Jasper Report]

u need to use crosstab for acheiving this..

[how i solve this error]

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

[Problem with Groups an Percentual]

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

[Grouping the report column as shown in attached image]

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,data2

from test

group by group1,sub,data1,data2

order by group1

 

Then create group band in ireport with group1

place group1,data1,data2 in group headerband

and give <printWhenExpression> for data1 and data2 as show only when sub is null

 

then place sub,data1,data2 in detail band of the report

and 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,data2

from test

group by group1,sub,data1,data2

order 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.