Is there any way that one can filter the entries in the table of a standard report? For example, I have created a report template with data from the last 4 quarters, with a chart showing all four quarters data. However I only want to show the latest quarters data in the table underneath the chart (rather than all 4). I have been experimenting with the following in the field expression of the text fields in the table, but can't get it to work:
$F{passive rdt +ve rate} - Data field
$F{periodname} - Period quarters
$F{reporting_month_name} - Current quarter
Obviously I have totally made up the where and equals statement, but hopefully it gives the idea of what I am trying to do.... Any ideas if this is even possible?
Is there any way that one can filter the entries in the table of a standard report? For example, I have created a report template with data from the last 4 quarters, with a chart showing all four quarters data. However I only want to show the latest quarters data in the table underneath the chart (rather than all 4). I have been experimenting with the following in the field expression of the text fields in the table, but can’t get it to work:
Obviously I have totally made up the where and equals statement, but hopefully it gives the idea of what I am trying to do… Any ideas if this is even possible?
Hola! Thanks for the help - that was exactly what I wanted.
Cheers
Dan
···
On 19/10/12 11:41, Ola Hodne Titlestad wrote:
Hi Daniel,
You can use the Print When Expression property of the Detail band to filter the rows that are listed in the main table.
Ola
On 19 October 2012 11:25, Daniel Bridges <dbridges@akrosresearch.com>
wrote:
Is there any way that one can filter the entries in the table of a standard report? For example, I have created a report template with data from the last 4 quarters, with a chart showing all four quarters data. However I only want to show the latest quarters data in the table underneath the chart (rather than all 4). I have been experimenting with the following in the field expression of the text fields in the table, but can't get it to work:
$F{passive rdt +ve rate}.where($F{periodname}.equals($F{reporting_month_name}))
$F{passive rdt +ve rate} - Data field
$F{periodname} - Period quarters
$F{reporting_month_name} - Current quarter
Obviously I have totally made up the where and equals statement, but hopefully it gives the idea of what I am trying to do.... Any ideas if this is even possible?
Thanks in anticipation
Dan
_______________________________________________
Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/%7Edhis2-users)
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/%7Edhis2-users)
More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)