print line number not the record number in Crystal report

[143Aroul]

Hi

i have designed a report in Crystal report with one grouping say Department. i want to print the line number of all the records, once dapartment change print the total and initialise the line number from 1.

the output shoule be

line number Employee Name
Accounts- Department
========
1 Raja
2 kumear
--------------------
total 2
--------------------
Purchase -Department
====================
1 aroul
2 kanda
3 rajan
-----------
total 3
----------

how to do it in Crystal report

 

[synapsevampire]

I think that a Running Total suits this well by having the RT count some field, and reset at the change of dept group.

Place it in the Details to show it's running total property, and then place it again in the group footer to show the total for that group.

You could also use the 3 formula method, but why bother.

-k

 

[143Aroul]

Thanks It works