Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Urgent!! Automatically export a crystal report in VB6

Status
Not open for further replies.

DamoOz

Programmer
Oct 18, 2000
24
AU
Help

I can automatically export my VB reports to HTML but I am unable to export me Crystal reports automatically from within VB. I have changed all the export options but I still get a user prompt.

Can I automatically export a crystal report to HTML using VB??

Running out of time......
DamoOz
 
You can export a Crystal Report directly to HTML from VB.

What type of user prompt are you getting?
Also, how are you integrating crystal into your project? Are you using the designer component, automation server, etc?

I can get you there with a little more info and maybe a sample of your code.

Cody ford
codyjford@hotmail.com

VB, VBS, Seagate Info/Crystal Reports

 
Cody

Thanks for your interest. Here is a basic example of some code. The first export is a VB6.0 data report which I automatically export to HTML with no problems. I then introduced Crystal reports into the project and I am trying to export this to HTML also. I set all the necessary export options (i think!) and then do the export but I keep getting the CR dialog box prompting for export options. It's the same dialog box that comes up if you try to export from the crystal reports IDE.

Hope you can help?
Damo

rptVoiceException.Title = strRptTitle & _
"Voice Exception Report - (Hourly File " & FileList(y) & ")"

'rptVoiceException.ExportReport rptKeyHTML, strHTMLPath & Mid(FileList(y), 7, 2), True, False

imgCheck2.Visible = True

'Update_Exception_Totals_Table
CrystalReport1.ExportOptions.HTMLFileName = "D:\damien\test\chart"
CrystalReport1.ExportOptions.FormatType = crEFTHTML32Standard
CrystalReport1.ExportOptions.DiskFileName = "D:\damien\test\"
CrystalReport1.ExportOptions.DestinationType = crEDTDiskFile
CrystalReport1.ExportOptions.HTMLEnableSeparatedPages = True
CrystalReport1.ExportOptions.HTMLHasPageNavigator = True

CrystalReport1.Export

deGspProcessing.rsVoiceExc_Grouping.Close
 
I have found the answer.... DOH!!

All I need is CrystalReport1.Export (false)

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top