Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Metcalf
Yak Posting Veteran
52 Posts |
 Posted - 2010-08-10 : 15:17:07
|
| I am tinkering with SQL Server Reporting Services, and either I'm asking the wrong question or using the wrong terminology to ask the right question, but regardless, after some fruitless searching I wind up here.This is what I am doing... my organization consists of three 'sister' companies all under one AD roof, using the same ERP system, but the ERP data for each company is under a separate DB with identical schema. Is there any way to A) use AD to set the default Data Source and B) still allow users a method by which to peek at data from the other company, if need be? Or do I have to just design/deploy copies of every report, for each company? That could get unwieldy, as there are literally hundreds of reports we'd like to end up sticking on SSRS. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-11 : 10:29:27
|
| seems like what you need is typically design a warehouse where you merge data from all companies and populate tables which can be used by reports and then in reports use a parameter to select require company and display the reqd data alone for interested company.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Reporting Services Data Source Question