开发者

VBScript in Reports Expression Editor, filtering out certain values

开发者 https://www.devze.com 2023-01-08 20:40 出处:网络
I have a report that need null values replaced with N/A.It works for x amount of rows until the null value is hit then the rest of the data needing to be displayed just goes away.

I have a report that need null values replaced with N/A. It works for x amount of rows until the null value is hit then the rest of the data needing to be displayed just goes away.

Here is my expression

=iif(Fields!PastBaseline.Value is nothing, "N/A开发者_开发百科", Round(Fields!PastBaseline.Value))

Anyone know what I am doing wrong?


I have used similar things many time and it works fine. Try it like this:

=iif( IsNothing( Fields!PastBaseline.Value ), "N/A", Round(Fields!PastBaseline.Value))

If this does not work can you see if there are any errors or warnings.

0

精彩评论

暂无评论...
验证码 换一张
取 消