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

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 0 threads Add post