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
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.
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