Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: dynamically set datasource location crystalreports Post Reply Post New Topic
Author Message
priyavenkat
Newbie
Newbie
Avatar

Joined: 28 May 2007
Location: India
Online Status: Offline
Posts: 1
Quote priyavenkat Replybullet Topic: dynamically set datasource location crystalreports
    Posted: 28 May 2007 at 3:41am
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.
Thankas and Regards,
Priyavenkat
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.063 seconds.