I have a reporting application which is launched from a server which is hardcoded in the application databases (1 database per state). I need to do this virtually so no hard coding. I achieved this by putting the server name only in the setting of the launcher. Now my problem is that if I pull the databases that I'm accessing from the launcher in my c: drive to test etc the server is lost. How can I achive this by not hardcoding the server name? I tried using code for "currentDB" but when the reports are written the directories and Macros are not in my C drive. In the past the server name was all hard coded in all hundreds of reports for each databaes per state. Can I add code to get the server name from the launcher? I don't know how.
Thanks
Thanks