# Report Table limiting by one dataelement category combination in DHIS2 2.3

Hello all

I am trying to create a report table where i can limit my report based on one of the dataelement category combination.

e.g creating a report on top 10 OPD diseases for <5years, and your elements for OPD have category combination (<5 and >5).

Currently the limit in the report table can limit based on the total from the dataelement category combination.

cheers

···

Wilfred F. Senyoni

Computer Science Department and Engineering
University of Dar es Salaam

Hi Wilfred,

your observation is correct, currently report table uses the right-most column for limit and sort operations.

We will try to improve this by allowing any column to be the base of limiting/sorting.

The challenge here is how to present this to the user in a understandable and generic way since report tables can be “pivoted” (use any combination of dimensions as “crosstab” columns) at any time…

Lars

···

On Mon, Jun 27, 2011 at 6:10 PM, wilfred senyoni senyoni@gmail.com wrote:

Hello all

I am trying to create a report table where i can limit my report based on one of the dataelement category combination.

e.g creating a report on top 10 OPD diseases for <5years, and your elements for OPD have category combination (<5 and >5).

Currently the limit in the report table can limit based on the total from the dataelement category combination.

cheers

Wilfred F. Senyoni

Computer Science Department and Engineering
University of Dar es Salaam

*Dear Lars,

I hope this limitation will be improved soon. Because in Sri Lanka I am working with many reports have dimensions. Before, I generated report using Excel report module but now I move to Report module and face this problem. I can’t get the fields with categories options to put in the ireport.

*Thủy

···

2011/6/29 Lars Helge Øverland larshelge@gmail.com

Hi Wilfred,

your observation is correct, currently report table uses the right-most column for limit and sort operations.

We will try to improve this by allowing any column to be the base of limiting/sorting.

The challenge here is how to present this to the user in a understandable and generic way since report tables can be “pivoted” (use any combination of dimensions as “crosstab” columns) at any time…

Lars

On Mon, Jun 27, 2011 at 6:10 PM, wilfred senyoni senyoni@gmail.com wrote:

Hello all

I am trying to create a report table where i can limit my report based on one of the dataelement category combination.

e.g creating a report on top 10 OPD diseases for <5years, and your elements for OPD have category combination (<5 and >5).

Currently the limit in the report table can limit based on the total from the dataelement category combination.

cheers

Wilfred F. Senyoni

Computer Science Department and Engineering
University of Dar es Salaam