Serial Number and Alternate row Color in Crystal Report

In this blog we will learn adding Serial number and apply alternate row color in Crystal Report.

If you haven’t had a look at the first, then please click here: Crystal Report Using Stored Procedure

 

Adding Serial number in Crystal Report

 

Create new Formula Field by right clicking on Formula field tab from Field Explorer.

 

 

 

Give a name 'SrNo' and click Ok.

 

 

 

In this formula workshop for the Field 'SrNo' declare variable numbervar 'srno' and increment it (srno:= srno+1;) in a while loop 'WhilePrintingRecords' . 

WhilePrintingRecords;
numbervar srno;
srno := srno + 1;

So for each record in details section it will increase the number by 1. 

 

 

 Drag and drop the Formula in details section 

 

 

Save the report and click on mail report Preview, it will display running Serial Number in detail section.

 

 

Adding alternate row color in Crystal Report 

 

now click on Crystal Report - > Report -> Section Export and go to detail section and click on Color tab.

 

 

 

Add formula like:

 

if RecordNumber Mod 2 = 0 Then crSilver else crblue 

 

So if the mode is zero then apply color 'Silver' else 'Blue' 

 

 

 

Run the report and check the data by clicking on 'Main Report Preview'.