CODEWITHSUNDEEP
birt
MChiru
MChiru

Reputation: 79

BIRT : Sort a Table based on Multiple Columns

I have a BIRT report generated from a JAVA POJO data source.

 Interface | column1 | column2 |
+----------+---------+---------+
|          |         |         |

I want to sort the rows of the Table given above, based on the sum of 2 columns column1 and column2 And then display the top 10 rows.

In the Sorting Tab, I've used for the expression: row["column1"]+row["column2"] and in the Filters Tab, I've put the expression row["column1"]+row["column2"], Operator as Top n and Value1 as 10. But I'm not getting the desired result

Upvotes: 0

Views: 1367

Answers (1)

MChiru
MChiru

Reputation: 79

I am posting this Answer so that it might be useful to a lot of BIRT beginners

  1. Create a new Column Binding with the Expression : ( row["column1"]+row["column2"] )
  2. Sort the Table based on the binding.

Upvotes: 0

Related Questions