August 30, 2006 at 1:20 pm
I am having a problem that I am sure is very easy to fix but none the less I am stumped. I have some text boxes in a table that may produce negative numbers when the report is executed (previewed) the numbers are displayed differently and I am not sure how to make them the same. In one column a negative comes across as -## and in the other it comes across as (##), the first is a number column the second a currency both are formatted (right click on the text box and properties...) the same except for the $ sign just a whole number no decimal. How do I make them both either -## or (##) it doesn't matter which as long as they are the same.
Thanks in advance!!
Kurt Kracaw
August 30, 2006 at 1:48 pm
There is probably an easier way, but off the top of my head I would use an expression.
=iif(Fields!FieldName.Value >= 0,Fields!FieldName.Value,"(" & Fields!NumberOfLocates.Value & ")")
September 1, 2006 at 12:37 pm
Thanks for the suggestion I will give it a try
Kurt Kracaw
January 8, 2007 at 3:32 pm
Hi Kurtis,
Did you manage to solve your problem? You say the text boxes are formatted the same, but do you have a negative format specified? For example I use the format string: #,##0 ;(#,##0);
The only problem is I cannot get my numbers to line up correctly as the positive numbers need a space afterwards to match where the bracket goes for the negative numbers. This would not be an issue for you if you are happy with the minus sign (but I need brackets - please let me know if you have a solution for that).
Regards,
Mark Finnie
January 11, 2007 at 7:25 am
Sorry it took so long for me to get reply!
I was able to get all of them the same. As for the problem with the ( ) I don't have an answer for you. I never really noticed this due to the spacing we use between rows, but you are correct there is a problem.
Kurt Kracaw
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply