Crystal Reports Crystal Report to Excel

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Crystal Report to Excel

Author	Message
bremen Groupie Joined: 28 May 2013 Online Status: Offline Posts: 93	Topic: Crystal Report to Excel Posted: 08 Jul 2013 at 1:28pm
	So I have a nice neat little report that I have generated and it works beautifuly. Now the powers that be have asked me to automate the report if possible. The data is exported into Excel and that then drives a dashboard. Is there a way to take all of the work I've done in crystal and easily dump that into excel?
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 09 Jul 2013 at 3:41am
	You can export the report to Excel (Data Only) to get the file, but you might have to do some reformatting to get it to export cleanly. You can find information about how to do that here: https://www.facebook.com/notes/sap-crystal-reports-and-dashboard-solutions/formatting-a-crystal-report-for-export-to-ms-excel/431695651872 To automate the process you could write either Java or .NET code using the SDK and create a program that could be scheduled in the Windows Scheduler to automatically run the report and export it to Excel. -Dell Edited by hilfy - 09 Jul 2013 at 3:41am
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	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.