i'm new to CR. I have an excel sheet (log file) with 'amount' as a column.

 

My intention is to sum amount column basing on certain other column values and populate in one field, in report output!

 

i know we can achieve through DO WILE or LOOP constructs, but does Crystal reports provides any file management commands?

 

example:

 

LOOP <till End of File>

 

IF column3 := 'Value'

then sum amount column

 

ENDLOOP

 

This is very basic file management construct which I am not able to find !

 

any help is much appreciated.

 

Thanks