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 |
|
sun_psna
Starting Member
4 Posts |
 Posted - 2008-11-05 : 08:11:57
|
| Hi,I have a report in Report server. There are three client application accessing the same report and using report viewer control for display purpose.Now all three application shows same data. I need to modify my asp.net (C#) code or report to work based on the calling application and display of their own. Please advice me how to proceed further.If you are not clear on my description please let me know.PS: All three application DB structure are same, used by different clients.Thanks,Sundar |
|
|
sun_psna
Starting Member
4 Posts |
Posted - 2008-11-05 : 23:38:18
|
| Each report needs to retrive data from different database. (But all Database structure are same, so the same stored procedure is available in all DB's)SAy for example:Appln A , Appln B & Appln C - all are calling the same RS report with same parameters.When ApplnA calls the report then our RS report need to connect to Appln A's DB (i.e. DB A) and retrive data.Currently All three applications are getting DB A's data, not their own data.How to achive this ? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-05 : 23:42:41
|
| This should give you a starthttp://blogs.msdn.com/bimusings/archive/2006/07/19/671743.aspx |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2008-11-06 : 13:26:57
|
| Or if you don't want to do it with Integration Services, you could do something similar by defining a generic application database that contains your report stored procedures. Each procedure would take a parameter for application instance in addition to the parameters needed to filter the results. Then the procedure would, based on the instance parameter, retrieve results from the appropriate instance database.---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
Use single RS Report to access multiple DB