CODEWITHSUNDEEP
reporting-servicesreportingservices-2005
Panos Vlachopoulos
Panos Vlachopoulos

Reputation: 1

How can I hide specific duplicate rows in SSRS 2005?

Here's my problem: I have some some duplicate rows (rows with the same ID). What I want is to hide rows based on a specific's column value. The mentioned column is obviously not the ID column (it's the Description column).

I tried this on the Row Visibility (Expression):

=IIF (Fields!Incident_ID.Value = Previous(Fields!Incident_ID.Value)

AND

ReportItems!Description.Value <> "Incident Status Change to Work In Progress from Open", true, false)

So, I want to exclude the rows in which Description is not equal to 'Incident Status Change to Work In Progress from Open'.

The message that I get is:

The Hidden expression for the table 'table 1' contains an error: Object variable or With block variable not set.

Any ideas on this?

Thanks in advance

Upvotes: 0

Views: 333

Answers (3)

programmie
programmie

Reputation: 41

SSRS can be wonky sometimes. Try parenthesizing: 

 =IIF(((Fields!Incident_ID.Value = Previous(Fields!Incident_ID.Value)) AND (IsNothing(Fields!Description.Value) = false) AND (Fields!Description.Value <> "Incident Status Change to Work In Progress from Open")), true, false)

Upvotes: 0

David Tansey
David Tansey

Reputation: 6023

I think you are probably getting that error because there are one or more rows in your query result that have a NULL value in the Description field.

You could test this theory by simplifying your expression to this:

=IIF(Fields!Incident_ID.Value = Previous(Fields!Incident_ID.Value), true, false)

just to see if you can run the report without error.

If that works, then you need to add a test for a NULL value as part of the larger condition test, to get back to the logic you intended.

Try this:

=IIF(Fields!Incident_ID.Value = Previous(Fields!Incident_ID.Value) AND IsNothing(Fields!Description.Value) = false AND Fields!Description.Value <> "Incident Status Change to Work In Progress from Open", true, false)

This should avoid the error by preventing the evaluation of the last part of the condition, when the Description has a NULL value.

Upvotes: 1

NewGuy
NewGuy

Reputation: 1030

I think you're on the right track just using ReportItems instead of Fields!

=IIF(Fields!Incident_ID.Value = Previous(Fields!Incident_ID.Value) AND Fields!Description.Value <> "Incident Status Change to Work In Progress from Open", true, false)

Upvotes: 0

Related Questions