Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Outputing report in CR to Excel format Post Reply Post New Topic
Author Message
rjjj111
Newbie
Newbie


Joined: 17 Oct 2012
Online Status: Offline
Posts: 3
Quote rjjj111 Replybullet Topic: Outputing report in CR to Excel format
     Posted: 01 Mar 2013 at 9:17am

This is for Crystal 2008

 
we are outputting a report in Crystal Reports format for the end user. We also need to provide a URL link to an excel copy of the same report. All of this needs to be done inside of Crystal. We already have all the fields listed in the report command.
 
We usually build a report for display (Crystal Reports format) and a different report just for Excel format. But in this case the end user wants to be able to see the Crystal Reports view of the report with all the fancy formatting and totalling, etc.... and another version of the fields in Excel format by clicking on a URL link to bring up the Excel version.
 
Any suggestions on how to do this?
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 01 Mar 2013 at 10:39am

You're not going to be able to do this inside of Crystal unless you create a second report off of the same command that has no formatting and would display like it would in an Excel (data only) export. 

 
However, there are a couple of options:
 
1.  The user could just export to Excel data only from within the Crystal Viewer.
 
2.  Create a web page (.aspx or .jsp depending on what your application is written in).  In the web page use the ReportDocument class from the Crystal Reports SDK (.NET or Java as appropriate) to open the report without the viewer, export the report to an Excel file on the webserver, and then open the Excel file so that the user can see it.  You would also have to have code that runs periodically to delete the Excel files generated by this process.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.