CODEWITHSUNDEEP
reporting-services
Tariq Khalaf
Tariq Khalaf

Reputation: 89

Hide duplicate row ssrs 2005

I need help trying to hide a row in ssrs 2005 ive tried select distinct and putting an

=iif(Previous(Fields!food.Value) = Fields!food.Value,Nothing,Fields!food.Value)

my table is a lot bigger than this but just an example 

Food dish           type    Damaged
Italian soup        A       4
Pizza Supreme       B       13
Pizza Supreme       B       12
Spaghetti           C       10

and I want Pizza supreme line 2 to be hidden Thanks

Upvotes: 1

Views: 1847

Answers (1)

Ian Preston
Ian Preston

Reputation: 39566

To hide rows you need to set the Row Visibility based on an expression using Previous.

With your data:

enter image description here

I have a simple table:

enter image description here

I have set the Row Visibility to be expression based:

enter image description here

=IIf(Previous(Fields!food.Value) = Fields!food.Value, true, false)

This hides the row as required:

enter image description here

Upvotes: 3

Related Questions