i am using vb6 crystal report 9, i want create a report to view the screen and automaticall export pdf , or excel , i am using the following Code.
Dim conn As ADODB.Connection
Dim Rs As ADODB.Recordset
Dim crystal As CRAXDRT.Application
Dim report As CRAXDRT.report
Dim sSQL As String
Dim CRXDATABASETABLE As CRAXDRT.DatabaseTable

Note : i have created report earlier using ODBC , tHIS CODE USING OLEDB CONNECTION. SOME TIME THIS CODE GIVEN SOME NETWORK ERROR IT AFFECTED OTHER NETWORK ALSO. I NEED TO VIEW THE REPORT AND EXPORT EXCEL OR PDF USING SQLQUERY.
PLS HELP ME MY PROBLEM.
BY
CHANDRA.