ExcelFormatOptions is it working for someone? VS2005 beta 2 Exporting report to Excel

Hot Topic

Host a WCF Service in WAS
Convert from RTF to HTML
Project type
Visual Source Safe 2005 and Visual Studio 2005
An explicit conversion exists
sending to excell with VB
VSTO Question: Are ActionsPanes objects available in Outlook Addin?
runtime requirements for using DirectX for wpf projects
Drag & Drop + VBA Marco Question
KB 907417 & 908002

Visual Studio

Installation problem of CR application.
VSTO installation
MS SCC API v1.2
Subversion SVN with Visual Studio 2005
Install errors if VS2005 Windows Workflow Extensions previously present
Expression<Func<A,R>> to Func<A,R> conversion
How do I Edit Word Template in Visual Studio 2005 VSTO
DefaultSorting Bookmarks
Intercepting the Saving of a Word document
Enabling a button though Data Binding

ExcelFormatOptions is it working for someone? VS2005 beta 2 Exporting report to Excel

Hi. I'm using vs2005 beta2 version of CrystalReport in an aspx page.
I'm able to export to http response to both excel and excelRecord format.
But, when I try to use ExcelFormatOptions, these options are not applied

Here's my code

Public Shared Sub ExporterRapport(ByVal ExportFormat As String, ByRef objRapport As CrystalReportSource, ByRef objResponse As System.Web.HttpResponse, ByVal TitreRapport As String, Optional ByVal PieceJointe As Boolean = True)

Dim myExportOptions As New ExportOptions()

If ExportFormat = "PDF" Then
   myExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat
ElseIf ExportFormat = "XLS" Then
   Dim excelFormatOpts As New ExcelFormatOptions()
   ' Set the excel format options.
   excelFormatOpts.ExcelTabHasColumnHeadings = True
   excelFormatOpts.ExcelConstantColumnWidth = 250
   excelFormatOpts.ExcelUseConstantColumnWidth = True
   excelFormatOpts.UsePageRange = False
   myExportOptions.ExportFormatType = ExportFormatType.ExcelRecord
   myExportOptions.FormatOptions = excelFormatOpts

ElseIf ...
End If

objRapport.ReportDocument.ExportToHttpResponse(myExportOptions, objResponse, PieceJointe, TitreRapport)

End Sub

 Thanks, MBus.

Answer this question

ExcelFormatOptions is it working for someone? VS2005 beta 2 Exporting report to Excel

  • oananiev

    Hi Keith,

    what happened with this post Is there any solution to this

    I’m using CR XI Rel 2 and it still doesn’t work to set the column width when exporting to ExcelRecord!

    Thanks,

    Robert



  • Mike Carlisle

    Hi,

    Was there any solution to this post

    Thanks,
    Godwin

  • Marty.M

    Hello Martin,

    Sorry for the long delay on this one. 

    I tried doing this in Crystal Reports for Visual Studio 2003 .NET and I was getting the same results.

    I will see if any solutions exist for that product as it may help in providing a solution for you.

    Keith - Business Objects

  • Lorin

    Hello Martin,

    I tried this out and I am getting the same results (or lack of) that you are.

    Let me run this by the developers to see if this is a known issue.

    Thanks!
    Keith - Business Objects

  • ExcelFormatOptions is it working for someone? VS2005 beta 2 Exporting report to Excel
Answer this question