dhis2-users team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

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> 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/~dhis2-users>
> Post to     : dhis2-users@lists.launchpad.**net<dhis2-users@xxxxxxxxxxxxxxxxxxx>
> Unsubscribe : https://launchpad.net/~dhis2-**users<https://launchpad.net/~dhis2-users>
> More help   : https://help.launchpad.net/**ListHelp<https://help.launchpad.net/ListHelp>
>