subdataset parameters

nanako · August 6, 2007

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:

<![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>

<![CDATA[$F{exchange}]]>

</groupExpression>

</group>

</subDataset>

========================

</textElement>

</staticText>

</chart>

<![CDATA[$F{order_date}]]>

</datasetParameterExpression>

</datasetParameter>

<![CDATA[$F{order_date}]]>

</datasetParameterExpression>

</datasetParameter>

</datasetRun>

</dataset>

<seriesExpression>$F{exchange}</seriesExpression>

<timePeriodExpression>$F{order_date}</timePeriodExpression>

</timeSeries>

</timeSeriesDataset>

</timeSeriesChart>

</band>

</summary>

lucianc · August 6, 2007

nanako wrote:

and order_date<=$P{startdate}
and order_date>=$P{enddate}

I don't know what exactly are you trying to do, this this might be wrong. Isn't it supposed to be order_date >= $P{startdate} and order_date <= $P{enddate} (or order_date between $P{startdate} and $P{enddate} if you want to keep things simple)?

HTH,

Lucian

nanako · August 6, 2007

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

lucianc · August 6, 2007

nanako wrote:

And obviously the parameter values were not passed to the subdataset.

I'm not sure how is that so obvious.

I see that you have the chart in the summary band and you pass field values to the subdataset parameters (which is a little unusual). I suggest you to display the field values in a text field next to the chart (in the same band) so that actually you see the passed values.

Or if you have JR >= 1.2.8, add

Code:


log4j.logger.net.sf.jasperreports.engine.query.JRJdbcQueryExecuter=debug

to your log4j.properties (or the equivalent if you use another logging implementation) and JR will log the SQL query and its parameters.

Regards,

Lucian

nanako · August 6, 2007

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

lucianc · August 6, 2007

This case looks unusual because your chart will only use field values from the last record from the report's data source (given that there is at least one record in the data source, otherwise the fields will be null).

I'm afraid I can't tell you where to place your chart, since only you know what result you want to achieve.

Regards,

Lucian

nanako · August 6, 2007

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">

<![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>

<![CDATA[$F{exchange}]]>

</groupExpression>

</group>

</subDataset>

<![CDATA[select perf_bps, order_date,exchange from daily_perf

where algorithm_name='GSAT_Participate'

]]>

</queryString>

<![CDATA[$F{exchange}]]>

</groupExpression>

</group>

</subDataset>

<![CDATA[select perf_bps, order_date,exchange from daily_perf

where algorithm_name in('HullVWAP','HullVWAPBeta')

]]>

</queryString>

<![CDATA[$F{exchange}]]>

</groupExpression>

</group>

</subDataset>

<![CDATA[select perf_bps, order_date,exchange from daily_perf

where algorithm_name in('Participate','ParticipateBeta')

]]>

</queryString>

<![CDATA[$F{exchange}]]>

</groupExpression>

</group>

</subDataset>

<![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>

<![CDATA[$F{exchange}]]>

</groupExpression>

</textElement>

<text>History Performance in: </text>

</staticText>

<textFieldExpression>$F{exchange}</textFieldExpression>

</textField>

</band>

</groupHeader>

</group>

</textElement>

</staticText>

</textElement>

<text>Exchange</text>

</staticText>

</textElement>

<text>Order Date</text>

</staticText>

</textElement>

<text>Orders</text>

</staticText>

</textElement>

<text>Shares</text>

</staticText>

</textElement>

<text>Value(USD/mm)</text>

</staticText>

</textElement>

<text>Performance(bps)</text>

</staticText>

</textElement>

<text>Perf stddev(bps)</text>

</staticText>

</textElement>

<text>Duration</text>

</staticText>

</band>

</columnHeader>

<![CDATA[$F{algorithm_name}]]>

</textFieldExpression>

</textField>

<![CDATA[$F{exchange}]]>

</textFieldExpression>

</textField>

<![CDATA[$F{order_date}]]>

</textFieldExpression>

</textField>

<![CDATA[$F{order_count}]]>

</textFieldExpression>

</textField>

<![CDATA[$F{quantity}]]>

</textFieldExpression>

</textField>

<![CDATA[$F{value}]]>

</textFieldExpression>

</textField>

<![CDATA[$F{perf_bps}]]>

</textFieldExpression>

</textField>

<![CDATA[$F{perf_bps_stddev}]]>

</textFieldExpression>

</textField>

<![CDATA[$F{duration}]]>

</textFieldExpression>

</textField>

</band>

</detail>

</textElement>

</staticText>

</chart>

<![CDATA[$F{order_date}]]>

</datasetParameterExpression>

</datasetParameter>

<![CDATA[$F{order_date}]]>

</datasetParameterExpression>

</datasetParameter>

</datasetRun>

</dataset>

<seriesExpression>$F{exchange}</seriesExpression>

<timePeriodExpression>$F{order_date}</timePeriodExpression>

</timeSeries>

</timeSeriesDataset>

</timeSeriesChart>

</textElement>

<text>GSAT_Participate</text>

</staticText>

</chart>

</dataset>

<seriesExpression>$F{exchange}</seriesExpression>

<timePeriodExpression>$F{order_date}</timePeriodExpression>

</timeSeries>

</timeSeriesDataset>

</timeSeriesChart>

</textElement>

<text>HullVWAP</text>

</staticText>

</chart>

</dataset>

<seriesExpression>$F{exchange}</seriesExpression>

<timePeriodExpression>$F{order_date}</timePeriodExpression>

</timeSeries>

</timeSeriesDataset>

</timeSeriesChart>

</textElement>

<text>Participate</text>

</staticText>

</chart>

</dataset>

<seriesExpression>$F{exchange}</seriesExpression>

<timePeriodExpression>$F{order_date}</timePeriodExpression>

</timeSeries>

</timeSeriesDataset>

</timeSeriesChart>

</band>

</summary>

</jasperReport>

nanako · August 6, 2007

I did another test.

<![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.

nanako · August 6, 2007

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!!!!

Sign In

subdataset parameters

Recommended Posts

nanako

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

lucianc

Link to comment

Share on other sites

nanako

Link to comment

Share on other sites

lucianc

Link to comment

Share on other sites

nanako

Link to comment

Share on other sites

lucianc

Link to comment

Share on other sites

nanako

Link to comment

Share on other sites

nanako

Link to comment

Share on other sites

nanako

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore