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 Thread

View: Search:

Author

Thread: Exporting Crystal 8.5 Reports to Excel with Office 2007

Paul DeSaro
Posts: 13

Exporting Crystal 8.5 Reports to Excel with Office 2007 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Jul 07 7:42 AM

When an exported crystal 8.5 report to excel is opened in excel 2007 we get an error: "File Error: Data may have been lost".

The report doesn't lose any data but the error message is confusing to users. Is there an updated crystal .dll to use?

Also, I assume this will go away when we upgrade to 7.2 later this year.

Thanks,
Paul

[Reply][Quote]

John Gundrum
Posts: 632

Re: Exporting Crystal 8.5 Reports to Excel with Office 2007 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Jul 07 9:24 AM

What version of SLX are you currently using? Office 2007 is only certified for use with versions 6.2.5 and higher.

[Reply][Quote]

Paul DeSaro
Posts: 13

Re: Exporting Crystal 8.5 Reports to Excel with Office 2007 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Jul 07 12:20 PM

We are on 6.2.6. It only happens when a crystal report is exported to excel.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Exporting Crystal 8.5 Reports to Excel with Office 2007 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Jul 07 7:09 AM

Quote:

Originally posted by Paul DeSaro

We are on 6.2.6. It only happens when a crystal report is exported to excel.

Remember, Sage SalesLogix does NOT modify the Crystal reports "tools". Since you are on v6.2.6 SLX it's Crystal 8.5. Sounds like Crystal 8.5 is the real problem here. Did you check the Crystal (Business Objects) site to see if this is a KI?
--
rjl

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Exporting Crystal 8.5 Reports to Excel with Office 2007 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Jul 07 9:14 AM

Sounds more like an Excel error message (if you google it, you will find several matches, but I haven't found a given solution).

Also, it is possible that the file looks ok, but there might be in fact some data lost.

For instance, how many rows of data should have been exported to Excel?
What happens if you filter the report to only dump 1 record, does it also generate the same error?

Also, I am not sure how Crystal generates the Excel file. Since you are running 8.5, it is possible that it is generating an document of an Earlier version of Excel, and then once it is ready, it gets open with Excel 2007 because that is what you got installed.

[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 \|

page cache (param): 11/25/2024 11:24:43 AM