How to get cell value not dataset value in SSRS
I am showing '-' when dataset field value is NULL.
I am setting Alignment property of each cell and wondering if there is any quick way of doing it by checking cell text instead of dataset field value? Like if cell text is showing up '-' then make it in center otherwise set it to right, and i can easily copy and paste it on all cells.
=IIF(Fields!PercVisitsWithReports.Value IS NOTHING , "Center", "Right")
=IIF(isnothing(Fields!PercVisitsWithReports.Value), "Center", "Right")
the isnothing(expr) returns true if the expr is null.
In a SSRS Tablix, each cell has a name. You can acces its value by using the ReportItems comand. Here is an example: