SSRS Expressions

• Aisha.Arshad

  Grasshopper

  Points: 11

  More actions

  September 30, 2015 at 7:48 am

  #321631

  Hi guys,

  I needed to add an expression to the field in an SSRS report, basically I want it to display the number of trainees in the stored procedure query where their status is null.

  So normally in T-SQL id just do:

  SELECT COUNT(DISTINCT(TRAINEEID))

  FROM #ATI

  WHERE STATUSCHANGEREQUEST IS NULL

  I just need to do that in an SSRS expression, is that do-able?

  As the stored procedure pulls a row per trainee.

  Thanks for your help in advance

  Regards,

  Aisha

• Spiff

  SSCertifiable

  Points: 7766

  More actions

  October 2, 2015 at 3:04 am

  #1830985

  Hi Aisha,

  You can do this, just use an expression within the summary e.g.

  =CountDistinct(Iif(Fields!StatusChangeRequest.Value Is Nothing, Nothing, Fields!TraineeID.Value))