Need how to write the Expression for below matter

• mcfarlandparkway

  SSCertifiable

  Points: 7699

  More actions

  May 8, 2014 at 12:17 pm

  #293091

  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

• Mohamed I.

  SSCrazy

  Points: 2774

  More actions

  May 9, 2014 at 7:41 am

  #1712168

  Hi

  Yes it very simple to do it in version 2008.

  Take a look at how the lookup() function works.

  :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t: