jbeausse

Hi All, Here is a question, regarding charts and groups. I've looked at all the documentation and all chart samples, but samples seem to be "academic" and don't cover my needs. Here is my problem : - Data structure is the following : Gamme (Range), Produit, Année (Year), ventes1 (sales), ventes2 - I use a group at "year" level in order to : * display a detailed table (range, product, zone, sales) * display an aggregated bar chart (range / product) Here is what I get : size=286]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/pb_graphe_groupe2.gif Here is a fragment of JRXML : Code: Please notice that the series expression is DYNAMIC, i.e the series names depend on data (in jasperreports samples, every seriesexpression is static). Data are mostly fine EXCEPT for range "C" : look at sales for product D and F ! I can't find the appropriate configuration, and don't want to use subreports. Do you have an idea to configure the chart dataset as needed ? This is very urgent, thn'x in advance, Julien, France Post edited by: jbeausse, at: 2007/01/04 12:21

Do you have any idea about this topic please ??

here is the attachment... [file name=pb_no_data_found.png size=161313]

Hi all, My objective is very simple : display a "no data found" message in a report when no data is available. I use velocity to generate JRXML dynamically, and this message might be used in different contexts (subreports, etc.). The solution I found : Code: Imagine that this detail is displayed in a subreport, and that I don't have enough space to display the first element (end of a page). My problem is that even if I use the "Report" evaluationTime in my textField, it seems that the printWhenExpression is evaluated *at the end of each column*, so if there is not enough space to display an element, the message is displayed (see attachment). PS : I'd prefer not to use a summary section/fake group since it complicates my work a lot ! Thn'x Julien JR version : 1.2.8 Post edited by: jbeausse, at: 2007/01/03 13:08

Hi all, My objective is very simple : display a "no data found" message in a report when no data is available. I use velocity to generate JRXML dynamically, and this message might be used in different contexts (subreports, etc.). The solution I found : Code: * * * my detail * * * </detail> <!-- a column footer with the message --> <columnFooter> <band height="30" isSplitAllowed="true"> <textField isStretchWithOverflow="true" evaluationTime="Report"> <reportElement x="0" y="0" width="510" height="30" style="noDataFound"> <printWhenExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()==0)]]></printWhenExpression> </reportElement> <box border="Thin" borderColor="#FF0000" /> <textFieldExpression class="java.lang.String"><![CDATA[$R{labels.nodatafound}]]></textFieldExpression> </textField> </band> </columnFooter> Imagine that this detail is displayed in a subreport, and that I don't have enough space to display the first element (end of a page). My problem is that even if I use the "Report" evaluationTime in my textField, it seems that the printWhenExpression is evaluated *at the end of each column*, so if there is not enough space to display an element, the message is displayed (see attachment). PS : I'd prefer not to use a summary section/fake group since it complicates my work a lot ! Thn'x Julien JR version : 1.2.8

Here are 2 screenshots of the generated PDF : body and summary [file name=pdf_fragments.zip size=85404]

Here is the attachment... [file name=pb_graphe_summary.zip size=65011]

Hi all, I'm currently facing a design problem regarding charts. Imagine this simple data structure representing sales in value/volume of ranges/product among zones/countries : LIB_YEAR LIB_GAMME LIB_PDT LIB_ZONE LIB_PAYS VENTES VOLUMES 2001 Gamme A Product A Europe Suisse 157 1222 2001 Gamme A Product A USA Etats Unis 341 2602 2001 Gamme A Product A Europe France 650 2738 2001 Gamme A Product A Europe Suisse 664 5796 2001 Gamme B Product B USA Etats Unis 169 1104 2001 Gamme B Product B Europe France 1165 1014 2001 Gamme B Product B Europe France 1680 15750 etc. I want to generate a report with the following structure : Group 1 : Year 2001 Group 2 : Gamme A Data Table for Gamme A Chart for current Gamme A [/ul] Group 2 : Gamme B Data Table for Gamme B Chart for current Gamme B [/ul] [/ul] Summary : A bar chart representing sales per year/gamme (see image in attachment) : - Values = sales - Categories = year - Series = gammes My problem is in the summary chart definition : I can't find out how to define custom variables allowing me to sum data correctly ! (you will notice that the sort order for my groups and summary chart is a priori different). I join an attachment containing an XLS file + current jrxml and report generated. Thn'x in advance for your help ! Julien, France PS : I use a custom datasource and on-the-fly JRXML generation Post edited by: jbeausse, at: 2006/12/15 15:29

OK thn'x very much Teodor, I'll try it right now. Could we find a global roadmap somewhere ?

Hi all, Imagine that my client wants to generate a huge table in terms of columns (ie. 30 columns). With Business Object, it is possible to split such table on several pages : page 1 : 10 first columns, page 2 : 10 following columns page 3 : 10 last columns page 4 : 10 first columns, etc. Is it possible to do so with JasperReports ? Thn'x in advance Julien PS : I use jasperreports 1.2.5

Hi all, Is it possible to generate a chart combining bars and lines at the same time (MS Excel does that easily) ? I didn't find that kind of things neither in the doc nore in iReport designer. Thn'x in advance, Julien PS : I use jasperreports 1.2.5

OK Thn'x. Do you have an idea of the next release date/version including this fix ? Julien

Hi all, Following this question, you will find in attachment 2 report definitions in a zip file and associated output. JasperReports : 1.2.5 Julien PS : JRXML definition is originally generated via velocity template processing, I post a manually simplified version. Data structure is very simple. [file name=pb_rtf_frames.zip size=122742]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/pb_rtf_frames.zip[/file]

Hi all, I face a curious problem, following activation of report virtualier. Here it is : - I create a report including a simple chart and a fiew data, without virtualizer : works fine. - Then, I add the Virtualizer support : JRFileVirtualizer vVirtualizer = new JRFileVirtualizer(2); pParameters.put(JRParameter.REPORT_VIRTUALIZER, vVirtualizer); The same report (contains more than 2 pages) generate a noclassdeffounderror on a jfreechart class ! I use (in both cases) the JDTCompiler. Any idea ? Thn'x in advance, Julien

I've got the same problem, even without using subreports in my frame ! :angry: