llaconde

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.

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.

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

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.

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:

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.

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.

I still haven't found the solution. Ideas? Thx.

What are you using for display: PDF, XLS, CSV, RTF? And are you using the viewer of iReport to check the results?

I tried but i get "null" as result. Do you anybody have an idea? Thank you for your help.

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

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:

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.

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.

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