all groups > sql server reporting services > december 2005 >
You're in the

sql server reporting services

group:

Multiple Tables


Multiple Tables Vishal
12/23/2005 1:07:11 PM
sql server reporting services:
Hi,

I am using a SProc to run a report, is it possible to have 2 Tables in one
report which will display different columns from the dataset ?

Thanks

Re: Multiple Tables Bruce L-C [MVP]
12/23/2005 3:46:35 PM
Yes. You can use the same dataset multiple times. For instance, you could
apply different filters to it, have a table and have a graph etc. What you
cannot do is have the sproc return two resultsets.

Also, you can have multiple datasets as well.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button