Rdlc Report Visibility Problem

sjen

Hello I am working on nav report and I have an empty string on my report line and I only want to display if my sales type not empty.

I went to empty string line and added visibility expression

=IIF(Fields!Sales_Line_Type.Value = " ",true,false)

It is almost working but still prints a line for the last line. I can add more line and the empty string line goes to the last line.



See the last empty line, I want that gone. How can I do that?

SanderDk

without knowing you dataset it is not that easy to tell, perhaps you can group you way out of this one.
You can also try to check the length instead of doing a compare.
=IIF(Strlen(Cstr(Fields!Sales_Line_Type.Value)) > 2),false,true)

borealis

I do not know what your dataset values are, but it's worth noting that in a dataset the value "" (empty string) and <> (no value) are distinct. You can test for it with IsNothing, but SanderDk's recommendation of checking the strlen will work for both.

If you do the Help | About this report to see the dataset values null values will show up as the <> value.

SanderDk

without knowing you dataset it is not that easy to tell, perhaps you can group you way out of this one.
You can also try to check the length instead of doing a compare.
=IIF(Strlen(Cstr(Fields!Sales_Line_Type.Value)) > 2),false,true)

borealis

I do not know what your dataset values are, but it's worth noting that in a dataset the value "" (empty string) and <> (no value) are distinct. You can test for it with IsNothing, but SanderDk's recommendation of checking the strlen will work for both.

If you do the Help | About this report to see the dataset values null values will show up as the <> value.

sjen

=(Fields!Sales_Line_Type.Value = " ") or (IsNothing(Fields!Sales_Line_Type.Value))

IsNothing worked thank you