How to give SL NO for rows in a group ?

[Guest_imported]

I have a report of employees group by department.
I want to give serial numberes for employees in each group(department).The serial number under each group should start from 1.
for eg
The report should be as shown below


Accounts
1)----------
2)----------
3)-----------
Finance
1)-------------
2)------------
3)------------
sales
1)----------
2)-----------
3)-----------

 

[scottrodriguez]

Hi,

Include a "computed-column" in your SQL-Select statement such as:

1 AS SNO


This computed-column is repeated for each row with a value of 1 when you retrieve data. Now, remove the computed-column from the layout and add a "computed-field" in the detail band with the expression:

CumulativeSum( SNO for Group <n> )


That should work.

Regards,

Scott
-----------------------------------------

http://groups.yahoo.com/group/PowerObject