javabirt

How to add Serial Number column in BIRT

I want to add a serial number column in birt report.It should be reset based on grouping.How can i achieve this in BIRT?

Example:

| SerialNumber | Job Role | Employee       |
|              | role1    |                |
|       1      |          | Mickey Mouse   |
|       2      |          | Goofy          |
|       3      |          | Pluto          |
|              | role2    |                |
|       1      |          | Donald Duck    |
|              | role3    |                |
|       1      |          | Minnie Mouse   |
|       2      |          | Doctor Einmug  |
Solution

  • Serial Number may be a confusing word...
    I think you look for something like a Row Number that is reset to 1 for each group.

    Try this:

    in the Aggregation Binding Builder use these values:

    Column Binding Name:    SerialNumber
Data Type:              Float
Function:               RUNNINGSUM
Expression:             1
Aggregation On:         Group