March 30, 2012 at 1:24 am
i have same application + database installed separately on each of my branches server. when i create ssrs based on this, i pass server name and database name as parameter to datasource and thus user can select any branch at report runtime. this is working fine
now i have a situation where i have two branch databases on same machine, when i try to select first or second of these databases, its always pointing to first database. how can i overcome this
March 30, 2012 at 1:30 am
Please don't cross post.
al replies here: http://www.sqlservercentral.com/Forums/Topic1275562-1633-1.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 30, 2012 at 1:31 am
i take it in the branch they DB's have the same name?
on the local server where two copies are they are differently named?
has the report been reconfigured so that when they select branch2 it still points to the new DB name and not the old DB name?
So original config would be
Select Branch1 -> Conn String is SQLBranch1.BranchData.dbo.Table
Select Branch2 -> Conn String is SQLBranch2.BranchData.dbo.Table
Where as now your wanting to do
Select Branch1 -> Conn String is SQLServer.Branch1Data.dbo.Table
Select Branch2 -> Conn String is SQLServer.Branch2Data.dbo.Table
Where as your getting something like this
Select Branch1 -> Conn String is SQLServer.BranchData.dbo.Table
Select Branch2 -> Conn String is SQLServer.BranchData.dbo.Table
March 30, 2012 at 1:32 am
by mistake it get posted twice...and i dont see how to remove one of them
March 30, 2012 at 1:37 am
i have branch server named srv1, srv2,... and database named db1, db2, ...
now on srv5 i have database db5 and db6
and in report datasource i have put the connection string which take server name and initial catalaoug name from parameters
and in parameter available values i have entered the correct combination srv5+db5 and srv5+db6
when i select second combinatin, it still go to first one.
April 8, 2012 at 6:06 am
no news
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply