Skip to Content

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

To report this post you need to login first.

5 Comments

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

Leave a Reply