Using Multiple Dataset in SSRS reports

• diganta.goswami

  Grasshopper

  Points: 14

  More actions

  March 19, 2009 at 2:06 am

  #202442

  Hi All,

  I have to make a report having 3 datasets

  Dataset 1: Month-Year, Actual_Batches

  Dataset 2: Month-Year, Planned_Batches

  Dataset 3: Month-Year, Physical_Out_Qty

  In all the 3 dataset Month-Year is the common dimension. I would like to know whether it is possible to make a single SSRS report like below

  Month_Year | Actual_Batches | Planned_Batches | Physical_Out_Qty

  ------------ --------------- ----------------- ----------------

  Mar-08 | 30 | 35 | 400

  Apr-08 | 40 | 40 | 350

  May-08 | 60 | 55 | 580

  In other words using multiple dataset for the creation of single SSRS report. Thanks in advance.

• gopalkrish14

  Grasshopper

  Points: 13

  More actions

  March 19, 2009 at 6:32 am

  #962618

  hi,

  use query builder while u create the reports in the bids using query we can join the fields which u wants

  better luck , bye