Monday, March 12, 2012

Reverse Sign for Display

In Crystal Reports, there was a "reverse sign for display" property that could be checked for a number box. This was used for debits and credits (and such) so a negative number would be displayed as a positive and a positive displayed as a negative.

How would this work, or is there something simple, in Reporting Services?

Thanks for the information.

Just a simple way to implement this is =iif(fields!abc.value<0, abs(fields!abc.value), - & fields!abc.value)

|||

Use something like this for the value of the field:

=Fields!myField.Value * -1

That seems to simple. Is that what you're asking for?

|||Thank you both for your help. I knew it had to be a simple answer.

No comments:

Post a Comment