February 12, 2010 at 10:30 am
I'm trying to format numbers in reporting services.
I believe I should be using "N2" for 2 decimal places but this just shows N2 on the report!
I've found the some syntax for the formating box and have tried this > (###.##;###,###.##;0.00) (positive formatting;negative formatting, zero formatting). I started using this when my 0 values disapeared from the report!
The report got created from a wizard and has placed my columns in text boxes.
Any one got any pointers?
Should my numeric results be in text boxes? Is the text box 'format' property the wrong thing to be looking at?
thanks
r
February 12, 2010 at 12:24 pm
So for 2 decimal places N2 or even N02 is the correct setting.
If you're just getting N2 on the pages then it seems like you may be putting the format directly into the textbox instead of the format property of the textbox. Your textbox should look something like this =Fields!ColumnName.Value Highlight that text box, right click on it and choose Properties... a Dialog box will open. Click on the Format Tab. Enter N2 in the Format code: textbox at the top. Click OK. You shoudl be all set.
As for it being textboxes, that's just the object that was chosen to represent your data. Most tables are a table full of textboxes with the dataset objects mapped to the various textboxes.
-Luke.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply