Reputation: 2783

SSRS Conditional Border Report

I have report as table component. I want to apply the following logic:

If value INCID is not null, the border should be "Solid" (meaning it should have border),
If value INCID is null, the border should be "None" (meaning the table should have no border).

I used =IIf(IsNothing(Fields!INCID.Value) = 1,"Solid","None") but it doesn't work. Where could be the problem? If I apply this and save this settings and then go back to the expression, it is not saved.

Upvotes: 2

Answers (3)

Sudarshan Kadam

Reputation: 101

This issue has been fixed in Sql 2016 CU https://support.microsoft.com/en-us/help/4527378/cumulative-update-11-for-sql-server-2016-sp2

Upvotes: 0

MPJ567

Reputation: 553

3 Years late, but my answer was different and maybe will help someone else one day.

I was able to make the expression work by entering it into the BorderStyle Properties.

Click on a given cell > Open Properties > Expand BorderStyle > Choose desired Side of Cell > Enter iif expression.

For example the following worked for me:

=iif(MAX(Fields!DistinctDevicecount.Value) > 1, "Solid", "None")

Upvotes: 5

DNac

Reputation: 2783

OK, this seemed to be the problem.

Upvotes: -1

SSRS Conditional Border Report

Answers (3)

Related Questions