CODEWITHSUNDEEP
sql-serverreporting-services
Alpesh
Alpesh

Reputation: 51

SQL web Reporting from multiple databases

Firstly let me start by letting you know that I am new to SQL reports. What I have is 2 independent customers, each have the same database structure, just on different SQL database machines.

What I want to do is create a reporting suite and have the customers use this so that they can run the reports from there own databases.

How is it best to do this

Thanks you in advance

Alpesh

Upvotes: 1

Views: 99

Answers (1)

Eralper
Eralper

Reputation: 6622

You can serve reports via SSRS from a central server. For each user you can use different data sources behind like two different report folders containing same rdl's but data source object mapping to own data

Upvotes: 2

Related Questions