Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Monday, November 25, 2024 
 
slxdeveloper.com Community Forums  
   
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
 Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to Reporting | New ThreadView:  Search:  
 Author  Thread: Formating colors not exporting from Crystal report to excel
Vimal-The Dude
Posts: 6
 
Formating colors not exporting from Crystal report to excelYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 18 Apr 07 1:03 AM
Hi All,

I have created a crystal report in which I have used a formatting formula like:-

"if {THG_DEFECT_TRACKER.STATUS} = "Waiting for Customer"
then Color (250, 150, 0) else
if {THG_DEFECT_TRACKER.STATUS} = "Open"
then Color (250, 150, 0) else
Color (0, 200, 0)"

I now have waiting and open tickets as orange and closed ones as green background colored tickets in Crystal report.
However, when I export it to excel I dont get any formatting done in it. The excel version just looks incomplete without formatting done.

Also please note that I am automating this report to be available to higher management via Knowledge Sync. Thus I will also have to have the full reporting available with all reqd formatting to be done in excel also.

Please advise on how can I obtain this.


Thanks!
-VIMAL
[Reply][Quote]
Vimal-The Dude
Posts: 6
 
Re: Formating colors not exporting from Crystal report to excelYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Apr 07 12:40 AM
Hi,

Can anyone please advise to my thread?


-VIMAL
[Reply][Quote]
Ryan Farley
Posts: 2265
slxdeveloper.com Site Administrator
Top 10 forum poster: 2265 posts
 
Re: Formating colors not exporting from Crystal report to excelYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Apr 07 2:04 AM
There's no way to customize the export process of Crystal. You'd have to write code to export the data to Excel and format accordingly using the Excel object model.
[Reply][Quote]
Vimal-The Dude
Posts: 6
 
Re: Formating colors not exporting from Crystal report to excelYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Apr 07 4:43 AM
Hi Ryan,

Can you please let me know as to how and what code can I write for this automation and how can I format using Excel Object model?

Thanks in advance!

-VIMAL
[Reply][Quote]
Ryan Farley
Posts: 2265
slxdeveloper.com Site Administrator
Top 10 forum poster: 2265 posts
 
Re: Formating colors not exporting from Crystal report to excelYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Apr 07 4:33 PM
fiogf49gjkf0d
You could see this to get started, maybe it could help: http://saleslogixblog.com/rfarley/archive/2004/10/13/1094.aspx

Basically, a google search for things like "Excel object model" or "Excel VBScript" will result in many good references, such as:

http://www.activexperts.com/activmonitor/windowsmanagement/scripts/msoffice/excel/
http://support.microsoft.com/kb/198703

etc.
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 11/25/2024 11:41:10 AM