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 |
|
sreeharikv
Starting Member
1 Post |
 Posted - 2008-12-12 : 04:26:08
|
| Hello all,I am sreehari. I am currently asssigned to a project which is being rewritten using .Net framework 3.5. This project is cuurently using Crystal reports for generating reports. We are doing a shift to Sql server 2005 reporting services.The scenario is like this..We have multiple databases and a single report template is used to show reports according to the user logged in to which database at runtime. Will it be possible to generate reports using reporting service and dynamically set the datasource to collect the data, ie 1 report and multiple databases?I have heard that Crystal Reports stores the data source properties within each report. Each data source can also have its own connection information. This gives you great flexibility for using different servers to generate data from..But SSRS is designed so that reports can share a common data source. The downside is that the individual reports don't have the flexibility to have the data source modified during runtime. For example, if a report defaults to using a certain server and database and occasionally needs to switch to a different server for reporting on historical data, this can't be done. By sharing a common data connection, you lose the granularity of being able to control individual reports.Does anybody have a solution with this issue? |
|
|
|
|
|
Reporting services - Dynamic Datasource