I am highly involved in developing applications that run in a distributed environment (using COM+) and this works fine, except for a hiccup in reporting tools. In COM+ environment I would first register server components at server and Create Crystalreports Files’ folder at server. On clients work stations I simply install the client application.
Now, have the following concerns (Problems):-
1) The Report folder on the server needs to be shared which is not good security wise.
2) When accessing reports form the clients, they are basically run on the client and the report looks for the database locally (on the client) yet the database resides on the server. Hence the report database access error.
How do you make reports that can bequeried by clients without sharing database folders on the server?
Please help