Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Retrieving data from Multiple Datasets Expand / Collapse
Author
Message
Posted Monday, July 8, 2013 3:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 4:59 AM
Points: 2, Visits: 44
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.

Post #1471092
Posted Monday, July 8, 2013 4:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 4:59 AM
Points: 2, Visits: 44
Had a problem with my MDX query . The report works fine now.
thanks !
Post #1471106
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse