atanupanda

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] Post edited by: atanupanda, at: 2007/02/06 10:01 Post edited by: atanupanda, at: 2007/02/06 10:02 Post edited by: atanupanda, at: 2007/02/06 10:03

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] Post edited by: atanupanda, at: 2007/02/06 10:06 Post edited by: atanupanda, at: 2007/02/06 10:09

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] Post edited by: atanupanda, at: 2007/02/06 10:06 Post edited by: atanupanda, at: 2007/02/06 10:07

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] Post edited by: atanupanda, at: 2007/02/06 10:05

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. size=500]C:Documents and SettingsAtanuMy Documentsdata.jpg 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 is Lcl. size=150]C:Documents and SettingsAtanuMy Documentsgraph.jpg Actually I have got a information that for that I have to write a customizer class for chart. Also I have write it . 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 OSMOSYS!"); } } 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.doc size=49152]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/query.doc[/file] size=159]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/graph.JPG Post edited by: atanupanda, at: 2007/02/06 09:35 Post edited by: atanupanda, at: 2007/02/06 09:37

Post edited by: atanupanda, at: 2007/02/05 12:15

Hi See I have used in jboss app server. but I havn't use it for php. I think it may use for php. Sorry I can't help you. Best of luck Thanks

Hi First of all I want to tell you that please don't mind if there is any problem regarding to this topic opening. I am attaching a file for this. I am very new in iReport. As I show in this picture I want to create this line chart according to this values.I want to mean that in X axis there will be value from t1 -t2-t3-t4-t5 columns . Also there will be upper value and lower value limit and their corresponding line. If any value close to this upper line or lower line it will show yellow alert as shown in this picture. If any value cross this upper line or lower line it will show red alert as shown in this picture. Also I want to draw line corresponding this uppper value and lower value. Please any one help me. If any one don't understand what i want please reply. [file name=test_2eb6e0b070efd73f83e242f67fac14c1.doc size=98816]

Hi First of all thank you for your reply. I am very new in iReport. I have attached a file named test.doc. As I show in this picture I want to create this line chart according to this values.I want to mean that in X axis there will be time from t1 -t2-t3-t4-t5 and for each time there will be specific value. Also there will be upper value and lower value limit and their corresponding line. If any value close to this upper line or lower line it will show red alert as shown in this picture. Please any one help me. If any one don't understand what i want please reply. [file name=test-2eb6e0b070efd73f83e242f67fac14c1.doc size=98816]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/test-2eb6e0b070efd73f83e242f67fac14c1.doc[/file]

Hi I am very new in iReport. As I show in this picture I want to create this line chart according to this values.I want to mean that in X axis there will be time from t1 -t2-t3-t4-t5 and for each time there will be specific value. Also there will be upper value and lower value limit and their corresponding line. If any value close to this upper line or lower line it will show red alert as shown in this picture. Please any one help me. If any one don't understand what i want please reply. [file name=test.doc size=98816]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/test.doc[/file]

Hi I am new in this forum . But this forum helps me very much.Speciall I like thank Mr. wegnerk, Mr. seshasaib,Mr. anandharaj and all of the other members of this forum. I have a problem. I am creating a project on java, jsp, mysql ejb etc. I am using JBoss, eclipse ,Jasper report ireport etc.. tools. Now I want to try to create build.xml file to compile with ANT . I have got a tutorial. There I saw a build.xml file . also application.xml , web.xml. If you please tell me the details of necesarry of these xml file and what is the procedure of creating those files . Actually I want to crate a war or ear file and want to deploy it inside jboss.(I want to mean where to keep which file.) I will be haighly glad to you. Thanks Atanu Panda Student