danielsb2

What is the error? Remember to use in the table only the Fields of your subdataset "RequestApproval" You cannot use other Fields.... but i'm not know it is the problem... i need you send the error... If interest, i made a video showing how to use the table: http://bit.ly/cY4xMH (audio only in portuguese, but i think you will not need the audio) Post Edited by danielsb2 at 28/06/2010 11:55

Thank you so much bfoese!! The trick works perfectly /tools/fckeditor/editor/images/smiley/msn/teeth_smile.gif ========================================= Site: http://www.danielsousa.com.br Twitter: @danielsbarros

I believe it is not possible to merge the cell. As it Giulio said, I could not do. I will report to be added in next version somethins like a "footer" to the table. Request: http://jasperforge.org/projects/jasperreports/tracker/view.php?id=4742 ========================================= Site: http://www.danielsousa.com.br Twitter: @danielsbarros Post Edited by danielsb2 at 10/06/2010 14:35

I have this scenario: Detail 1: Three different chartsDetail 2: One table Detail 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10 / 11 / 12: All equal to Detail 1 and 2, but using a different dataset. If there was a way to change the dataset table using a condition, I just need the detail 1 and 2, all others are unnecessary work. I reported this as new Feature to nexts releases.http://jasperforge.org/projects/ireport/tracker/view.php?id=4737 ========================================= Site: http://www.danielsousa.com.br Twitter: @danielsbarros Post Edited by danielsb2 at 06/06/2010 17:19

Thanks for reply giulio. IReport suggests only fields from the main query. It does not suggest the fields of others subdatasets I created. This is a problem because you can not use a style conditional on the Table / List Component when it uses a subdataset different of principal query. I need to change the background color of the style "table_TD" based on a field of subdataset. I reported it as a bug in the bug tracker: http://jasperforge.org/projects/jasperreports/tracker/view.php?id=4736 I suggest that on the screen of expression of Conditional Style, you may choose one of subdataset made in the report, then the screen displays the fields, variables and parameters of it. What do you think? ========================================= Site: http://www.danielsousa.com.br Twitter: @danielsbarros Post Edited by danielsb2 at 04/06/2010 09:54

I have a table in my report and i need to change de color of a row depending of a field of the subdataset. I created a style, but the screen of expression of conditional style does not allow me to create an expression using a field of my subdataset. Is not possible to create a conditional style using my subdataset fields as expression? If not, how can I do to change the color of entire row of the table without having to put the same expression in every cell line and create another field with the background of another color? ========================================= Site: http://www.danielsousa.com.br Twitter: @danielsbarros

Is not possible to change the subdataset conditionally? ========================================= Site: http://www.danielsousa.com.br Twitter: @danielsbarros

You can use a chart customizer like that, and set the properties that not is possible to set in iReport Code:package br.anc.reports.chart;import org.jfree.chart.JFreeChart;import org.jfree.chart.axis.NumberAxis;import org.jfree.chart.plot.CategoryPlot;import net.sf.jasperreports.engine.JRChart;import net.sf.jasperreports.engine.JRChartCustomizer;public class MyCustomChart implements JRChartCustomizer{ public void customize(JFreeChart chart, JRChart jasperChart){ CategoryPlot plot = (CategoryPlot)chart.getPlot(); // Set the x-axis range (0 to 5, only integers) NumberAxis rangeAxis = (NumberAxis) plot.getRangeAxis(); rangeAxis.setRange(0, 5); rangeAxis.setStandardTickUnits(NumberAxis.createIntegerTickUnits()); //Set Item label (Font/size) CategoryItemRenderer categoryRenderer = plot.getRenderer(); categoryRenderer.setBaseItemLabelFont(new Font("Arial", Font.PLAIN, 5)); //BarRenderer barRenderer = (BarRenderer) plot.getRenderer(); //barRenderer.setDrawBarOutline(false); //barRenderer.setItemMargin(.1); } }

In iReport, i can generate a chart passing it a subdataset. I created many subdatasets with different queries, but return the same fields. I drew a bar chart and would like to set one of these subdatasets depending on a condition. There is this possibility? Today, I am drawing a lot of identical graphs, one for each subdataset. I need just one chart drawn. If i can not do this in iReport, I suggest that this functionality is added. Post Edited by danielsb2 at 27/05/2010 17:36

Giulio, could you send me a xml with a example like this table?

Thanks for the reply Giulio!, I did not understand how to do what you say, but I tried and failed. The table must be created that looks like this attached. Could you send me a sample table with the merged cell that format? /uploads/projects/ireport/table.PNG Post Edited by danielsb2 at 05/20/2010 14:39

I have a table with 5 columns and in the footer, i need to merge 3 coluns to show a value. is possible to merge cell using the table component? i'm using iReport 3.7.2 ========================================= Site: http://www.danielsousa.com.br Twitter: @danielsbarros Post Edited by danielsb2 at 01/07/2010 08:16

I don't know the version 3.5.0 but in 3.0.0 you can do a external class customizing de chart: Example: This example show how to show the labels from 0 to 5, showing only integer numbers Code: Post Edited by danielsb2 at 06/24/2009 14:23

is a external class that extends JRDefaultScriptlet I've set $P{REPORT_SCRIPTLET} with this class. I want to pass this $P{REPORT_SCRIPTLET} to the other subreports and use the methods of this class on them without need to manually config all the subreports. I wish only to receive the parameter $P{REPORT_SCRIPTLET} from the master and use the functions: $P{REPORT_SCRIPTLET}.function() but the subreports not compiles... Post Edited by Daniel Sousa at 03/12/09 16:45

Hi guys, I have a master report (A) with two subreports (A1 and A2). i need to use in the subreports a method defined in a scriptlet "br.calcs.CalcScriptlet", called CalcVal(Integer, Integer) I' d set in the Master report the scriptlet: $P{REPORT_SCRIPTLET} = br.calcs.CalcScriptlet The master compiles ok. But i need to pass this Scriptlet to my subreports, to use the function CalcVal. i tried to pass to subreports like this: REPORT_SCRIPTLET $P{REPORT_SCRIPTLET} and in the subreport, i tried to use the function like this: $P{REPORT_SCRIPLET.CalcVal(10, 60) When i try to compile, i got an error. the iReport not compiles te subreport. Not is possible to pass scritlets by parameter? i will need to set $P{REPORT_SCRIPTLET} in the two subreports manually? Code:net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:C:work_ganyRptwwwrelatoriosdclRpt_0001Rpt_0001_s2_1236861899171_744259.java:186: cannot find symbolsymbol : method Calc(java.lang.Integer,java.lang.Integer)location: class net.sf.jasperreports.engine.JRAbstractScriptlet value = (java.lang.String)(((net.sf.jasperreports.engine.JRAbstractScriptlet)parameter_REPORT_SCRIPTLET.getValue()).geraEscala(((java.lang.Integer)field_min_escala.getValue()), ((java.lang.Integer)field_max_escala.getValue())));//$JR_EXPR_ID=8$ ^C:work_ganyRptwwwrelatoriosdclRpt_0001Rpt_0001_s2_1236861899171_744259.java:264: cannot find symbolsymbol : method geraEscala(java.lang.Integer,java.lang.Integer)location: class net.sf.jasperreports.engine.JRAbstractScriptlet value = (java.lang.String)(((net.sf.jasperreports.engine.JRAbstractScriptlet)parameter_REPORT_SCRIPTLET.getValue()).CalcVal(((java.lang.Integer)field_min_escala.getOldValue()), ((java.lang.Integer)field_max_escala.getOldValue())));//$JR_EXPR_ID=8$ ^C:work_ganyRptwwwrelatoriosdclRpt_0001Rpt_0001_s2_1236861899171_744259.java:342: cannot find symbolsymbol : method geraEscala(java.lang.Integer,java.lang.Integer)location: class net.sf.jasperreports.engine.JRAbstractScriptlet value = (java.lang.String)(((net.sf.jasperreports.engine.JRAbstractScriptlet)parameter_REPORT_SCRIPTLET.getValue()).CalcVal(((java.lang.Integer)field_min_escala.getValue()), ((java.lang.Integer)field_max_escala.getValue())));//$JR_EXPR_ID=8$ ^3 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:193) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:219) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:135) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:604) at java.lang.Thread.run(Unknown Source) Post Edited by Daniel Sousa at 03/12/09 12:49