SSRS - Display field value based on user

• rjjh78

  SSCrazy

  Points: 2784

  More actions

  May 3, 2019 at 4:38 pm

  #3634427

  Hello,

  WHile using SSRS, I only want to display a fields data value if the user is a specific person, otherwise I want to set the field value in the Tablix to "0'.  I believe  the following  expression would be correct but isgenerating an error message.  Can someone provide some insight?  Many Thanks in advance!

  =SWITCH(User!UserID = "DOMAIN\username",Fields!SalesTotal.Value,"0")

  • This topic was modified 4 years, 11 months ago by  rjjh78.
  • This topic was modified 4 years, 11 months ago by  rjjh78.

• Jeffrey Williams

  SSC Guru

  Points: 90244

  More actions

  May 3, 2019 at 6:07 pm

  #3634516

  =IIf(User!UserID.Value = "DOMAIN\username", Fields!SalesTotal.Value, "0")

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs