We host a SaaS application that uses SQL Server Reporting Services 2008 (non-R2) for reporting functionality, and our users use a mixture of Report Builder 1.0 and Report Builder 2.0 for designing reports.
We are in New Zealand, and our users are almost exclusively in New Zealand/Australia. Therefore, everyone wants their dates in D/M/Y format, their default page size to be A4, and their units of measure to be metric (i.e. cm/mm).
A constant frustration for them is that both RB1.0 and RB2.0 appear to ignore our local settings by default, despite the documentation saying things like "By default, your local settings determine which page unit is selected" as in here:
I get this issue even though the regional settings on my local machine, and on the report server are set to "English (New Zealand)". This occurs in both the Report Builder 1.0 that is once-click launched from Report Manager, and in Report Builder 2.0 (10.0.4000.0) that I have installed locally.
We are about to upgrade to SSRS 2012 which supports RB3.0, and I note that RB3.0 does appear to obey our regional settings. However, the version of RB1.0 that SSRS2012 pushes down to clients when they click the "Report Builder" button in Report Manager still has the problem.
We will likely continue to use both RB1.0 in parallel RB3.0 depending on the sophistication of the user and the nature of their requirement. Does this mean that our community of RB1.0 are forever cursed with the need to fiddle with their report settings or learn to live with the US date format?