Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Do what you can, with what you have, where you are
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!!!!


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


Name *

Email Address *

Comment *

To prove you are human what is:

74 + 64 =