dhis2-users team mailing list archive

[Daniel Bridges <dbridges@xxxxxxxxxxxxxxxxx>]

Ola,

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@xxxxxxxxxxxxxxxxx 
> <mailto:dbridges@xxxxxxxxxxxxxxxxx>> 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@xxxxxxxxxxxxxxxxxxx
>     <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
>     Unsubscribe : https://launchpad.net/~dhis2-users
>     <https://launchpad.net/%7Edhis2-users>
>     More help   : https://help.launchpad.net/ListHelp