January 23, 2006 at 7:07 am
I'm using SQL Server 2000 Reporting Services.
I've developed several reports, which are run via our application using ReportViewer.
I need a way to run a report using the correct database for the requesting customer.
I have seen that you can change the datasource using the Web Service "SetReportDatasources", but rather than this (which could potentially mean that a customer could request a report, and recieve another customers data if 2 customers request the same report at the same time), I need to be able to run an instance of the report using a specified database.
Can anyone give me some advice?
January 24, 2006 at 8:23 am
I would use a partitioned view.
For example, if you have 10 databases with a table called customersales for example, you can put a contraint on the customerid in each table and wrapp a view around the tables within a centralized data access database. As long a you specify the constrained field in the where clause, you should hit just that one database and table. We use this technique regularly to help manage table sizes and it works like a charm.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply