how do i restart the numbering of the record number special field on change of group

i mean when a new group is shown i want the sr no to start from 1 again and not the record count

pls advice..
suneeta

__________________
.Net developer

hi

i also had the same prob
create a dummy Field in ur view (from which u r creating ur report).
e.g.,Select <field list>..., 1 as DummyRecordNo From TableName

then in ur report create a Running Total (SUM) on the DummyRecordNo and Reset it on change of group

i hope it will help :-)

Hi ,

I had the same problem. In cristal report goto "Run Time Totals" (under Insert>Field Objects). Create a new running total field (Eg. SeqNo). Take a field from left pannel (ie.Available Tables and Fields) then choose "Count" in type of summery. then select "On Change of Group" and select the appropriate group which you have already craeted. Use this field as the Sequence field which changes on the change of particular group.

Channa - Sri Lanka