Share via

How to hide a row in ssrs if and value is null

Jeannie Jones 0 Reputation points
2023-08-02T04:18:34.5833333+00:00

I have a SSRS report that has no groupings but some of the data is Null and if the data is null I need to hide the row. I have tried to hide the row and since there are no groupings I can't hide rows. I tried to hide individual columns using IIF(IsNothing( Field!Name.Value), False, True) and that does not work.

Not sure if this can be done with code or not, But I am stuck.

User's image

.NET F#
.NET F#
.NET: Microsoft Technologies based on the .NET software framework.F#: A strongly typed, multi-paradigm programming language developed by the F# Software Foundation, Microsoft, and open contributors.
106 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 45,111 Reputation points
    2023-08-02T05:08:19.71+00:00

    if the data is null I need to hide the row.

    I don't see any NULL in your screenshot.

    Filter them out from the query result set.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.