forum.venkateswarlu.net
      Register      Login
How to Handle Multiple Queries in SSRS

1 replies to this topic

Kalyan Suman #1
Member
150 Points
 Posted on 31 Oct 2014 06:04 PM IST

 i want to try Excel/Access As a datasource in SSRS

i tried like this

   select * from EMployee

  Select * from dept

am getting error in query builder

is it possible do like this

Thanks In Advance

 
SSRS     801 views     Reply to this topic
Cherukuri Venkateswarlu #2
Member
140 Points
 Replied on 02 Nov 2014 08:13 AM IST Unfortunately DataSets will not handle multiple result sets in SSRS Reports.

If multiple result sets are retrieved through a single query, only the first result set is processed, and all other result sets are ignored.

Instead of making multiple queries in one Data Set, create a separate data set for each query.

Thanks,
Venkat
 
Reply to this topic