Development Desk
Just another WordPress.com site
SQL Server Reporting–Apply Checks on Report Fields
Posted by on June 26, 2012
To check null filed
=Iif(IsNothing(Fields!InvoiceName.Value,”Invoice Name Not available”, Fields!InvoiceName.Value ))
To use If statement
=Iif(Fields!IsActive.Value,”Yes”,”No”)
To use Switch statement
=switch(Fields!DateFormate.Value = “dd-mm-yyyy”, “Format: Day, month and year”,Fields!DateFormate.Value = “mm-dd-yyyy”, “Format: month, day and year”, Fields!DateFormate.Value = “yyyy-mm-dd”, “Format: year, month and date”)
