Crystal Report table redirection

I want to make the crystal report work at any directory the application is installed.

but the report only retrieve the data from the original database when I designed the report. any idea?


the folloewing is the code:


Private Sub Form_Load()

Dim crxDatabaseTable As CRAXDDRT.DatabaseTable

For Each crxDatabaseTable In Report.Database.Tables
crxDatabaseTable.Location = App.path +"\net.mdb"
Next crxDatabaseTable


CRViewer1.Zoom 100
CRViewer1.ReportSource = Report
CRViewer1.ViewReport


End sub