Auto Number Column

Hi,

I am new to BIRT and still have lots of things to learn. In one of my reports, I want a column with sequential numbers depending upon the items returned by the dataset. Is it possible to have such a auto number column in BIRT?

Regards,

Abhi

Find more posts tagged with

Comments

mwilliams

Hi Abhi,

If you're wanting to number the rows, all you need to do is create a computed column in your dataSet and use the aggregation of running count. This will create a column that numbers the rows from 1 to N.

abhipro

Hi mwilliams,

Thanks. This worked. I can now see the computed column with numbers being incremented at each row.

What I want to do is to be able to filter and display only the first 10 rows out of the entire result set returned.
I thought, if I can have the rows numbered, I can put a filter such as rownumber < 11 which would display rows with number 1 to 10.
When I use the following filter:
"row["Aggregation"] less than or equal 11", the report displays all the rows. Is something wrong with the way I am trying to access the row number generated in the computed columns?

Many Thanks,

Abhi

mwilliams

Abhi,

I'm guessing you figured this out based on other posts you've done. Let me know if I'm assuming wrong!