[Summation Problem on Group]

Sorry for bothering: I found the solution:

To use a variable "sum" that is on my group "A" but that increments on my group "circuit".

Thank you anyway.

[Summation Problem on Group]

Hello everybody,

 

I have quite a problem:

 

This is my data:

circuit A:856 1010 7665

circuit B:1100 1191 3284

circuit C:958 1154 4011

-----------------------------------

Total: 526656 597841 287450415

 

As you can see my sums aren't working. I know why but I don't know how to do it.

 

The first three lines aren't some variables but are each a different field: $F{COUNT(DISTINCTGICR.OBJECTID)},

$F{COUNT(DISTINCTGICPT.SID_PT)} and $F{COUNT(DISTINCTGICPRO.IID_PRO)}.

The reason I didn't make variables is simple, in my query I have X lines of these results because for each circuit that I have, I have X troncons (that i need for something else).

And my totals are variables where I put the same fields (see above) in sums.

Do anybody have an idea of a resolution to my problem?

Thank you very much.

[cannot resolve symbol class MathContext]

I resolve my problem.

I'm not using the same JDK, (1.4.2 instead of 1.5) so I'm not allowed to use MathContext, I have to use the ROUND_.... of BigDecimal and also the divide method is different between the two JDK versions.

Sorry for bothering...

[cannot resolve symbol class MathContext]

hello everybody,

 

I'm using the method divide in my report.

When i compile it in iReport there is not problem but when I try to generate my report in my java code I have the following error:

cannot resolve symbol

symbol : class MathContext

..........

cannot resolve symbol

symbol : method divide (java.math.BigDecimal)

location: class java.math.BigDecimal

 

Does this mean I miss a jar or something?

 

Thank you.

[could not load object from loaction .jasper]

I found the solution!!!!

 

I add a parameter:

parameters.put("SUBREPORT_DIR", rep.getAbsolutePath() +"\rapport\");

to specify the good path.

 

I hope that will help someone...:laugh:

[could not load object from loaction .jasper]

Hello,

 

I have a report (points.jrxml) that contains a subreport(activite.jasper)

When I do it in my iReport, that's working fine. But I do it in my web application, I have the following error:

"could not load object from location activite.jasper".

And I have the two documents (jrxml and jasper) in the same directory.

Thank you for your help.

[parameters.put long]

hello everybody,

 

until yesterday I always got String variables to pass to my report.

Today I have to pass a long (that I get from getTime() of Date).

As it's not possible to pass a long in parameters.put() I converted my variable in String but then my request doesn't work anymore in my report.

Do you have a solution to my problem?

Please...

Sorry if it seems a simple problem for you. ;-)

Thank you.

[Problem with parameter from subreport]

I still haven't found the solution.

Ideas?

 

Thx.

[Need help in Jasper Reports]

What are you using for display: PDF, XLS, CSV, RTF?

And are you using the viewer of iReport to check the results?

[Problem with parameter from subreport]

I tried but i get "null" as result.

 

Do you anybody have an idea?

 

Thank you for your help.

[Problem with parameter from subreport]

I forgot to tell that I'm forced to use a variable because I have to use it in a group after..:pinch:

[Problem with parameter from subreport]

Hello i'm using a subreport in my main report and I get back a sum from this subreport. It is called Somme_Surface_Parcours_2. I have to add this variable to another variable: Somme_Surface_Parcours_1. I need to put this addition in another variable: Somme_Surface_Parcours in which i put this : "( ($V{Somme_Surface_Parcours_2}==null) ? $V{Somme_Surface_Parcours_1} : $V{Somme_Surface_Parcours_1}.add($V{Somme_Surface_Parcours_2}) )"

 

If I try to display this variable, i only get the Somme_Surface_Parcours_1 but if I display directly in a field my expression, it works just fine.

So I really don't understand why something that is working in a field doesn't work in a variable.

Please, help me, I going crazy!!!:woohoo:

[two datasources in one report]

Does this mean that in my java file i have to configure 2 connexions for the report and the subreport?

Or maybe that's not in the java that you define that.

[two datasources in one report]

Is it possible to have two different datasources in one report?

I have to send requests to two different datasources: one is Oracle, the other is an XML file. Is that possible? Because only one datasource can be active in iReport so I'm not sure it is possible.

Thanks.

[problem reading xml]

I didn't manage to get what I want with my xml file so does anyone knows another way to read an xml file and it is possible to create like 'sql requests' for an xml file?

Thanks

['null' cell in excel file!]

Give us more detail. The null cells correspond to what?

[Print XLS problem (pageFooter)]

Problem solved!!!!!!!!!:P

I way to solve this problem (because there might be another way...) is to change the properties of the report in the size of the page you put 20,496 cm for the hight instead of 20,990.

This is very weird, i don't know if it's a bug or not but it's really disturbing! :blink:

Thanks for your help anyway.

[Print XLS problem (pageFooter)]

size=317]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/pagefooter.GIF

[Print XLS problem (pageFooter)]

Here is the result:

Post edited by: llaconde, at: 2008/02/04 16:14

[Print XLS problem (pageFooter)]

Yes, I tried this but nothing change!!

[Print XLS problem (pageFooter)]

Does nobody had this problem?

thanks.

[problem reading xml]

I saw someone else got the same problem as me.

Does anyone can help us?

 

I tries something else:

path=/DOMAINES/DOMAINE[@nom=ACTION]

 

key variable=VALEUR/@key

action variable=*

 

This works but it only display the first one. What do I have to do to display all my "VALEUR"?

Thanks

[problem reading xml]

Hello everybody,

I need help to read value in xml file. My file is like this:

<DOMAINE keyType="integer" nom="ACTION">

<VALEUR key="31">ABC</VALEUR>

<VALEUR key="32">DEF</VALEUR>

</DOMAINE>

I managed to do the connection. I defined the path correctly: /DOMAINES/DOMAINE[@nom=ACTION]/VALEUR

I manage to read the key using a field (description is @key) and I would like to read the 'ABC' and 'DEF' but when i put a field with description valeur, that's not working.

Please help...

 

Thank you in advance.

LL.

[Print XLS problem (pageFooter)]

Hi,

 

I'm printing an XLS landscape report on my web application.

When I'm using iReport to visualise my report the pageFooter is correctly placed. But when I open my xls document by my web application (using of course the same jrxml) the pageFooter is not correct: there are 6 rows added on the first page! I have more than 100 pages so it's not good at all, everything is incorrect.

Thank you for your help.

LL

[Any other charts?]

Thank you, that's what I was thinking.

Bye.