Skip to Content

Workaround of Alternate row color will run throughout the excel when exported

When Crystal Report is Exported to EXCEL. Alternate row color will run through out the excel as show in Screen Shots.

Screen.jpg

Workaround:

1. Instead of giving background color to detail section as shown in the screenshot.

          if (RecordNumber mod 2)=0 Then crSilver else crNoColor

Screen.jpg

2. Give the background color for each variable as shown in the screen shot with the formula

               if (RecordNumber mod 2)=0 Then crSilver else crNoColor

Screen.jpg

3. After exported to excel looks as shown in the screen shot.

Screen.jpg

5 Comments
You must be Logged on to comment or reply to a post.