Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Export to an Excel Template? Post Reply Post New Topic
Author Message
birchw
Newbie
Newbie


Joined: 20 Mar 2009
Online Status: Offline
Posts: 4
Quote birchw Replybullet Topic: Export to an Excel Template?
    Posted: 03 Jun 2009 at 3:38am
Hi,
 
I have a crystal report which I would like to be able to export to a pre-saved Excel template, i.e. the first 10 columns contain the data and the next 10 columns contain formulas based upon the data imported into the spreadsheet.  Is this possible?  I know it's easy enough to export to Excel, but it always creates a new file.  I'm guessing it's something I would probably need to tackle using VBA.
 
The version of Crystal is v10 and the data is coming from SQL Server 2000.
 
Thanks
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 08 Jun 2009 at 12:53pm
You might be able to do it using VBA, but I doubt it.  The Excel export functionality is limited and there are few, if any, ways to customize the export.
 
You may be able to put the formulas in your report instead of in Excel and then export.
 
-Dell
IP IP Logged
birchw
Newbie
Newbie


Joined: 20 Mar 2009
Online Status: Offline
Posts: 4
Quote birchw Replybullet Posted: 15 Jun 2009 at 8:50am
Thanks for your input.  I'll have a play with VBA, and if I come up with a solution I will post it here.  I think I'm probably going to have to bite the bullet though and add 50+ formulas to the report!
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.031 seconds.