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.