Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Believe nothing no matter where you read it, or who said it, no matter if I have said it, unless it agrees with your own reason and common sense
 
Buddha
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

20
October

An issue with Exporting Crosstab to Excel from Crystal Reports

The issue:

The client had created a conditionally formatted cross-tab, that changed the background colours of the cells, depending on certain criteria in Crystal Reports.

When this report was exported to Microsoft Excel, some of the conditionally formatted cells was displayed with a black background.


The solution:

When the report was created in Crystal Reports, some of the conditional formatting colours used was customised, which when exported to Excel, the application could not understand, and hence recreate the same colours within the program.

To resolve this issue the conditonal colours was changed to more standard Microsoft Excel colours.



If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us

MAKE A COMMENT

Name *

Email Address *

Comment *