bloubite

Hi guys My report has 1 "pie chart" and the associated listing which encounters ruptures on groups (see attached image). I try to use as "pie series", the value of a scriptlet variable (scripletResult). This variable is updated in each "afterDetailEval()" scriplet call and the value is right when the group "breaks" (this is why the fields and the variable are in the group footer section) Is it possible to retrieve these variable values in my pie chart ? How can it be done ? In advance thanks !

hi guys /tools/fckeditor/editor/images/smiley/msn/regular_smile.gif $P!{} is exactly what I was looking for. Thanks for the quick answer !

Hi guys /tools/fckeditor/editor/images/smiley/msn/regular_smile.gif In my report, I'd like to execute this query : SELECT * FROM TABLE WHERE CODE_ITEM IN ( "AA", "BB", "CC") As long as "item codes" are hardcoded in the query, everything is fine. But when I try to pass these by parameter, it doesn't work. I get not result. Yet, when I try to display the parameter on the page, everything seems to be ok. In my JRXML file, the query is : SELECT * FROM TABLE WHERE CODE_ITEM IN ( $P{itemCodes} ) In my java file, the parameter is : map.put("itemCodes", ""AA", "BB", "CC""); (with backslashes that are not displayed on this forum) The value expression is set to "Text" (java.lang.String) for the parameter. I'm confused. Have you an idea ? I'm not sure datasets can help for this kind of problem Thanks in advance ! Post Edited by bloubite at 07/24/2011 20:15 Post Edited by bloubite at 07/24/2011 20:17

hi /tools/fckeditor/editor/images/smiley/msn/wink_smile.gif I find your solution very elegant and I didn't know about counter variables. However, I think I'll use subreports with parameters (for the different criterias). The 3 criteria do not really correspond to rows in my DB and it seems to me this is what you assumed in your solution. The criterias are not the content of a single row/column but I need to iterate on them for displaying the 3 different results, of course. Anyway, it's great to talk, Thanks !

are you looking for the horizontal print order ?

Hi guys /tools/fckeditor/editor/images/smiley/msn/regular_smile.gif I'm new to JasperReports and though I begin to understand some of the possibilities of the tool, I'm not ok with everything. I'd like to generate an activity report for my application. I would like to get the result of the 3 following queries : SELECT count(*) from table where criteria = 1; SELECT count(*) from table where criteria = 2; SELECT count(*) from table where criteria = 3;I could pass these values to my report by parameters but the problem is that these 3 queries would be used in conjunction with the “group by” functionality of Jasper for better presentation Thus, the parameter number could possibly be very important. Can you see a solution for this problem ? In advance, thanks ! Post Edited by bloubite at 07/08/2011 15:03