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

Developer technologies | .NET | F#
Developer technologies | .NET | F#
A strongly typed, multi-paradigm programming language developed by the F# Software Foundation, Microsoft, and open contributors.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,586 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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.