Chaps/Chapesses,

I have a report which is loaded into the crystal viewer, the report was created using a file dsn looking at a foxpro database container. The problem i have is that in order to make the report run, you have to have the client machines ODBC changed to have the File DSN default directory pointing to where the File DSN for the report is located.

Is there anyway of changing the location of the file DSN/database at runtime when previewing the report, i have found some options for setting the datasource of a report at run-time but it comes up with an error saying'Server not yet opened', there is also some options for logonserver but i can't figure out how to get this to work!!!

Please help