Archive for Crystal Report

Alternate Row Color in Crystal Report

In “Section Expert” select “Color” tab, then select “Background color” and put the following code:

if RecordNumber mod 2 = 0 then Color(233,233,233) else crNoColor

Advertisements

Leave a Comment

Reset record number by group in Crystal Report

numberVar numSlno = 0;

IF PREVIOUSISNULL({PAC_METRIC_SUMM_PROCESS_TIME_PACPROC.SEC}) THEN
numSlno := 1
else IF Previous ({PAC_METRIC_SUMM_PROCESS_TIME_PACPROC.SEC})<>{PAC_METRIC_SUMM_PROCESS_TIME_PACPROC.SEC} THEN
numSlno := 1
ELSE
numSlno := numSlno + 1

Comments (11)