Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

negative numbers are printing positive!

Status
Not open for further replies.

robbclaxton

IS-IT--Management
Dec 12, 2005
13
GB
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?
 
Right click number field and go to format.

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

Ian
 
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

 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top