当前位置: 动力学知识库 > 问答 > 编程问答 >

sql server 2008 - hiding rows that contain no values

问题描述:

I would like to hide rows in my report that contain no values in a certain set of fields.

This question is helpful

How to filter rows with null values in any of its columns in SSRS

i do not understand how to check whether multiple fields are null.

currently, i am doing this:

and under the visibility:

and i typed this expression:

=iif(fields!Jan.Value

+fields!Feb.Value

+fields!Mar.Value

+fields!April.Value

+fields!May.Value

+fields!June.Value

+fields!July.Value

+Fields!Aug.Value

+Fields!Sept.Value

+Fields!Oct.Value

+Fields!Nov.Value

+Fields!Dec.Value="",TRUE,FALSE)

but i am getting this error:

how do i hide a row if the values are null or blank?

网友答案:

I know this solution may not be the best, but it works:

=iif(fields!Jan.Value
    +fields!Feb.Value
    +fields!Mar.Value
    +fields!April.Value
    +fields!May.Value
    +fields!June.Value
    +fields!July.Value
    +Fields!Aug.Value
    +Fields!Sept.Value
    +Fields!Oct.Value
    +Fields!Nov.Value
    +Fields!Dec.Value=0,TRUE,FALSE)

I realized since the fields are all int, i can just add them together and check whether they add up to 0.

网友答案:

You need to use AND (if all of the values need to be 0 to hide the row), and try using LEN()

=iif(len(Fields!Jan.Value) = 0 AND len(Fields!Feb.Value) = 0 AND len(Fields!Mar.Value) = 0,True,False)

I would also use the Visibility property accessed by highlighting the row, and using the Properties window rather than through the Right-Click menu.

网友答案:

Does the qualifier have to be any row? I would use a 'Switch' statement then if those are all OR statements and change ISNOTHING(). "" is something according to SSRS. Looks like you got the answer you needed but I generally would do this if this comes up in the future:

=switch(
 Isnothing(Fields!Jan.Value), TRUE
 Isnothing(Fields!Feb.Value, TRUE
 etc.
 , FALSE)

The key to switch is the columns must be different, not the same column with different expressions on it.

分享给朋友:
您可能感兴趣的文章:
随机阅读: