cancel
Showing results for 
Search instead for 
Did you mean: 

Export to Excel options in Crystal 2011

Former Member
0 Kudos

Hi,

We recently upgrade to Crystal 2011 from Crystal 8, Our new product uses the CrystalDecisions.Windows.Forms.CrystalReportViewer to display the final report and allow users to export out the report to other formats such as Excel.  In the old version, we used the CrystalActiveXReportViewer to achieve the same functionality. The problem is that the old version, when exporting to Excel, gave more formatting options such as "Export page header and page footers", but the new version doesn't seem to have any of those options and our customers had gotten used to having that flexibility. Please see the attach file.

We think that if we can use the CrytalActiveXReport then we may have the same functionality as the Crystal 8. Does the Crystal 2011 have the CrystalActiveXReport?  If it does what dll should be added to the References?

Thanks,

Kent

Accepted Solutions (1)

Accepted Solutions (1)

DellSC
Active Contributor
0 Kudos

Please bear in mind that Crystal 8 is very old - I was using Crystal 8.5 over 10 years ago - and there have been many changes to Crystal and its SDK since then.

The ActiveX viewer is no longer available - a big part of the reason is the security risks with using ActiveX and the fact that default security on newer versions of Windows can block the use of ActiveX controls.

Which version of Visual Studio and the SAP Crystal for Visual Studio SDK are you using to develop your app?

-Dell

Former Member
0 Kudos

Hi Dell,

Thanks,

We are actually update from Crystall 8.5 to Crystall 11. Sorry for the confusion. We use Visual Studio 2010 and SAP Crystal 2011 version 13.0.2000.0.

When we display the report, we use CrystalDecisions.Windows.Forms.CrystalReportViewer.   The CrystalDecisions.Windows.Forms.CrystalReportViewer dosen't seem to have the settings as the CrystalActiveXReportViewer that can be used to formatting the Excel export.  If we use the CrystalDecisions.Windows.Forms.CrystalReportViewer, how do we have the same functionality?

Thanks again,

Kent

former_member207665
Active Participant
0 Kudos

Hi Kent,

Unfortunately we do not have those options in CrystalReportsViewer (13.0.2000) for Export to Excel Format. You would need to export the report as a whole.

We cannot have the same functionality for the new CrystalReportsViewer.

When you export a report through code using CR .NET SDK, you have the below format options available:

  • The first and last page of the report to export.
  • The default column width.
  • Whether or not to include column headings.

Download CR .NET SDK Developer Guide

Download CR .NET SDK API Reference

Regards,

Vinit

Former Member
0 Kudos

Hi Vinit,

Thanks very much.

Kent

Answers (0)