CODEWITHSUNDEEP
expressionrdlcssrs-grouping
alicewilliam86
alicewilliam86

Reputation: 513

avoid grouping on empty values RDLC

I have a column group on a datafield. I need to group only when there is a value in the field. Right now it groups on the NULL field too.

I have tried the following group expressin:

=Fields!ScaleName.Value <> "" OR Fields!ScaleName.Value <> Nothing

Upvotes: 1

Views: 2580

Answers (1)

tezzo
tezzo

Reputation: 11115

You can resolve this problem using a Group Filter (right click on group > Group Properties > Filters):

  • expression: =IsNothing(Fields!ScaleName.Value)
  • type: Boolean
  • operator: =
  • value: =False

Upvotes: 2

Related Questions