How to do a row count in BIRT

vidu

Hi

I'm displaying set of data something like this

NO BATCH NO COMP.NAME RECORD START TIME

35300694 SHONDAI CO LTD 2007-11-07 00:00:00
35300694 SHONDAI CO LTD 2007-11-07 00:00:00
35300064 GLOBAL EXP 2007-11-09 00:00:00
35300694 SHONDAI CO LTD 2007-11-07 00:00:00
now if i need to put numbers for this rows that the qury returns how do i do this
?

please help

vidu

mwilliams

Hi vidu,

Go to your dataSet Editor, create a computed column, choose Integer as the type and choose an aggregation of running count. This will count the lines in the dataSet for you giving you a row number as long as the data is sorted how you want it when it comes in.