views:

1358

answers:

4

Using VB 6 and Crystal Report 8.5

In client system while generating the report, I clicked export to PDF button in the report; it displayed Export, Export Option. Choose Export file is not displaying in the client system.

But in my system, it was displayed it displayed Export, Export Option. Choose Export file. But in client system is not showing the choose export file screen.

I cannot able to save a report file in pdf. Because it was not asking a file name to save.

Can any one help to solve this problem?

+1  A: 

Try,

Private Sub ExportReportToPDF(ReportObject As CRAXDRT.Report, Byval FileName As String, Byval ReportTitle As String)
   Dim objExportOptions As CRAXDRT.ExportOptions
   ReportObject.ReportTitle = ReportTitle
    With ReportObject
        .EnableParameterPrompting = False
        .MorePrintEngineErrorMessages = True
    End With

   Set objExportOptions = ReportObject.ExportOptions
    With objExportOptions
        .DestinationType = crEDTDiskFile
        .DiskFileName = FileName
        .FormatType = crEFTPortableDocFormat
        .PDFExportAllPages = True
    End With

    ReportObject.Export False 

End Sub  

Private Sub Command1_Click()
        Dim objCrystal As CRAXDRT.Application
        Dim objReport As CRAXDRT.Report

        Set objCrystal = New CRAXDRT.Application
        Set objReport = objCrystal.OpenReport(ReportFileName, 1)  

        ExportReportToPDF objReport, "c:\foo\foo.pdf", "foo" 
End Sub
adatapost
In my system, Is asking a file name to save, But in Client system is not asking a file name to save?
Gopal
@adatapost - Export PDF is already built in function in Crystal Report 8.5, Why should i Have to write a code for Export to PDF. In my System is aksing a file name to save. But in Client system export PDF screen is displaying, but it is not asking a file name to save.
Gopal
@Gopal - We export to PDF on a client system every day. We prompt our users for the file name and set the filename in the export options as above. It should just work.
Paul Williams
A: 

It sounds like a deployment problem with the Crystal files. Check the user has a file called u2ddisk.dll on their machine - this file is required for Crystal 8.5 to give the option to export to file. Otherwise it'll select the Export to Application option instead. The availability of items in the Export Format and Export Destination dropdowns is dependend on the dlls present, and it sounds like you're missing Export To Disk from the Destination dropdown.

CodeByMoonlight
A: 

I'm using RAQ Report. RAQ Report is a free excel-like reporting tool. RAQ Report can export to pdf easily. For more details you can refer to http://www.raqsoft.com/product/raq-report/export-format/.

A: 

Hi from Spain.

We are doing something like this to export a report to PDF (CRYSTAL XI), with CRAXDRT objet in VB6, but now, at WINDOWS7, we have problems with the exportation: it doesn't create the file.

Someone knows what's the problem? And the solution for it?

Thanks, Logan

Manel