how to find first record from group in crystal reports?

Question

how to find first record from group in crystal reports?

Answer 1

You can use the Previous(Group_Field) function in a formula to indicate the start the group. The Online formula function help gives an example. Basically you see if the Previous value of the field you are grouping on is different from the current value. If it is, then you have just started a new group.

If Previous ({table.GroupingField}) = ({table.GroupingField}) Then 
    False
Else
    True

Answer 2

this does not work if you have only one record in the group

Answer 3

strong text

Blockquotehhfghfghffghfghf![alt text][1]

Answer 4

You can use: NthSmallest (1, {yourField},{theGrouping}) Or NthLargest (1, {yourField},{theGrouping})

Works like a charm