July 11, 2014 at 12:04 am
Hi ,
I have an RDL with 2 Datasource , one is SQL Datasource and other is Oracle Datasource and i want to use this RDL for more than 50 clients. For all clients table schema will be the same only the login credential varies
In SQL Datasource i gave connection string as below
="Data Source=DBIP;Initial Catalog=DBNAME ;UserName=" & Parameters!Web_Username.Value & ";Password=" & Parameters!Web_Password.Value
And for Oracle connection string i gave as below
="Data Source=ServerName;UserName=" & Parameters!Ora_Username.Value & ";Password=" & Parameters!Ora_Password.Value
Also in advanced I have set Integrated Security as TRUE.
But i am not able to go ahead by setting connection string like this. It asks for credential. Can anyone suggest is there any alternate way to handle this scenario. So that i need not create RDL for each client , i can go ahead with a single RDL for all clients just by changing the parameter alone. Any suggestion is appreciated.
Thanks in advance,
JB
September 25, 2014 at 8:09 am
you can create a Client master db and connect to that db your RDL and create a table ClientDBList in master DB in which you have to maintain the connection details of different Client DBs and create report procedures as well in Client master DB and in that SP you can can call that SP in Client DB. I hope this clears.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply