Crystal reports & relative paths

[Pallex]

Hello. Not sure if this is really a VB problem - i mean, i`m using Crystal Reports from Visual Basic but this problem may be fixable in the actual report definition itself.

I have a database hard-wired into my crystal report (c:\this\that\database.mdb) and i want to change it so it looks up a level, then down into \data.

c:\this\that\report\report.rpt
c:\this\that\data\database.mdb

so the path should be ..\data\database.mdb

but i just cant get the report to live with it! Any ideas?

Thanks,
Alex.

[Apocalypse Dude]

I think this is how you do it
put this in vb
CrystalReport1.DataFiles(0) = App.Path + "\data\database.mdb"

[Pallex]

I think that is for the active x component. I`m using crystal reports v8 and the RDC component so that wont work.
Looks like what i want is

PESetNthTableLocation

but i havent got a clue how!

Thanks,
alex.