dhis2-users team mailing list archive

[Daniel Bridges <dbridges@xxxxxxxxxxxxxxxxx>]

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