Number format bug in SSRS 2008 R2
Are we alone in continually coming across this bug? When you choose to change the number format in SQL Server Reporting Services 2008 R2 reports, the relevant dialog box vanishes!

Posted by Andy Brown on 26 July 2011 | 2 comments

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Number Format Bug in Reporting Services 2008 R2

Are we alone in experiencing this?  SSRS 2008 R2 is a great upgrade, and solves many of the oddities of SQL Server Reporting Services 2005.  However, there does seem one obvious - if small - bug.

The problem is to do with number formatting:

Text box properties dialog box

You can set a number or date format using this dialog box

You can right-click on any text box to set its properties, and use the Number tab above to focus in on date and number formats.  All of this works well.

The problem comes after you've been using SSRS for a few minutes, when choosing the Number tab makes the above dialog box vanish!  The only way to get it back again seems to be to come out of SSRS and go back in again.

You can of course use the properties window to change a text box's number format, but it's a lost less user-friendly, and you need to know how to construct Excel-style number format codes.

Any thoughts, anyone?

This blog has 2 comments

Comment added on 23 May 2012 at 06:11 GMT

This same bug has driven me nuts.  I'm glad someone else has come across it - it's nice to know that I'm not the only one.

I'm in Australia and find that our date formatting, similar to yours in the UK, can cause grief.  I've just gone back to BIDS 2008 R2 from SSDT 2012 because of date issues surfacing in VS2010 that I couldn't resolve (among other things like the expression editor not working if I hit my right arrow key, etc).

I just found this blog today - lots of nice info

Reply from Andy Brown
I worried whether it was just me! Always nice to have confirmation. I haven't started using 2012 yet - look forward to new features!
Comment added on 06 June 2013 at 22:06 GMT
I just encountered this problem this morning of 06/06/2013 and I thought I had done something wrong. I undid all the changes I had made up until I started noticing that I could not  bring up the formatting options under Numbers property and it still would not show up. I opened an old report to reformat the numbers, as a test and still clicking on the Numbers properties options will not opened up. What a pain.   Glad to know that it's not me.   Thanks.
Reply from Andy Brown
Weirdly, the problem doesn't show up in Report Builder 3.0, an almost identical product.

A full-blown discussion forum is being built for this site, which will allow you once more to add comments and discussion threads.