I have created a report with CR9 using store procedure that pointing to the database.
My problem is when the report passed to different users, the application will point to a different database name. I cannot use the set datasource location because the report is running on the user machine and we cannot request the user to do any extra work.
I just wonder if there any way I can solve this problem, may be have another parameter asking the user the name of the database to be connected?
Any suggestion?
My problem is when the report passed to different users, the application will point to a different database name. I cannot use the set datasource location because the report is running on the user machine and we cannot request the user to do any extra work.
I just wonder if there any way I can solve this problem, may be have another parameter asking the user the name of the database to be connected?
Any suggestion?