Changing database location in Crystal Report. [Resolved]

[albertlse]

Currently the database location of my Crystal Report is "C:\Invoice\Database.mdb"

I would like to change it to this:

Application.Startup & "\Database\Database.mdb"

So that, if I move my Invoice project's folder to other location, I can still run the Crystal Report, without changing the database path.

How can I make it?

Please guide. Thank you.

[Lunatic3]

Inside an event put this:

Dim rpt As New crTest() ' Your report name
Dim tb As CrystalDecisions.CrystalReports.Engine.Table
Dim cn As New CrystalDecisions.Shared.ConnectionInfo()
cn.DatabaseName = Application.StartupPath & Application.Startup & "\Database\Database.mdb"  ' The path
cn.UserID = "username" 'may not be needed
cn.Password = "yourpassword" 'may not be needed
'  cn.ServerName = "The_Server_Path_If_Needed"
Dim tblog As New CrystalDecisions.Shared.TableLogOnInfo()
For Each tb In rpt.Database.Tables
tblog.ConnectionInfo = cn
tb.ApplyLogOnInfo(tblog)
Next
rptv.ReportSource = rpt ' rptv is your crystal report viewer

[albertlse]

it's working fine now!