CODEWITHSUNDEEP
reporting-servicesssrs-2012
sqluser
sqluser

Reputation: 403

SSRS conditional result

I am trying to create a report for prepayments/extra payments before their actual time of payment. how can I tell in query to show the whole row with the extra amount, if the condition is true. example:

IF (Field.A+Field.B)<=(Field.C+Field.D); then skip this row and check the next row; but if (Field.A+Field.B)>(Field.C+Field.D), then show this row with the extra amount in specified cell.

Thanks!

Upvotes: 0

Views: 29

Answers (1)

Chris Latta
Chris Latta

Reputation: 20560

Select the row and set the Visibility-Hidden property to

=(Field.A+Field.B)<=(Field.C+Field.D)

Upvotes: 1

Related Questions