March 30, 2011 at 2:50 pm
I'm modifying a SSRS report I wrote some time ago. Now the users want more information, which comes from a different database. I'm working in Visual Studio 2010 Premium. I've added a second datatable to the dataset which is what feeds the report, but I can do anything at all with the fields. I cannot drag them onto the report. And now I cannot drag any of the fields from the old data table.
So this leads me to ask some simple questions:
1) Can a SSRS report have a data source with more than 1 data table in it?
2) Can a SSRS report get data from more than 1 database?
Kindest Regards, Rod Connect with me on LinkedIn.
April 4, 2011 at 12:19 pm
An SSRS Tablix can practically only contain data from one dataset. A single dataset can be a conglomeration of many tables from one or more databases.
So to answer question 1, Yes, an SSRS report can have multiple dataset sources but only one of those datasets can supply data for a given tablix. If you want to show the results from more than 1 dataset on a report you really need multiple tablix, one for each dataset. If you want to tie two datasets together in one tablix, I would argue that there must be a relationship between the datasets, and that the query should be changed so that the two datasets become one dataset based on their relationship via a join.
Answer for question 2, yes, I do it regularly. My dataset is always based on a specific database on a specific server. Calling from tables on other databases on other servers requires a Linked Server on the source database for the dataset, and the use of 4 part naming convention in the query to call the data properly.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply