Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Tuesday, November 26, 2013

How to give null/ space if the values is zero in SSRS 2012

Hi,
 Just enter the syntex as expression for SSRS
=iif(Fields!FieldName.Value > 0,  Fields!FieldName.Value,  space(0))

Regards,

No comments:

Post a Comment

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...