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

Need how to write the Expression for below matter Expand / Collapse
Author
Message
Posted Thursday, May 8, 2014 12:17 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, September 26, 2014 6:19 PM
Points: 62, Visits: 121
Hello,
I have a scenario in SSRS report where I have 2 datasets

First dataset contains systemid,system name
and second dataset contains systemid

Is there any way to join the values of first dataset systemid and second dataset system id

in order to get systemname value

For eg: Firstdataset contains systemid as 622
Second dataset contaisn systemid as 622

then the system name value for this system id is Dolpin County

Is there anyway to write expression by using datasets
Post #1569064
Posted Friday, May 9, 2014 7:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:41 AM
Points: 41, Visits: 165
Hi

Yes it very simple to do it in version 2008.
Take a look at how the lookup() function works.

Post #1569267
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse