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")

Answers


=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:

ReportItems!CellName.Value

Need Your Help

How to get the contents of a webpage in a shell variable?

linux bash shell wget

In Linux how can I fetch an URL and get its contents in a variable in shell script?

Call MouseEventHandler from another form

c# winforms

I create a MouseEventHandler in Main form :