944,198 Members | Top Members by Rank

Ad:
  • VB.NET Discussion Thread
  • Unsolved
  • Views: 11062
  • VB.NET RSS
Aug 5th, 2007
0

Set runtime connection to the Access database for Crystal report

Expand Post »
I have created a Cryatal Report and set its Access database(.mdb) during design time. I have imported the crystal report into VB.NET. now i want to know how can we set the database path during runtime. The database to which i've linked will change its path and name every year.

Kindly hepl me out
Last edited by GowriJai; Aug 5th, 2007 at 6:35 am.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
GowriJai is offline Offline
1 posts
since Aug 2007
Nov 26th, 2008
0

Re: Set runtime connection to the Access database for Crystal report

How can filter the field in crystal report at run time in vb.net
Reputation Points: 8
Solved Threads: 1
Newbie Poster
gomathinayagam is offline Offline
15 posts
since Nov 2008
Mar 14th, 2010
-1
Re: Set runtime connection to the Access database for Crystal report
Click to Expand / Collapse  Quote originally posted by GowriJai ...
I have created a Cryatal Report and set its Access database(.mdb) during design time. I have imported the crystal report into VB.NET. now i want to know how can we set the database path during runtime. The database to which i've linked will change its path and name every year.

Kindly hepl me out
hope it will help you :


Dim path1 As String = "your connection here" '" '' path
'' for normal ADO Concept
'' The current DataSource is an ADO

'' change path of the database
rpt.DataSourceConnections.Item(0). _
SetConnection("", "" & path1 & "", False)
'' if password is given then give the password
'' if not give it will ask at runtime
rpt.DataSourceConnections.Item(0).SetLogon("Admin", "")
Reputation Points: 10
Solved Threads: 0
Newbie Poster
kacebaza is offline Offline
2 posts
since Sep 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in VB.NET Forum Timeline: About files or Information
Next Thread in VB.NET Forum Timeline: rystal report wont show data





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC