atanupanda

Hi I have a new problem. I want to display some dynamic field value on top of a image. I have tried to put image and field value on same place and send the image back. but still i can't get my desired out put.this is happening for HTML format only not for pdf format. Please give some idea to resolve this issue. Actually i want to use background color of dynamic fields as GradiendPaint color. But i can't do that. I have created images with GradiendPaint color and want to use as background image for dynamic fields. But i can't do that for html only. But i need to do that. Please give some idea to resolve that. If required i can send more information. I have searched the forum a lot but didn't get any satisfactory result. Thanks in advance. Atanu Panda

Thanks for your help. I have a new problem. I want to display some dynamic field value on top of a image. I have tried to put image and field value on same place and send the image back. but still i can't get my desired out put. Please give some idea to resolve the problem Thanks a lot.

Hi Friends First of all very very thanks to give reply. Still i have not found any solution of my problem .I am not using any subreport in my report .there is only one report. The whole 100 or 300 or 500 points(each points have time and corresponding value) should be plotted in single report as html and pdf format.Data are coming dynamically . For html dynamic change of width is coming fine as Code: String = (String)this.getParameterValue(""«»); int width = Integer.parseInt() * 30; jasperChart.setWidth(width); where totalreport = 100 or 300 or 500 points coming dynmically. But in case of pdf this showing some part but rest of the part(this is large) is not showing. I am using jdk1.5 ,ireport 1.3.0,and adobe reader 8.0 Also for each cases ( html and pdf ) while trying to plot large no of dataset when plotting line or bar chart i am getting some space within y-axis and start of first point. But for little amount of data there is no gap within y-axis and start of first point. For little amount of dataset it looks nice but for large amount of data it showing very badly. Actually i have also seen that this gap is coming huge when this totalreport become huge. This gap is also dynamically changing depending on totalreport ; Is there any solution by which plotting will be start from very close to y-axis. If you need any other information for this problem please let me know about that. This is very serious issue for me. Thanks in advance. Atanu Panda

Hi Another file for my report. Thanks Atanu Panda [file name=gaps_report-5ec00cfb6448475e461b591f4aedceeb.zip size=134607]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/gaps_report-5ec00cfb6448475e461b591f4aedceeb.zip[/file]

Hi I am working with iReport 1.3.0 for the last 4-5 months. I am not very well in jasper reporting. Now i have some problem which is very harmful for company's project. We are handling with very large amount of data we need to show it as html and pdf format. I have two problems: 1.In my report i am displaing line chart or bar chart for different sets of data. This data size may be 100,300,500 .This comes from database as a list of database dynamically. I pass it to the report through JRBeandatasource.But problem is that while displaying the report i need to dynamically change my report width to capture all the data. But this dynamically change of my report's width is happening for html only ,for pdf it is showing some part but rest of the part is truncated. this very serious problem. I have written some customizer class for line and bat chart as for bar chart Code: public class BarChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { BarRenderer renderer = (BarRenderer) chart.getCategoryPlot().getRenderer(); String totalreport = (String)this.getParameterValue("totalreport"«»); int width = Integer.parseInt(totalreport) * 30; jasperChart.setWidth(width); } } for line chart Code:[code] public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); String totalreport = (String)this.getParameterValue("totalreport"«»); int width = Integer.parseInt(totalreport) * 30; jasperChart.setWidth(width); } } where totalreport is no of points (100,300,500 ..like this ) Please tell me how to solve this problem of pdf truncation. It's very urgent. 2. Also there is another problem while trying to plot large dataset when plotting line or bar chart i am getting some space within y-axis and start of first point. But for little amount of data there is no gap within y-axis and start of first point. Please let me know what should i do to resolve this issue. It's very urgent for me. Also you can send some URL from where i can get some information to solve this problem. If any one doesn't understand my problem please please let me know i will try to give some more information on my problem. I am attaching the rar files which will clearly explain my problem in report. Thanks to read this large problem. Thanks in advance. [file name=trucated_report-a13d92b661b6db0577ec1b4b65b2ad91.zip size=96655]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/trucated_report-a13d92b661b6db0577ec1b4b65b2ad91.zip[/file]

Hi My another zip file Thanks [file name=gaps_report.zip size=134607]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/gaps_report.zip[/file]

atanupanda wrote: Hi I am working with iReport 1.3.0 for the last 4-5 months. I am not very well in jasper reporting. Now i have some problem which is very harmful for company's project. We are handling with very large amount of data we need to show it as html and pdf format. I have two problems: 1.In my report i am displaing line chart or bar chart for different sets of data. This data size may be 100,300,500 .This comes from database as a list of database dynamically. I pass it to the report through JRBeandatasource.But problem is that while displaying the report i need to dynamically change my report width to capture all the data. But this dynamically change of my report's width is happening for html only ,for pdf it is showing some part but rest of the part is truncated. this very serious problem. I have written some customizer class for line and bat chart as for bar chart Code: public class BarChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { BarRenderer renderer = (BarRenderer) chart.getCategoryPlot().getRenderer(); String totalreport = (String)this.getParameterValue("totalreport"«»); int width = Integer.parseInt(totalreport) * 30; jasperChart.setWidth(width); } } for line chart Code:[code] public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); String totalreport = (String)this.getParameterValue("totalreport"«»); int width = Integer.parseInt(totalreport) * 30; jasperChart.setWidth(width); } } where totalreport is no of points (100,300,500 ..like this ) Please tell me how to solve this problem of pdf truncation. It's very urgent. 2. Also there is another problem while trying to plot large dataset when plotting line or bar chart i am getting some space within y-axis and start of first point. But for little amount of data there is no gap within y-axis and start of first point. Please let me know what should i do to resolve this issue. It's very urgent for me. Also you can send some URL from where i can get some information to solve this problem. If any one doesn't understand my problem please please let me know i will try to give some more information on my problem. I am attaching the rar files which will clearly explain my problem in report. Thanks to read this large problem. Thanks in advance. <br><br>Post edited by: atanupanda, at: 2007/07/09 12:26 [file name=trucated_report.zip size=96655]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/trucated_report.zip[/file]

Hi Please see the bellow .I have done some wrong while posting my problem. Thanks Atanu Panda Post edited by: atanupanda, at: 2007/07/09 12:32

Hi I am working with iReport 1.3.0 for the last 4-5 months. I am not very well in jasper reporting. Now i have some problem which is very harmful for company's project. We are handling with very large amount of data we need to show it as html and pdf format. I have two problems: 1.In my report i am displaing line chart or bar chart for different sets of data. This data size may be 100,300,500 .This comes from database as a list of database dynamically. I pass it to the report through JRBeandatasource.But problem is that while displaying the report i need to dynamically change my report width to capture all the data. But this dynamically change of my report's width is happening for html only ,for pdf it is showing some part but rest of the part is truncated. this very serious problem. I have written some customizer class for line and bat chart as for bar chart Code: public class BarChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { BarRenderer renderer = (BarRenderer) chart.getCategoryPlot().getRenderer(); String totalreport = (String)this.getParameterValue("totalreport"«»); int width = Integer.parseInt(totalreport) * 30; jasperChart.setWidth(width); } } for line chart Code:[code] public class LineChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { LineAndShapeRenderer renderer = (LineAndShapeRenderer) chart.getCategoryPlot().getRenderer(); String totalreport = (String)this.getParameterValue("totalreport"«»); int width = Integer.parseInt(totalreport) * 30; jasperChart.setWidth(width); } } where totalreport is no of points (100,300,500 ..like this ) Please tell me how to solve this problem of pdf truncation. It's very urgent. 2. Also there is another problem while trying to plot large dataset when plotting line or bar chart i am getting some space within y-axis and start of first point. But for little amount of data there is no gap within y-axis and start of first point. Please let me know what should i do to resolve this issue. It's very urgent for me. Also you can send some URL from where i can get some information to solve this problem. If any one doesn't understand my problem please please let me know i will try to give some more information on my problem. I am attaching the rar files which will clearly explain my problem in report. Thanks to read this large problem. Thanks in advance.

Though I don't have much idea on ireport you can use one sub report on your report's summary band and give a checking on the sub report (in Print When Expression block).This subreport will be active when this parameter will be zero. new Boolean($P{sendedParameter}==0) Use the same query in the sub report what you have written in your master report. I think this may give your answer. Let me know your feedback. Thanks Post edited by: atanupanda, at: 2007/06/19 12:21

Hi If you are using iReport then whatever chart you are using ,in that chart's property you will find a field to put the name of the customizer class.And you have to save your customizer.class in the place where you have saved your jrxml/xml file. You can also create a jar for your class and you can add this jar to classpath of iReport. I think this may help you (as per my little knowledge). this is the syntax to convert a class to jar file. jar cf customizer.jar customizer.class

Hi Sorry for the way i open the issue. I have created a jasper report . I am using a time series chart for that report. All the things are going right.But the problem is that in the label of x-axis rather time axis i am getting date interval as let say 30-NOV, 15-DEC,30-DEC etc.. in this way. But the year part is missing. I want date interval will show as like 30-NOV-2006, 15-DEC-2006,30-DEC-2006. In my data source i have day,month,year specifically. Please give me idea What property of time series chart should i change to get this result or should i need to write some customizer class by which i will get the complete date format in the time axis label? I have column for days(let say Tuesday,Monday..etc.) and column for dates(let say 1-Dec-06,2-Dec-06.)in this way. also some other columns for values.Also when i am displaying the date value in the detail part of jasper report I am getting the complete format of date value. Please let me know If you don't understand my problem Thanks in advance. Atanu Panda Here is the code for my file. [code:1]<?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="Average Touch Time Primary Rush Exception" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <queryString><![CDATA[select * from averagetouchtime]]></queryString> <field name="Average Touch Time_id" class="java.lang.Long"/> <field name="day" class="java.lang.String"/> <field name="date" class="java.lang.String"/> <field name="Average Touch Time Primary Non Rush Exception" class="java.lang.Double"/> <field name="Average Touch Time Secondary Non Rush Exception" class="java.lang.Double"/> <field name="Average Touch Time Primary Non Rush Standard" class="java.lang.Double"/> <field name="Average Touch Time Secondary Non Rush Standard" class="java.lang.Double"/> <field name="Average Touch Time Primary Rush Exception" class="java.lang.Double"/> <field name="Average Touch Time Secondary Rush Exception" class="java.lang.Double"/> <field name="Average Touch Time Primary Rush Standard" class="java.lang.Double"/> <field name="Average Touch Time Secondary Rush Standard" class="java.lang.Double"/> <variable name="daytime" class="java.lang.String" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA[$F{day}+","+$F{date}.substring(0,$F{date}.indexOf( "-", 4 ))+"-20"+$F{date}.substring($F{date}.indexOf( "-", 4 )+1,$F{date}.length())]]></variableExpression> </variable> <variable name="parse" class="java.text.SimpleDateFormat" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA[new SimpleDateFormat("EEEE,d-MMM-yyyy"«»)]]></variableExpression> </variable> <variable name="certificatetime" class="java.util.Date" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA[$V{parse}.parse($V{daytime})]]></variableExpression> </variable> <variable name="index" class="java.lang.Integer" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA[new Integer($F{date}.indexOf( "-", 4 ))]]></variableExpression> </variable> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="1" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="0" isSplitAllowed="true" > </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="390" isSplitAllowed="true" > <rectangle radius="5" > <reportElement mode="Transparent" x="3" y="0" width="529" height="384" forecolor="#000000" key="rectangle-1"/> <graphicElement stretchType="NoStretch" pen="1Point"/> </rectangle> <timeSeriesChart> <chart isShowLegend="false" hyperlinkTarget="Self" > <reportElement x="13" y="5" width="508" height="370" key="element-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <chartTitle color="#000066" > <font fontName="SansSerif" pdfFontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" isPdfEmbedded="false" pdfEncoding="Cp1252"/> <titleExpression><![CDATA["Certificates - Primary Rush Exception"]]></titleExpression> </chartTitle> </chart> <timeSeriesDataset> <dataset > </dataset> <timeSeries> <seriesExpression><![CDATA["Average Touch Time Primary Rush Exception"]]></seriesExpression> <timePeriodExpression><![CDATA[$V{certificatetime}]]></timePeriodExpression> <valueExpression><![CDATA[$F{Average Touch Time Primary Rush Exception}]]></valueExpression> <itemHyperlink > </itemHyperlink> </timeSeries> </timeSeriesDataset> <timeSeriesPlot > <plot > <seriesColor seriesOrder="0" color="#FF66FF"/> </plot> <timeAxisFormat> <axisFormat > </axisFormat> </timeAxisFormat> <valueAxisLabelExpression><![CDATA["Average Touch Time"]]></valueAxisLabelExpression> <valueAxisFormat> <axisFormat labelColor="#330033" > <labelFont> <font fontName="SansSerif" pdfFontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" isPdfEmbedded="true" pdfEncoding="Cp1252"/> </labelFont> <tickLabelFont> </tickLabelFont> </axisFormat> </valueAxisFormat> </timeSeriesPlot> </timeSeriesChart> </band> </summary> </jasperReport> [/code:1]

Post edited by: atanupanda, at: 2007/03/19 08:36

Hi Please tell me the solution. I have attached in the doc file. It's very urgent. Thanks in advance Atanu Panda my code is Code:<?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="date" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <queryString><![CDATA[select * from test]]></queryString> <field name="test_id" class="java.lang.Long"/> <field name="curdate" class="java.sql.Timestamp"/> <field name="value" class="java.lang.Double"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="17" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="8" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="8" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="29" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="dd/MM/yyyy h.mm a" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="10" y="7" width="150" height="20" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{curdate}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="dd/MM/yyyy h.mm a" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="180" y="7" width="180" height="20" key="textField-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{curdate}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="7" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="5" isSplitAllowed="true" > </band> </pageFooter> <lastPageFooter> <band height="4" isSplitAllowed="true" > </band> </lastPageFooter> <summary> <band height="199" isSplitAllowed="true" > <timeSeriesChart> <chart hyperlinkTarget="Self" > <reportElement x="0" y="0" width="510" height="150" key="element-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <chartLegend textColor="#000000" backgroundColor="#FFFFFF" > </chartLegend> </chart> <timeSeriesDataset timePeriod="Hour" > <dataset > </dataset> <timeSeries> <seriesExpression><![CDATA["val"]]></seriesExpression> <timePeriodExpression><![CDATA[$F{curdate}]]></timePeriodExpression> <valueExpression><![CDATA[$F{value}]]></valueExpression> <labelExpression><![CDATA["val"]]></labelExpression> <itemHyperlink > </itemHyperlink> </timeSeries> </timeSeriesDataset> <timeSeriesPlot > <plot /> <timeAxisFormat> <axisFormat > </axisFormat> </timeAxisFormat> <valueAxisFormat> <axisFormat > </axisFormat> </valueAxisFormat> </timeSeriesPlot> </timeSeriesChart> </band> </summary> </jasperReport> [file name=problem-a6546143437a1de8940b599304a13733.doc size=28672]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/problem-a6546143437a1de8940b599304a13733.doc[/file]

Hi Please tell me the solution. I have attached in the doc file. It's very urgent. Thanks in advance Atanu Panda my code is Code:<?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="date" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <queryString><![CDATA[select * from test]]></queryString> <field name="test_id" class="java.lang.Long"/> <field name="curdate" class="java.sql.Timestamp"/> <field name="value" class="java.lang.Double"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="17" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="8" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="8" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="29" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="dd/MM/yyyy h.mm a" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="10" y="7" width="150" height="20" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{curdate}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="dd/MM/yyyy h.mm a" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="180" y="7" width="180" height="20" key="textField-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{curdate}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="7" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="5" isSplitAllowed="true" > </band> </pageFooter> <lastPageFooter> <band height="4" isSplitAllowed="true" > </band> </lastPageFooter> <summary> <band height="199" isSplitAllowed="true" > <timeSeriesChart> <chart hyperlinkTarget="Self" > <reportElement x="0" y="0" width="510" height="150" key="element-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <chartLegend textColor="#000000" backgroundColor="#FFFFFF" > </chartLegend> </chart> <timeSeriesDataset timePeriod="Hour" > <dataset > </dataset> <timeSeries> <seriesExpression><![CDATA["val"]]></seriesExpression> <timePeriodExpression><![CDATA[$F{curdate}]]></timePeriodExpression> <valueExpression><![CDATA[$F{value}]]></valueExpression> <labelExpression><![CDATA["val"]]></labelExpression> <itemHyperlink > </itemHyperlink> </timeSeries> </timeSeriesDataset> <timeSeriesPlot > <plot /> <timeAxisFormat> <axisFormat > </axisFormat> </timeAxisFormat> <valueAxisFormat> <axisFormat > </axisFormat> </valueAxisFormat> </timeSeriesPlot> </timeSeriesChart> </band> </summary> </jasperReport> [file name=problem.doc size=28672]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/problem.doc[/file]

Hi I have a problem with adding some date values. Here below what i have tried. I have created a variable 'parse' with class type java.text.SimpleDateFormat and variable expression new SimpleDateFormat("HH:mm a MMM dd, yy") . Then i created a variable 'dat' with class type java.util.Date and varible expression $V{parse}.parse($F{LAST_COMPUTED}) where $F{LAST_COMPUTED} is a field value (it's a string as example '12:30 am Jan 2nd, 07'). Now i can get this string as a date type varible in $V{dat}. Now i want to add/subtruct some day/month/year/week or hour/minute/second with this $V{dat} varible and want to store in another varible . That i can't do.Please help me on that. Actually in java, using calender class(using add() and set() method) i can do it. But i want to calculate it in iReport(i am using Ver. 1.3.0). Also in iReport I created another variavle 'calender'with class type java.util.Calendar and value expression Calendar.getInstance(). I know that it shows the current datetime value.. Actually i thought that using calender i can do it . But i am in vein. If any one can't under stand my requirement please reply. Please help me to short out this problem. Thanks in advance.

Hi I have a problem with adding some date values. Here below what i have tried. I have created a variable 'parse' with class type java.text.SimpleDateFormat and variable expression new SimpleDateFormat("HH:mm a MMM dd, yy") . Then i created a variable 'dat' with class type java.util.Date and varible expression $V{parse}.parse($F{LAST_COMPUTED}) where $F{LAST_COMPUTED} is a field value (it's a string as example '12:30 am Jan 2nd, 07'). Now i can get this string as a date type varible in $V{dat}. Now i want to add/subtruct some day/month/year/week or hour/minute/second with this $V{dat} varible and want to store in another varible . That i can't do.Please help me on that. Actually in java, using calender class(using add() and set() method) i can do it. But i want to calculate it in iReport(i am using Ver. 1.3.0). Also in iReport I created another variavle 'calender'with class type java.util.Calendar and value expression Calendar.getInstance(). I know that it shows the current datetime value.. Actually i thought that using calender i can do it . But i am in vein. If any one can't under stand my requirement please reply. Please help me to short out this problem. Thanks in advance.

Hi I have a problem with adding some date values. Here below what i have tried. I have created a variable 'parse' with class type java.text.SimpleDateFormat and variable expression new SimpleDateFormat("HH:mm a MMM dd, yy") . Then i created a variable 'dat' with class type java.util.Date and varible expression $V{parse}.parse($F{LAST_COMPUTED}) where $F{LAST_COMPUTED} is a field value (it's a string as example '12:30 am Jan 2nd, 07'). Now i can get this string as a date type varible in $V{dat}. Now i want to add/subtruct some day/month/year/week or hour/minute/second with this $V{dat} varible and want to store in another varible . That i can't do.Please help me on that. Actually in java, using calender class(using add() and set() method) i can do it. But i want to calculate it in iReport(i am using Ver. 1.3.0). Also in iReport I created another variavle 'calender'with class type java.util.Calendar and value expression Calendar.getInstance(). I know that it shows the current datetime value.. Actually i thought that using calender i can do it . But i am in vein. If any one can't under stand my requirement please reply. Please help me to short out this problem. Thanks in advance.

Hi I have a problem with adding some date values. Here below what i have tried. I have created a variable 'parse' with class type java.text.SimpleDateFormat and variable expression new SimpleDateFormat("HH:mm a MMM dd, yy") . Then i created a variable 'dat' with class type java.util.Date and varible expression $V{parse}.parse($F{LAST_COMPUTED}) where $F{LAST_COMPUTED} is a field value (it's a string as example '12:30 am Jan 2nd, 07'). Now i can get this string as a date type varible in $V{dat}. Now i want to add/subtruct some day/month/year/week or hour/minute/second with this $V{dat} varible and want to store in another varible . That i can't do.Please help me on that. Actually in java, using calender class(using add() and set() method) i can do it. But i want to calculate it in iReport(i am using Ver. 1.3.0). Also in iReport I created another variavle 'calender'with class type java.util.Calendar and value expression Calendar.getInstance(). I know that it shows the current datetime value.. Actually i thought that using calender i can do it . But i am in vein. If any one can't under stand my requirement please reply. Please help me to short out this problem. Thanks in advance. Post edited by: atanupanda, at: 2007/02/20 12:08

Hi Actually I can convert string to date datatype. I have a problem with adding some date values. Here below what i have tried. I have created a variable 'parse' with class type java.text.SimpleDateFormat and variable expression new SimpleDateFormat("HH:mm a MMM dd, yy") . Then i created a variable 'dat' with class type java.util.Date and varible expression $V{parse}.parse($F{LAST_COMPUTED}) where $F{LAST_COMPUTED} is a field value (it's a string as example '12:30 am Jan 2nd, 07'). Now i can get this string as a date type varible in $V{dat}. Now i want to add/subtruct some day/month/year/week or hour/minute/second with this $V{dat} varible and want to store in another varible . The adding value may be 1 hour,2 hour, 1 weeks, 2 weeks, 3 months, 4 months in this way. That i can't do in iReport.Please help me on that. Actually in java, using calender class(using add() and set() method) i can do it. But i want to calculate it in iReport(i am using Ver. 1.3.0). Also in iReport I created another variavle 'calender'with class type java.util.Calendar and value expression Calendar.getInstance(). I know that it shows the current datetime value.. Actually i thought that using calender i can do it . But i am in vein. If any one can't under stand my requirement please reply. Please help me to short out this problem in iReport. Thanks in advance.

Hi Very very thanks for your reply. Actually now I can convert string to date datatype. I have a problem with adding some date values. Here below what i have tried. I have created a variable 'parse' with class type java.text.SimpleDateFormat and variable expression new SimpleDateFormat("HH:mm a MMM dd, yy") . Then i created a variable 'dat' with class type java.util.Date and varible expression $V{parse}.parse($F{LAST_COMPUTED}) where $F{LAST_COMPUTED} is a field value (it's a string as example '12:30 am Jan 2nd, 07'). Now i can get this string as a date type varible in $V{dat}. Now i want to add/subtruct some day/month/year/week or hour/minute/second with this $V{dat} varible and want to store in another varible . The adding value may be 1 hour,2 hour, 1 weeks, 2 weeks, 3 months, 4 months in this way. That i can't do in iReport.Please help me on that. Actually in java, using calender class(using add() and set() method) i can do it. But i want to calculate it in iReport(i am using Ver. 1.3.0). Also in iReport I created another variavle 'calender'with class type java.util.Calendar and value expression Calendar.getInstance(). I know that it shows the current datetime value.. Actually i thought that using calender i can do it . But i am in vein. If any one can't under stand my requirement please reply. Please help me to short out this problem in iReport. Thanks in advance.

Thank you very much for your reply. I am using java. But i have not got your point. Can you please make it clear to me. Also now I can convert the string value of last_computed_time and time _interval INTO Calender/DATE/TIME in this format. But i have to add time of time_interval with last_computed_time (i.e. it may add some day or some week or some hours etc). Actually in java I can do it useing add() and set() method of calender class. but in ireport I am getting problem . I need some thing like this Any help would be greatly appreciated. Thanks in advance. (fig-bellow) Post edited by: atanupanda, at: 2007/02/17 12:04

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. [file name=test-aa1036e8e0bb3b4b82231945ca0f6c33.doc size=39424]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/test-aa1036e8e0bb3b4b82231945ca0f6c33.doc[/file] size=159]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/graph-439cedbc282e8d547ecad5c72ae0ce79.JPG

atanupanda wrote: 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=150]C:/Documents and Settings/Atanu/My Documents/graph.GIF size=150]C:/Documents and Settings/Atanu/My Documents/graph.jpg Post edited by: atanupanda, at: 2007/02/15 12:01<br><br>Post edited by: atanupanda, at: 2007/02/15 12:03 [file name=test-f1fa25b59c277dca043a0a2c26776988.doc size=39424]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/test-f1fa25b59c277dca043a0a2c26776988.doc[/file] size=159]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/graph-ef6d08953afcf37e24588e29e03f6285.JPGPost edited by: atanupanda, at: 2007/02/15 12:08

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). 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 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 Please help me. Any help would be greatly appreciated. Thanks in advance. size=150C:Documents and SettingsAtanuMy Documentsgraph.jpeg[/img]