Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: CR 11.5 R2 Export Excel Post Reply Post New Topic
Author Message
Gary P.
Newbie
Newbie


Joined: 16 Mar 2009
Location: United States
Online Status: Offline
Posts: 2
Quote Gary P. Replybullet Topic: CR 11.5 R2 Export Excel
    Posted: 16 Mar 2009 at 9:53am
Anybody know what is needed to be able to export to the new Office 2007 XLSX format?

We have an issue with the 65532 row limit in Office 2003/XP.

Gary
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 16 Mar 2009 at 1:08pm
AFAIK, at this point you can't.  Crystal 2008 changes the Excel export option to include 2003, but it uses the "lowest common denominator" export which means that it follows the row restrictions of the earlier versions.
 
Also, I believe Office XP is 2002 and the 65,532 row limit is in versions of Office earlier than 2003  - I used to have Office XP installed but had to upgrade it to 2003 in order to be able to use XML data sets with Xcelsius.
 
One possible way to get around this would be to export to a .csv file and then open that in Excel.  However, you have to be careful about how you format your data in order for it to export cleanly.
 
-Dell
IP IP Logged
Gary P.
Newbie
Newbie


Joined: 16 Mar 2009
Location: United States
Online Status: Offline
Posts: 2
Quote Gary P. Replybullet Posted: 16 Mar 2009 at 4:38pm
hilfy, thanks suspected so much.  I guess Office 2007 has not been out long enough :-)
It like trying to run the CRViewer Web on a x64 system - you have to switch IIS to 32bit mode.
You would think the BO would be more on top of technology.

Gary
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.