Hide Column in SSRS report based on Image Container Type Field Value

(2) Share

Report

Posted on by CU05011735-0

Hi,

I wanted to hide the whole table column in the SSRS report (that stores Container type image field), if the image container(store value as bit) is blank / null.

In the Image Visibility & column visibility , I've used : =IsNothing(Field.value) & =IIF(Isnothing(Fields!fieldname.value),True,False)

but, Nothng works.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

you may want to use the aggregation of values using count expression for the column of the tablix

=IIF(Count(Fields!fieldname.Value) = 0, True, False)

Was this reply helpful? Yes No
CU05011735-0 6 on at

Like (0)

Report
Copy link

Link copied!

It doesn't worked.

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Did you try by replacing the positions of True and False (in the expression/condition) to make sure if it is not a data issue?

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @CU06011022-0

Sum() may not work on text fields, that was my reason to suggest Count()

Was this reply helpful? Yes No