Hi,
Sub: Unable to open the Crystal report exported in Crystal Report Format

1) I have used Oracle Native connection, while designing the report.
2) I have passed the record set to the report at run time.
3) Exported the report to Crystal Report Format, But I could n’t able to open report, while opening , the report asks for OLEDB information, even though I used Native connection at design time.
4) In Crystal Report 8.5, connect driver property, but I am using crystal reports XI and in Visual Basic 6.0, Is there any method or property to convert the connection?. As I have to export report to crystal format and emailed to user, so that user can open it.
Any assistance in this regard is highly appreciated

The code is as follows:
Public Sub Aging_REPORT(strSQL As String, sReportName As String, sDestFileName As String, ReportTitle As String)

On Error GoTo Err
Dim CrAppl As CRAXDRT.Application
Dim crrep As CRAXDRT.Report

Dim rsCrystal As ADODB.Recordset

    Set CrAppl = New CRAXDRT.Application
    Set crrep = CrAppl.OpenReport(sReportName) 'Opens the report

   Set rsCrystal = New ADODB.Recordset


    rsCrystal.Open strSQL, Conn, adOpenStatic, adLockReadOnly
    rsCrystal.Requery


     With crrep
     .DiscardSavedData
    .Database.LogOnServer "crdb_oracle.dll", strServerName, "", strUserName, strPassword
     .ReportTitle = ReportTitle
     .Database.SetDataSource rsCrystal, 3 'LINK REPORT TO RECORDSET
     .VerifyOnEveryPrint = True
     End With

   With crrep.ExportOptions
    .DestinationType = crEDTDiskFile
    .FormatType = crEFTCrystalReport
    .DiskFileName = sDestFileName
   End With


   crrep.Export (False)
    Set crrep = Nothing
    Set CrAppl = Nothing
    Exit Sub
Err:
 MsgBox Err.Description

End Sub

Thanks,

Hi
My nickname is Lupo
I also have converted from Crystal Reports 8.0 to XI.
Pls send me your email address so I can send you sample code
of my application.

I have recompiled my old reports into version XI.
I use such predefined reports for printing on paper, exporting into PDF-File and also as email to "Outlook".
There might be code that can help you.
I use the German version of XI - which version do you use ?
I'm German - if you prefer to correspond in German - OK

Regards Lupo

i too have the same problem in crystal report 7..

can anyone help

bhagya

Hi, i have the same problem too.

Can you send to me your sample code?

Thanks you for the helping.