The easiest way would be to use an ODBC connection. Then you can run it on any machine with that ODBC entry and you can have that ODBC entry point at any Database you want.
I'm not sure how to create a generic ODBC entry - can you let me know how to do this please?
When using this method, can I use the reports as follows
lets say db and cr reports are stored on the file server
User 1 - db/report path mapped as F:\MyData\Reports
User 2 - db/report path mapped as G:\MyData\Reports
When user1 runs the program it need to access the database stored in F:\MyData (logical) drive and report in F:\MyData\report directory.
Similarly user2 can access the same report through pre-mapped G:\drive
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.