I have enourmous performance problems with Ireport 4.1.3 and 4.5.0. I use Jasperreports server 4.0.2 and load the reports via the repository navigator.

Java is installed in version 1.60_23, I user Win7 X64 and have quite a performant workstation with 8 GB Ram and a Core i7-CPU.

I measured the time it takes to open a quite complex report: 

4.0.1: 7 seconds

4.1.3: 96 seconds

4.5.0: I killed the process after it was loading 5 minutes...

Btw: I imported the settings from 4.0.1 to the other versions, so everything should be configured the same. Ireport compatibility is set to 4_0_1.

Someone an idea what goes wrong here?

In my report, I have it getting the date, but it also brings back the time. Is there a way to have only the date come back but without the time.

Thank you

Any ideas?

Here is the expression as it stands riight now.

It's not erroring out, it just doesn't bring back the desired value.

Thanks

(($F{PARTTRACKINGID}== $F{TRACKINGTEXTTAGID})?"getValue($F{TRACKINGTEXTINFO})":"")

I working on a summary and I want to sum total cost. For example if PO # 12234 has two items I want to sum those two items and if PO # 56788 had 3 items I want to sum those 3 together and have both POs on the same report. Right now when I run the report in the total cost column I get each individual item.

Thanks

I have a report that collects data from a sqlserver database. I can´t see the accents or another special character ( spanish language). I think that the standard encoding configuration UTF-8 could resolve it, but It shows strange characters. I also check with the ISO-8859-1 encoding with the same result.

Any ideas?.

Thank you.

Martha.

SELECT
     feed.`MMID` AS feed_MMID,
     feed.`Question` AS feed_Question,
     feed.`Answer` AS feed_Answer,
     feed.`Trigger` AS feed_Trigger,
     Demographics.`MMID` AS Demographics_MMID,
     Demographics.`First` AS Demographics_First,
     Demographics.`Last` AS Demographics_Last,
     Demographics.`Phone` AS Demographics_Phone,
     Demographics.`Email` AS Demographics_Email
FROM
     `feed` feed INNER JOIN `Demographics` Demographics ON feed.`MMID` = Demographics.`MMID`
GROUP BY
     feed_MMID

Its very simple problem, I have a report which needs to run in a user specified timezone.  Before jasperserver, I accomplished this via a mysql session variable.

set time_zone = 'timezone specified by user'  ;

which I set before running the query, and then set back to whatever it was.

Very simple.  However, with Jaspersoft I can not find a way to run "preparatory sql" before the main query runs for a report.  Setting the time_zone in the database makes solving this easy, surely there must be some way to run generic sql BEFORE the main query in a jaspersoft report, or perhaps there is some trickery with the REPORT_TIME_ZONE parameter that will cause jasperserver to set the timezone to an input paramter.

Thanks,

Trevor 

I'm new to iReport, I'm just working with it since a few days. I want to build a chart on orders by month, year. I'm working with a sample database and with this query :

SELECT COUNT(distinct Facture.idCommande) as 'nb_cde', SUM(LigneFacture.MontantHT) as 'ca_ht', SUM(LigneFacture.MontantHT)/COUNT(distinct Facture.idCommande) as 'pm_ht', YEAR(Facture.DateFacture) as 'annee', MONTH(Facture.DateFacture) as 'mois'

FROM Facture INNER JOIN LigneFacture on LigneFacture.idFacture=Facture.idFacture

group by YEAR(Facture.DateFacture), MONTH(Facture.DateFacture)

order by YEAR(Facture.DateFacture), MONTH(Facture.DateFacture)

I build a Bar 3D chart with values you can see on attachment1. 

"Show labels" is ticked in chart properties, with a black color on white background but when I preview the chart, no value is printed on each bar (see attachment 2)... How can I do that ? 

Thanks.

Is there a way to do this?

I have created a new input parameter in my report as java.util.Collection. I am using it in my SQL query as:

SELECT parameter from table

Where parameter1 IN ($P{collection_input}.toString())
 

I am getting error in query designer as 'null.toString()' does not exist. If I don't use toString() then the report just simply doesn't work at all.

I tried to search on the forum and couldn't find any help. Does anyone knows how to deal with Collection opbject as input parameter in iReport? Thanks for help in advance.