• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

How to export to Excel using Crystal XI R2 using RDC without prompting messages

Hi all.

using VB6, any body know  How to export to Excel using Crystal XI R2 and RDC without prompting messages.

Thanks
0
JairoMarques
Asked:
JairoMarques
  • 3
  • 2
1 Solution
 
mlmccCommented:
First question.  Why Release 2.  It is only requires for running with VS.Net 2005.

As I recall there is a flag on the export command to show or not show the export dialog.

How are you exporting?

mlmcc
0
 
JairoMarquesAuthor Commented:
Hi,

I already using False in Export method.

see above:
...
goCrystalReport.ExportOptions.DestinationType = crEDTDiskFile goCrystalReport.ExportOptions.DiskFileName = "myfilename.xls"
oCrystalReport.ExportOptions.FormatType = crEFTExcel97
goCrystalReport.ExportOptions.ExcelExportAllPages = True
goCrystalReport.DisplayProgressDialog = False
goCrystalReport.Export False

If i use any other FormatType the dialog doesn´t appear. Only with Excel format type.
0
 
mlmccCommented:
DO you have the Excel export dlls loaded?

If you just click OK does it export?

mlmcc
0
 
JairoMarquesAuthor Commented:
Yes, they are.

Everything works, but I don´t want this dialog, like in the other format types.
0
 
JairoMarquesAuthor Commented:
Hi all,

the Excel dialogs only appear in Development enviroment. At runtime everything works properly.

Thanks all.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now