atanupanda

Hi I am very new in iReport. i have learnt a lot from this forum. Now I am trying to draw time series chart. In my data base I have last_computed_time (String) ex=12:30 am Jan 2nd, 07, and time_interval as String and five values like t1(double),t2(double),t3(double),t4(double),t5(double). here aome other cols like actual value ,UCL and LCL these are double. Now I have to draw a time series chart where value time ----- -------- t1 last_computed_time + time _interval t2 last_computed_time + time _interval+ time _interval t3 last_computed_time + time _interval+ time _interval+ time _interval in this up to t5. my problem is that I can't convert the string value of last_computed_time and time _interval INTO TIME STAMP /DATE/TIME in this format. and also addition of both of them. Actually in java I can convert it using SimpleDateFormat and parsing method. but in ireport I am getting problem . I need some thing like this here the purpale line shows UCL(upper controll line) and blue line shows LCL(lower controll line). here is some checking if value of t1/t2/t3/t4/t5 is sreater or smaller than UCL or LCL then the color of t1/t2/t3/t4/t5 will different. That I can do using customizer class. I need to draw this two line associated with UCL and LCL along x-directionthis is very impotant. And other value measurement will be on y direction. If you don't under stand my query please reply. Please help me. Any help would be greatly appreciated. Thanks in advance. size=150C:/Documents and Settings/Atanu/My Documents/graph.GIF[/img] size=150C:/Documents and Settings/Atanu/My Documents/graph.jpg[/img] Post edited by: atanupanda, at: 2007/02/15 12:01 Post edited by: atanupanda, at: 2007/02/15 12:03

Hi Very very thanks for ur reply. i have got information from ur reply . Actaually can you please tell me how can I get value of each coloumn for each row in customizer class. Actually I am drawing chart for each row. I want to check value of t1 t2 t3 t4 t5 with actual value and UCL and LCL. Depending on that I will change color in customizer class and it will effect to ireport. I am also attaching my xml file and the picture what I want. If you don't understand what I am trying to do please inform me.Its urgent. Again thank u for ur help. thanks Atanu [file name=new_dashboard-f3cce1afdf7d92275abd9c7caefd2b42.xml size=15458]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/new_dashboard-f3cce1afdf7d92275abd9c7caefd2b42.xml%5B/file] size=159]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/graph-3bbe8cfd78ac4d9e5d9a78975d548030.JPG

Hi Very very thanks for ur reply. i have got a lot of information from ur reply and links. But the things is that I have to use ireport software for jasper report.And here I am seeing that it is java programm from where charts are generating. i have to do it fetching data from database using ireport. Actaually can you please tell me how can I get value of each coloumn for each row in customizer class. Actually I am drawing chart for each row. I want to check value of t1 t2 t3 t4 t5 with actual value and UCL and LCL. Depending on that I will change color in customizer class and it will effect to ireport. I am also attaching my xml file and the picture what I want. If you don't understand what I am trying to do please inform me.Its urgent. Again thank u for ur help. thanks Atanu [file name=new_dashboard.xml size=15458]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/new_dashboard.xml%5B/file] size=159]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/graph-bb81c364023c743c7ef721708f1a5952.JPG Post edited by: atanupanda, at: 2007/02/07 08:16

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-17c75ceafc23f4185621a5dfb15f6fdf.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-17c75ceafc23f4185621a5dfb15f6fdf.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-dbe8d650ab388f1df8827b2cf1b2c701.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-dbe8d650ab388f1df8827b2cf1b2c701.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-52ab618728e36a155f8c2d539f703f90.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-52ab618728e36a155f8c2d539f703f90.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-53f6e49791657a60c8095f8d0a2c4077.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-53f6e49791657a60c8095f8d0a2c4077.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-18f0b8f76d25f348849a7a8978b5140e.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-18f0b8f76d25f348849a7a8978b5140e.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-1d4e611fb20804946f9e10c06f90b206.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-1d4e611fb20804946f9e10c06f90b206.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-0f9ec2da256009c896080677827ecfbc.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-0f9ec2da256009c896080677827ecfbc.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-2a31efb2100005a59a4201182132d758.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-2a31efb2100005a59a4201182132d758.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-fb85ddd020eca5e8437b37d2b6de10db.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-fb85ddd020eca5e8437b37d2b6de10db.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-4aa4b6a72bb031c3b43d6f4a203d1d2a.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-4aa4b6a72bb031c3b43d6f4a203d1d2a.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-40eb537b26e8333cf69ecaaa1dff9592.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-40eb537b26e8333cf69ecaaa1dff9592.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img] Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150C:Documents and SettingsAtanuMy Documentsdata.jpeg[/img] Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code: import net.sf.jasperreports.engine.*; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.JREmptyDataSource; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import javax.sql.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.*; import org.jfree.chart.renderer.*; import org.jfree.chart.ChartRenderingInfo; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.LevelRenderer; import org.jfree.chart.renderer.category.LayeredBarRenderer; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import java.lang.String; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.view.JasperViewer; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.renderer.category.LineRenderer3D; import java.awt.*; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import net.sf.jasperreports.engine.*; import java.awt.Color; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.renderer.category.BarRenderer3D; import java.lang.Object; public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(1, Color.green); renderer.setSeriesPaint(4, Color.orange); chart.setTitle("Setting the title "«»); } } Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-ec0b3122efd93feab6a346079c2de4e2.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-ec0b3122efd93feab6a346079c2de4e2.doc[/file]

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150]C:Documents and SettingsAtanuMy Documentsgraph.jpeg Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150]C:Documents and SettingsAtanuMy Documentsdata.jpeg Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code:Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-fb338eeb5e30d8780bac5da0498daec7.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-fb338eeb5e30d8780bac5da0498daec7.doc[/file] size=159]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/graph-12dd39873f3c8a326f1a9a691a7e8d11.JPG

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150]C:Documents and SettingsAtanuMy Documentsgraph.jpeg Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150]C:Documents and SettingsAtanuMy Documentsdata.jpeg Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code:Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-868c8d4577b70b24ab63fb0dbf9c77b4.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-868c8d4577b70b24ab63fb0dbf9c77b4.doc[/file] size=159]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/graph-a703119bdd20bb8459f3125835c3ae9a.JPG

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150]C:Documents and SettingsAtanuMy Documentsgraph.jpeg Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150]C:Documents and SettingsAtanuMy Documentsdata.jpeg Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code:Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-b7c52e5a18c371f334d469163efc4611.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-b7c52e5a18c371f334d469163efc4611.doc[/file] size=159]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/graph-5e9a6eb65c9a8bfc7aa0cb49268906ef.JPG

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150]C:Documents and SettingsAtanuMy Documentsgraph.jpeg Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150]C:Documents and SettingsAtanuMy Documentsdata.jpeg Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code:Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] Post edited by: atanupanda, at: 2007/02/06 10:06 [file name=query-c49f4d73730138a50fb4a684c3af58f4.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-c49f4d73730138a50fb4a684c3af58f4.doc[/file] size=159]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/graph-71a89926482d25dddabbf9930035c2b3.JPG

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150]C:Documents and SettingsAtanuMy Documentsgraph.jpeg Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150]C:Documents and SettingsAtanuMy Documentsdata.jpeg Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code:Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] [file name=query-f43e5eff273aeb77d1364cc5f09484dc.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-f43e5eff273aeb77d1364cc5f09484dc.doc[/file] size=159]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/graph-4af1b993db50050c28850a4d8438e325.JPG

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150]C:Documents and SettingsAtanuMy Documentsgraph.jpeg Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150]C:Documents and SettingsAtanuMy Documentsdata.jpeg Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code:Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] Post edited by: atanupanda, at: 2007/02/06 10:06 [file name=query-fa9f4dfa6779100ef3de23918dc3f85b.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-fa9f4dfa6779100ef3de23918dc3f85b.doc[/file] size=159]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/graph-bee6bf96149cd5832e17a5c51593322f.JPG

Hi This is Atanu. I am very new in ireport and also in java environment. In the ireport I have designed a template .like this. please look on attach file size=150]C:Documents and SettingsAtanuMy Documentsgraph.jpeg Now I want to plot a line graph on the basis of the each data like t1 t2 ---t5 and lcl, ucl, actual value for each row. That I have done. Now my problem is that I have to change the color of points of t1 t2 ---t5 on the basis of Lcl and Ucl . If the value of t1 ,or t2 or ----t5 are between Ucl and Lcl the color will be blue. And if it out side of Lcl and Ucl then it will be red.. I want the following figure. Where the upper bold line is Ucl and lower bold line isLcl size=150]C:Documents and SettingsAtanuMy Documentsdata.jpeg Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . Code:Now this customize class ok running successfully with creating jar files. Now I want to create a logic to check the value of t1 t2 t3 t5 with respect to UCL and LCL. How can I fetch data from report. Or is there any other way to do this. Is there any way to pass value from iReport to customizer class ? What should I do. Please please help me. It’s urget for me. Any help would be greatly appreciated. Thanks in advance. [file name=query-37ab101e3a539a71be9c962f72749d92.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-37ab101e3a539a71be9c962f72749d92.doc[/file] Post edited by: atanupanda, at: 2007/02/06 10:06 [file name=query-10b0405423ed738f0fcb200de55b103b.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query-10b0405423ed738f0fcb200de55b103b.doc[/file] size=159]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/graph-b9f6e4b9c5699f5e036e1a4fc4336297.JPG