Retrieving data from Multiple Datasets

• RSNewbie

  Grasshopper

  Points: 18

  More actions

  July 8, 2013 at 3:02 am

  #274943

  Hi,

  I have a scenario where I need to pull in data from 2 datasets.

  Dataset1 will hold data from all the regions. Dataset2 will have data for a particular region of interest.

  I need to display the month and underneath total for region1.

  The rest of the rows from dataset1 are displayed afterwards.

  The common field between them is month.

  I used the following lookup function

  =lookup(Fields!Month.Value,Fields!Month.Value,Fields!TotalRegion.Value, "Dataset2")

  But, the function returns nothing. I'm a newbie to SSRS . any leads on this would be helpful.

  Thanks in advance.

• RSNewbie

  Grasshopper

  Points: 18

  More actions

  July 8, 2013 at 4:16 am

  #1630369

  Had a problem with my MDX query :angry:. The report works fine now.

  thanks !