Merging Two Datasets in SSRS 2005

• smriti.subramanian

  SSC Eights!

  Points: 854

  More actions

  January 31, 2011 at 11:25 pm

  #231444

  Hi,

  I have a requirement. There is grid in which the result of the grid is fetched from two datasets. There are two seperate SP's which fetches the data and the two datasets are merged in the code. Both the sp's will fetch the same columns but the rows fetched will be different. How can we implement the same in SSRS? please help me.

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  February 1, 2011 at 6:49 am

  #1280897

  This seems like a rather complex way of doing things... Why not just return both datasets in the same query as a single dataset...

  Soemthing like...

  --This is the result of query1

  SELECT Col1, col2, col3

  FROM myTable

  --The union all puts them together

  UNION ALL

  --This is the result of query2

  SELECT Col1, col2, col3

  FROM myTable2

  To help us help you read this[/url]For better help with performance problems please read this[/url]