topic Re: Multiple tables for a single dataset in Report Server

Multiple tables for a single dataset

Anonymous — Thu, 16 Aug 2018 12:55:25 GMT

Hello,

I'm trying to create a data set from one of my data sources. I would like to import multiple tables from a database of SQL Server, but I am not able to do so. Do you know if it's possible? I don't want just a single table.

Thank you

Nick

Re: Multiple tables for a single dataset

Jon-Heide — Thu, 16 Aug 2018 16:53:21 GMT

Hi Nick - a data soruce is a connection to a single database, a data set is only one table. To use multiple tables, you either need to join then the SQL query (to create a single table) or use multiple datasets.