nanako

up~up~~ Really grateful anyone can help me out. It's too weird. I cann't find anything wrong. Thanks Ivy

sorry, foget to mention. I'm using the sybase database. Any idea as how to do with sybase. Thanks Nanako

Thanks Takashi. For the below query, currently there is no data displayed in the chart, i.e. i get an empty chart ====================== select perf_bps,order_date,exchange from daily_perf where algorithm_name='GSAT_VWAP' and order_date>=$P{startdate} and order_date<=$P{enddate} group by order_date <timeSeriesDataset> <dataset> <datasetRun subDataset="history_perf"> <datasetParameter name="startdate"> <datasetParameterExpression> <![CDATA[$F{order_date}]]> </datasetParameterExpression> </datasetParameter> <datasetParameter name="enddate"> <datasetParameterExpression> <![CDATA[$F{order_date}]]> </datasetParameterExpression> </datasetParameter> </datasetRun> </dataset> ===Bur if I change the sql to select perf_bps,order_date,exchange from daily_perf where algorithm_name='GSAT_VWAP' and order_date>=$P{startdate} group by order_date ===or select perf_bps,order_date,exchange from daily_perf where algorithm_name='GSAT_VWAP' and order_date<=$P{enddate} group by order_date The chart is not empty anymore, but the problem is both $P{startdate} $P{enddate} takes the value of the parameter $P{orderdate} which should be only used in the table query as follows: select algorithm_name, exchange, order_date, order_count, quantity, value, perf_bps, perf_bps_stddev, duration from daily_perf where order_date=$P{orderdate} order by exchange

I think that's the problem too. But I need to desginate the startdate and enddate of data to display to the chart, which corresponds to the field $F{order_date} And the query is <subDataset name="history_perf"> <parameter name="startdate" class="java.util.Date"/> <parameter name="enddate" class="java.util.Date"/> <queryString> <![CDATA[select perf_bps,order_date,exchange from daily_perf where algorithm_name='GSAT_VWAP' and order_date>=$P{startdate} and order_date<=$P{enddate} group by order_date ]]> </queryString> <field name="exchange" class="java.lang.String" /> <field name="perf_bps" class="java.lang.Double"/> <field name="order_date" class="java.util.Date"/> <group name="exchangeGroup"> <groupExpression> <![CDATA[$F{exchange}]]> </groupExpression> </group> </subDataset> ==== How can I change, thanks~~

I did another experiment, change as follows: <timeSeriesChart> <chart evaluationTime="Report"> <reportElement mode="Opaque" x="0" y="14" width="750" height="175" /> </chart> <timeSeriesDataset> <dataset> <datasetRun subDataset="history_perf"> <datasetParameter name="startdate"> <datasetParameterExpression> <![CDATA[$P{startdate}]]> </datasetParameterExpression> </datasetParameter> <datasetParameter name="enddate"> <datasetParameterExpression> <![CDATA[$P{enddate}]]> </datasetParameterExpression> </datasetParameter> </datasetRun> </dataset> <timeSeries> <seriesExpression>$F{exchange}</seriesExpression> <timePeriodExpression>$F{order_date}</timePeriodExpression> <valueExpression>$F{perf_bps}</valueExpression> <labelExpression></labelExpression> </timeSeries> </timeSeriesDataset> <timeSeriesPlot> <plot/></timeSeriesPlot> </timeSeriesChart> ================ But the error msg is [java] net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : [java] 1. Parameter not found : startdate [java] 2. Parameter not found : enddate anyone can help, whether i should put parameter or field here, currently both ways don't work

It works!!!!!! Thanks! I'm just being to careless. I was overwhelmed by bugs these days. Thank again Takashi san.

I'll be really greatful if anyone can give me a hint. My project deadline is very close, I tried various way but still cannt solve the prolbem. The question is as follows: I intend to generate a table and 4 charts in a table. I used 5 different query, one for the table and 4 for the charts. All the queries take parameters which corresponds to the $F{order_date} field as follows: And it seems to me as all the parmeters corresponds to $F{order_date}, that's something wrong, I guess. ====Chart===== <subDataset name="history_perf"> <parameter name="startdate" class="java.util.Date"/> <parameter name="enddate" class="java.util.Date"/> <queryString> <![CDATA[select perf_bps,order_date,exchange from daily_perf where algorithm_name='GSAT_VWAP' and order_date>=$P{startdate} and order_date<=$P{enddate} group by order_date ]]> </queryString> <field name="exchange" class="java.lang.String" /> <field name="perf_bps" class="java.lang.Double"/> <field name="order_date" class="java.util.Date"/> <group name="exchangeGroup"> <groupExpression> <![CDATA[$F{exchange}]]> </groupExpression> </group> </subDataset> <timeSeriesChart> <chart evaluationTime="Report"> <reportElement mode="Opaque" x="0" y="14" width="750" height="175" /> </chart> <timeSeriesDataset> <dataset> <datasetRun subDataset="history_perf"> <datasetParameter name="startdate"> <datasetParameterExpression> <![CDATA[$F{order_date}]]> </datasetParameterExpression> </datasetParameter> <datasetParameter name="enddate"> <datasetParameterExpression> <![CDATA[$F{order_date}]]> </datasetParameterExpression> </datasetParameter> </datasetRun> </dataset> <timeSeries> <seriesExpression>$F{exchange}</seriesExpression> <timePeriodExpression>$F{order_date}</timePeriodExpression> <valueExpression>$F{perf_bps}</valueExpression> <labelExpression></labelExpression> </timeSeries> </timeSeriesDataset> <timeSeriesPlot> <plot/></timeSeriesPlot> </timeSeriesChart> =======table query <parameter name="orderdate" class="java.util.Date"/> <queryString> <![CDATA[select algorithm_name, exchange, order_date, order_count, quantity, value, perf_bps, perf_bps_stddev, duration from daily_perf where order_date=$P{orderdate} order by exchange]]> </queryString>

I tried to change the font size of the Footer, I did the follows. But after the change, the text "AEJ CIPHER PERFORMANCE CHART" can't display in the report. It's really weird, and I have met numerous question like this. Really grateful if anyone can help me out. Thanks!!!!! ========================== <columnFooter> <band height="14"> <staticText> <reportElement mode="Opaque" forecolor="#000000" x="200" y="0" width="400" height="14"/> <textElement textAlignment="Center" isStyledText="true"> <font isBold="true" size="18"/> </textElement> <text><![CDATA[AEJ CIPHER PERFORMANCE CHART]]></text> </staticText> </band> </columnFooter>

Oh, who can help me! I just cann't figure out why the value cann't be passed to $P{startdate},$P{enddate} But the value can be passed to $P{orderdate} Is there anything with the java code? ================ HashMap parameterMap=new HashMap(); parameterMap.put("orderdate", string2Time(orderDate)); parameterMap.put("startdate", string2Time(startDate)); parameterMap.put("enddate", string2Time(endDate)); System.out.println("Report Date:" + string2Time(orderDate)); System.out.println("Start Date:" + string2Time(startDate)); System.out.println("End Date:" + string2Time(endDate)); System.out.println("Filling report..."); System.setProperty("java.awt.headless","true"); JasperFillManager.fillReportToFile(REPORT_DIRECTORY + "/" + reportName + ".jasper", parameterMap, conn); Thanks!!!!

I did another test. <subDataset name="history_perf"> <parameter name="startdate" class="java.util.Date"/> <parameter name="enddate" class="java.util.Date"/> <queryString> <![CDATA[select perf_bps, order_date,exchange from daily_perf where algorithm_name='GSAT_VWAP' and order_date>=$P{startdate} group by order_date ]]> </queryString> ====== I replace order_date<=$P{enddate} with order_date>=$P{startdate. The result is the same, the value of enddate wasn't passed to the query. but the value of ${orderdate} was pass to the query. Really weird.

Thanks Lucian!! The following is the complete template. Actually there are 4 charts to be generated. Every chart displays the peformance of a specific trading algorithm in the market. I intend to designate the period of the data I wanna see the chart, that's why I have the startdate and enddate parameter. But the problem is these two parameters values cann't be passed to the subdataset query. Currently I only assign parameters to subdataset1 for testing purpose. The chart can be generated but it didn't take the value of $P{enddate}. but the value of $P{orderdate} =================================================== <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport leftMargin="0" name="TestReport"> <style name="parentStyle" isDefault="true" fontName="Arial" fontSize="11" forecolor="black"/> <style name="ColumnHeadStyle" fontSize="14" isBold="true" fontName="Arial" forecolor="#ffffff" backcolor="#70DEDE"/> <style name="ColumnStyle" fontSize="9" forecolor="red"/> <subDataset name="history_perf"> <parameter name="startdate" class="java.util.Date"/> <parameter name="enddate" class="java.util.Date"/> <queryString> <![CDATA[select perf_bps, order_date,exchange from daily_perf where algorithm_name='GSAT_VWAP' and order_date <=$P{enddate} group by order_date ]]> </queryString> <field name="exchange" class="java.lang.String" /> <field name="perf_bps" class="java.lang.Double"/> <field name="order_date" class="java.util.Date"/> <group name="exchangeGroup"> <groupExpression> <![CDATA[$F{exchange}]]> </groupExpression> </group> </subDataset> <subDataset name="history_perf2"> <queryString> <![CDATA[select perf_bps, order_date,exchange from daily_perf where algorithm_name='GSAT_Participate' ]]> </queryString> <field name="exchange" class="java.lang.String" /> <field name="perf_bps" class="java.lang.Double"/> <field name="order_date" class="java.util.Date"/> <group name="exchangeGroup"> <groupExpression> <![CDATA[$F{exchange}]]> </groupExpression> </group> </subDataset> <subDataset name="history_perf3"> <queryString> <![CDATA[select perf_bps, order_date,exchange from daily_perf where algorithm_name in('HullVWAP','HullVWAPBeta') ]]> </queryString> <field name="exchange" class="java.lang.String" /> <field name="perf_bps" class="java.lang.Double"/> <field name="order_date" class="java.util.Date"/> <group name="exchangeGroup"> <groupExpression> <![CDATA[$F{exchange}]]> </groupExpression> </group> </subDataset> <subDataset name="history_perf4"> <queryString> <![CDATA[select perf_bps, order_date,exchange from daily_perf where algorithm_name in('Participate','ParticipateBeta') ]]> </queryString> <field name="exchange" class="java.lang.String" /> <field name="perf_bps" class="java.lang.Double"/> <field name="order_date" class="java.util.Date"/> <group name="exchangeGroup"> <groupExpression> <![CDATA[$F{exchange}]]> </groupExpression> </group> </subDataset> <parameter name="orderdate" class="java.sql.Timestamp"/> <queryString> <![CDATA[select algorithm_name, exchange, order_date, order_count, quantity, value, perf_bps, perf_bps_stddev, duration from daily_perf where order_date=$P{orderdate} order by exchange]]> </queryString> <field name="algorithm_name" class="java.lang.String" /> <field name="exchange" class="java.lang.String" /> <field name="order_date" class="java.util.Date"/> <field name="order_count" class="java.lang.Integer"/> <field name="quantity" class="java.lang.Double"/> <field name="value" class="java.lang.Double"/> <field name="perf_bps" class="java.lang.Double"/> <field name="perf_bps_stddev" class="java.lang.Double"/> <field name="duration" class="java.lang.Double"/> <group name="MarketGroup"> <groupExpression> <![CDATA[$F{exchange}]]> </groupExpression> <groupHeader> <band height="40"> <staticText> <reportElement x="0" y="10" width="130" height="20"/> <textElement> <font isBold="true"/> </textElement> <text>History Performance in: </text> </staticText> <textField> <reportElement x="130" y="10" width="40" height="20"/> <textFieldExpression>$F{exchange}</textFieldExpression> </textField> </band> </groupHeader> </group> <columnHeader> <band height="14"> <staticText> <reportElement mode="Opaque" forecolor="#ffffff" backcolor="#70DEDE" x="0" y="0" width="110" height="14"/> <textElement isStyledText="true"> <font isBold="true"/> </textElement> <text><![CDATA[Algorithm]]></text> </staticText> <staticText> <reportElement mode="Opaque" forecolor="#ffffff" backcolor="#70DEDE" x="110" y="0" width="60" height="14" /> <textElement> <font isBold="true"/> </textElement> <text>Exchange</text> </staticText> <staticText> <reportElement mode="Opaque" forecolor="#ffffff" backcolor="#70DEDE" x="170" y="0" width="79" height="14" /> <textElement> <font isBold="true"/> </textElement> <text>Order Date</text> </staticText> <staticText> <reportElement mode="Opaque" forecolor="#ffffff" backcolor="#70DEDE" x="249" y="0" width="60" height="14" /> <textElement> <font isBold="true"/> </textElement> <text>Orders</text> </staticText> <staticText> <reportElement mode="Opaque" forecolor="#ffffff" backcolor="#70DEDE" x="309" y="0" width="100" height="14" /> <textElement> <font isBold="true"/> </textElement> <text>Shares</text> </staticText> <staticText> <reportElement mode="Opaque" forecolor="#ffffff" backcolor="#70DEDE" x="409" y="0" width="120" height="14" /> <textElement> <font isBold="true"/> </textElement> <text>Value(USD/mm)</text> </staticText> <staticText> <reportElement mode="Opaque" forecolor="#ffffff" backcolor="#70DEDE" x="529" y="0" width="109" height="14" /> <textElement> <font isBold="true"/> </textElement> <text>Performance(bps)</text> </staticText> <staticText> <reportElement mode="Opaque" forecolor="#ffffff" backcolor="#70DEDE" x="638" y="0" width="110" height="14" /> <textElement> <font isBold="true"/> </textElement> <text>Perf stddev(bps)</text> </staticText> <staticText> <reportElement mode="Opaque" forecolor="#ffffff" backcolor="#70DEDE" x="748" y="0" width="80" height="14" /> <textElement> <font isBold="true"/> </textElement> <text>Duration</text> </staticText> </band> </columnHeader> <detail> <band height="14"> <textField> <reportElement x="0" y="0" width="110" height="14"/> <textFieldExpression class="java.lang.String"> <![CDATA[$F{algorithm_name}]]> </textFieldExpression> </textField> <textField> <reportElement x="110" y="0" width="50" height="14"/> <textFieldExpression class="java.lang.String"> <![CDATA[$F{exchange}]]> </textFieldExpression> </textField> <textField> <reportElement x="170" y="0" width="79" height="14" /> <textFieldExpression class="java.util.Date"> <![CDATA[$F{order_date}]]> </textFieldExpression> </textField> <textField> <reportElement x="249" y="0" width="60" height="14" /> <textFieldExpression class="java.lang.Integer"> <![CDATA[$F{order_count}]]> </textFieldExpression> </textField> <textField> <reportElement x="309" y="0" width="100" height="14" /> <textFieldExpression class="java.lang.Double"> <![CDATA[$F{quantity}]]> </textFieldExpression> </textField> <textField> <reportElement x="409" y="0" width="89" height="14" /> <textFieldExpression class="java.lang.Double"> <![CDATA[$F{value}]]> </textFieldExpression> </textField> <textField> <reportElement x="529" y="0" width="89" height="14" /> <textFieldExpression class="java.lang.Double"> <![CDATA[$F{perf_bps}]]> </textFieldExpression> </textField> <textField> <reportElement x="638" y="0" width="110" height="14" /> <textFieldExpression class="java.lang.Double"> <![CDATA[$F{perf_bps_stddev}]]> </textFieldExpression> </textField> <textField> <reportElement x="748" y="0" width="80" height="14" /> <textFieldExpression class="java.lang.Double"> <![CDATA[$F{duration}]]> </textFieldExpression> </textField> </band> </detail> <summary> <band height="756"> <staticText> <reportElement x="0" y="0" width="100" height="14" /> <textElement> <font isBold="true"/> </textElement> <text>GSAT_VWAP</text> </staticText> <timeSeriesChart> <chart evaluationTime="Report"> <reportElement mode="Opaque" x="0" y="14" width="750" height="175" /> </chart> <timeSeriesDataset> <dataset> <datasetRun subDataset="history_perf"> <datasetParameter name="startdate"> <datasetParameterExpression> <![CDATA[$F{order_date}]]> </datasetParameterExpression> </datasetParameter> <datasetParameter name="enddate"> <datasetParameterExpression> <![CDATA[$F{order_date}]]> </datasetParameterExpression> </datasetParameter> </datasetRun> </dataset> <timeSeries> <seriesExpression>$F{exchange}</seriesExpression> <timePeriodExpression>$F{order_date}</timePeriodExpression> <valueExpression>$F{perf_bps}</valueExpression> <labelExpression></labelExpression> </timeSeries> </timeSeriesDataset> <timeSeriesPlot> <plot/></timeSeriesPlot> </timeSeriesChart> <staticText> <reportElement x="0" y="189" width="100" height="14" /> <textElement> <font isBold="true"/> </textElement> <text>GSAT_Participate</text> </staticText> <timeSeriesChart> <chart evaluationTime="Report"> <reportElement mode="Opaque" x="0" y="203" width="750" height="175" /> </chart> <timeSeriesDataset> <dataset> <datasetRun subDataset="history_perf2"></datasetRun> </dataset> <timeSeries> <seriesExpression>$F{exchange}</seriesExpression> <timePeriodExpression>$F{order_date}</timePeriodExpression> <valueExpression>$F{perf_bps}</valueExpression> <labelExpression></labelExpression> </timeSeries> </timeSeriesDataset> <timeSeriesPlot> <plot/></timeSeriesPlot> </timeSeriesChart> <staticText> <reportElement x="0" y="378" width="100" height="14" /> <textElement> <font isBold="true"/> </textElement> <text>HullVWAP</text> </staticText> <timeSeriesChart> <chart evaluationTime="Report"> <reportElement mode="Opaque" x="0" y="392" width="750" height="175" /> </chart> <timeSeriesDataset> <dataset> <datasetRun subDataset="history_perf3"></datasetRun> </dataset> <timeSeries> <seriesExpression>$F{exchange}</seriesExpression> <timePeriodExpression>$F{order_date}</timePeriodExpression> <valueExpression>$F{perf_bps}</valueExpression> <labelExpression></labelExpression> </timeSeries> </timeSeriesDataset> <timeSeriesPlot> <plot/></timeSeriesPlot> </timeSeriesChart> <staticText> <reportElement x="0" y="567" width="100" height="14" /> <textElement> <font isBold="true"/> </textElement> <text>Participate</text> </staticText> <timeSeriesChart> <chart evaluationTime="Report"> <reportElement mode="Opaque" x="0" y="581" width="750" height="175" /> </chart> <timeSeriesDataset> <dataset> <datasetRun subDataset="history_perf4"></datasetRun> </dataset> <timeSeries> <seriesExpression>$F{exchange}</seriesExpression> <timePeriodExpression>$F{order_date}</timePeriodExpression> <valueExpression>$F{perf_bps}</valueExpression> <labelExpression></labelExpression> </timeSeries> </timeSeriesDataset> <timeSeriesPlot> <plot/></timeSeriesPlot> </timeSeriesChart> </band> </summary> </jasperReport>

Thanks,Lucian!! I much prefer the first way. But could you explain to me a bit more detailed. What do you mean by "unusual". Shall I put the chart in the same band with the report? Thanks Nanako

thanks! I have found the careless mistake by myself, and corrected it. But the problem still exists. And obviously the parameter values were not passed to the subdataset. I have double check my template, cann't find anything wrong. Thanks a lot if anyone could help

Thanks in advance for any help. I have been fighting with the proble for a log time. I need to pass two parmaters two the subdataset and form a chart. But generated chart is empty, the parmater is not passed to the query. My template is as follows: <subDataset name="history_perf"> <parameter name="startdate" class="java.sql.Timestamp"/> <parameter name="enddate" class="java.sql.Timestamp"/> <queryString> <![CDATA[select perf_bps, order_date,exchange from daily_perf where algorithm_name='GSAT_VWAP' and order_date<=$P{startdate} and order_date>=$P{enddate} group by order_date ]]> </queryString> <field name="exchange" class="java.lang.String" /> <field name="perf_bps" class="java.lang.Double"/> <field name="order_date" class="java.sql.Timestamp"/> <group name="exchangeGroup"> <groupExpression> <![CDATA[$F{exchange}]]> </groupExpression> </group> </subDataset> ======================== <summary> <band height="756"> <staticText> <reportElement x="0" y="0" width="100" height="14" /> <textElement> <font isBold="true"/> </textElement> <text>GSAT_VWAP</text> </staticText> <timeSeriesChart> <chart evaluationTime="Report"> <reportElement mode="Opaque" x="0" y="14" width="750" height="175" /> </chart> <timeSeriesDataset> <dataset> <datasetRun subDataset="history_perf"> <datasetParameter name="startdate"> <datasetParameterExpression> <![CDATA[$F{order_date}]]> </datasetParameterExpression> </datasetParameter> <datasetParameter name="enddate"> <datasetParameterExpression> <![CDATA[$F{order_date}]]> </datasetParameterExpression> </datasetParameter> </datasetRun> </dataset> <timeSeries> <seriesExpression>$F{exchange}</seriesExpression> <timePeriodExpression>$F{order_date}</timePeriodExpression> <valueExpression>$F{perf_bps}</valueExpression> <labelExpression></labelExpression> </timeSeries> </timeSeriesDataset> <timeSeriesPlot> <plot/></timeSeriesPlot> </timeSeriesChart> </band> </summary>

I export the report into html page and there is a chart in this html. If you see the chart image alone(I mean in the folder it is generated), its background color is white. But when the image background color is gray in the html page, its wierd. Does anyone know why? thanks