mercredi 28 août 2019

Find Sub string in SSRS and evaluate or replace

In SSRS I have data field called Event_dt it returns as Digital followed by Month, then Year. It looks like this Digital January 2021 or Digital May 2019

Question 1: In one field - I need to truncate the word Digital so the string would only read January 2021 or May 2019

Question 2: In the second string i need to evaluate, if Event_dt string contains the word Digital then it should output something else. I know the iff(part ... but i'm not sure how to get the sub string part in SSRS.

Aucun commentaire:

Enregistrer un commentaire