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?

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

In JasperServer (4.1), how can I transmit the user id as parameter in a report.

I need it to apply grants to the returned data.

Thanks.

Following Work Around worked for me :

Create the Project as Java Project and added all my resource bundle properties to class path under Java project. It worked.  Report Template able to retrieve the resource bundle and exeute the report successfully.

But In real scenarios, we will be creating reports under Jasper Report Project only not as Java Project.

Please provide any pointers on how to add Resource Bundles in Japser Studio

- Srinivas

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

"The server has encountered an error. Please excuse the inconvenience. An error has occurred. Please contact your system administrator. (5321)"

I also get this error if I try to create a new schedule to multiple email recipients.  If I leave only one email address in the To field, it will save the schedule just fine.  I am separating the email addresses with commas just as I always have.  Here is what jasperserver.log shows pertaining to this:

"Invalid input: context=toAddresses-ViewRepository_Schedule_OutputSettings_context, type(Email)=^[p{L}p{M}p{N}._%'-]+@[p{L}p{M}p{N}.-]+.[a-zA-Z]{2,4}$, input=testa@gmail.com,testb@gmail.com
org.owasp.esapi.errors.ValidationException: toAddresses-ViewRepository_Schedule_OutputSettings_context: Invalid input. Please conform to regex ^[p{L}p{M}p{N}._%'-]+@[p{L}p{M}p{N}.-]+.[a-zA-Z]{2,4}$ with a maximum length of 200
        at org.owasp.esapi.reference.validation.StringValidationRule.checkWhitelist(StringValidationRule.java:144)"
 

Is this a bug or did the address delimiter change?  I've been wrestling with this upgrade all afternoon (fixing other report compatability issues) and this is the last one to address so I can move us to the new version.  Please help!

Thanks!

Chadd

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.