How do I get 1st and last row value of a column in a group

[rkgrp]

Hi All,

Scenario : Report with 2 level groups.
I need to display one column (say Col A) value at 1st row and last row on the header.

Eg:
Col A - value at 1st row : F111
Col A - value at last row : L999

Header
------
Number (F111 thru L999)

Detail
------
Row 1
Row 2
-
-
-
Row 9


Thanks in advance

rk

 

[Madawc]

I'm not clear what you're asking for. In Crystal 8.5 you can get minimum and maximum as summary totals. (Right click, insert, summary). For a group, summary totals are calculated before the header is printed, unlike running totals.

If it is the first and last with an unpredictable value, it's rather harder. You could do a pair of subreports, which return the value that would be first and the value which would be last, based on the same criteria as your main report. This is slow but does work.

Madawc Williams
East Anglia, Great Britain