Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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