I can tell you we have had the exact same problem and could not find a solution other than to dump CR and create reports in HTML. If you look in Google there are many people with this issues. Crystal Reports really stinks big time developing with it. Its very flaky and constantly battling its quirks (not to mention the rude people at Crystal Decisions). Many a time it has trashed our rpt files. Unfortunately there is no other report writer out there. I feel your pain. Sorry I can't be of help and ranted instead.
>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