Background colour when exporting to excel
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17904
Printed Date: 20 Apr 2025 at 10:56pm
Topic: Background colour when exporting to excel
Posted By: Barb
Subject: Background colour when exporting to excel
Date Posted: 01 Nov 2012 at 10:50am
Hi there
Would appreciate your help with background colouring.
I have a report and I'm using background colours for header, totals and footer rows. When exporting my report to excel the background colour on those rows never ends. I would like the background colour to finish on the last column, is there anyway I can do it?
Please help
Thank you Barb
-------------
Many thanks
Barb
|
Replies:
Posted By: hilfy
Date Posted: 12 Nov 2012 at 10:45am
|
The only way to do this would be to color the individual text objects in the rows instead of the rows in the report. Then, to get the continuous color across, you would have to make sure that the left of each object starts at the end of the previous object (I usually use the guides on the ruler at the top of the page to do this.) -Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|