| Author |
Message |
chitz
Newbie
Joined: 26 Dec 2007
Online Status: Offline
Posts: 32
|
   Topic: Code for exprting to excel
Posted: 27 Jan 2008 at 10:39pm |
|
Plzzzzzz...Any body help me by pasting the code for exporting a CR ti excel Sheet in VB.NET. Its urgent...Thanks in advance
|
 IP Logged |
|
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
|
Posted: 29 Jan 2008 at 9:55am |
You can find sample code in the Developer Library. For Crystal XI R2, it's here:
Click on Crystal Reports .NET SDK, then on .NET Developer Guide and API Reference, then on Tutorials and Sample Code, then Report Document Object Model. You'll find what you're looking for there.
-Dell
|
|
|
|
IP Logged |
|
IdoMillet
Groupie
Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 99
|
Posted: 16 Feb 2008 at 7:00pm |
|
Please clarify: do you need to export to a new excel workbook or to an excel sheet inside an existing workbook?
- Ido
|
|
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
www.MilletSoftware.com
|
|
IP Logged |
|
BrianBischof
Admin Group
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
|
Posted: 17 Feb 2008 at 8:52am |
|
It's to a new workbook file.
|
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
|
|
IP Logged |
|
IdoMillet
Groupie
Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 99
|
Posted: 17 Feb 2008 at 9:28am |
|
Hi Brian,
It's not clear if you providing a clarification on behalf of the original poster or if you are indicating the standard export is to a new workbook.
There are ways to export to a sheet within an existing workbook, but it's not clear what the original question is because he used the term "excel sheet" in his question.
|
|
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
www.MilletSoftware.com
|
|
IP Logged |
|
BrianBischof
Admin Group
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
|
Posted: 17 Feb 2008 at 9:41am |
|
You can export to a sheet within a workbook? Cool. I always just created a new workbook and didn't realize there was the option to use an existing workbook.
|
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
|
|
IP Logged |
|
IdoMillet
Groupie
Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 99
|
Posted: 17 Feb 2008 at 9:49am |
|
It's not a built-in option. You have to code it. If it's something you need, you can also consider 3rd-party tools (see list at http://www.kenhamady.com/bookmarks.html).
My Visual CUT software provides that functionality (including the ability to burst a report to multiple sheets or export a report so that it creates a new sheet inside a new/existing workbook (if the sheet already exists, it can be replaced or the data can be appended to it).
- Ido
|
|
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
www.MilletSoftware.com
|
|
IP Logged |
|
|
|
