Hai,
I am using Visual basic 6.0 and msaccess as backend.
I am creating reports using crystal report version 10.0 and connect database using ODBC DSN connection property. and i call my report through vb code. it will work my machine very perfectly. but when i setup this porject in my client machine in different database path. The report will not work. it asks database path.
So, how can i dynamically set my database dsn connection string thruogh vb 6.0?
Now my code is,
Dim CrxApp As New craxdrt.Application
Dim crxRpt As craxdrt.Report
Set crxRpt = CrxApp.OpenReport(App.Path & \Reports\studentmaillist.rpt")
crxRpt.Database.Tables(1).Location = "tblStudentInfo"
CRViewer1.ReportSource = crxRpt
CRViewer1.ViewReport
please help me. It's very urgent one.