Posted by Andy Brown on 26 July 2011 | 2 comments
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:
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
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
A full-blown discussion forum is being built for this site, which will allow you once more to add comments and discussion threads.