negative numbers are printing positive!

[robbclaxton]

A pre built report has suddenly started to show negative numbers as positives and vice versa.

I have checked the DB and the numbers appear to be stored correctly, so something has changed in my report..

can anyone help?

 

[IanWaterman]

Right click number field and go to format.

Click customise, you will probably see Reverse Sign for display is checked.

Ian

 

[robbclaxton]

Ian this field is unchecked..any other ideas?

 

[IanWaterman]

The only other possibility is that you are

1 using a formula which reverses sign, but I assume you would have spotted that.

2 you are not actually using the Database table but a view which reverses sign.

For latter go to Set data source, drill down into table using +, and make sure you are not pointing at a view aliased as the table.

Ian

 

[robbclaxton]

Ian - I am referencing a view, that did not behave in this way on Friday of last week. I have sought feedback from my dba, but being the 4th July I am not holding out hope.