SSRS Pack - Please make dates sensitive to the Regional Sett

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

SSRS Pack - Please make dates sensitive to the Regional Sett

Postby PDinCA » Thu Oct 25, 2012 10:05 pm

"09 - Alerts" shows the dates as UK-English (dd-mm-yyyy) along the x-axis. Being English, this is understood, but being in the U.S., and having the Server set to English - United States, one needs to see the date formatted per the locale.

Please fix the RDLs and re-deploy the SSRS pack. Thanks in advance.
PDinCA
 
Posts: 516
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA

Postby chriskelly » Tue Oct 30, 2012 5:42 pm

A member of the development team has has a look at the report that you have mentioned. He has changed it to 'something sensible'. Apparently this is not locale specific, but should better. I haven't tested it myself yet though.

The new version is now available for download.
Please let me know how it goes.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby PDinCA » Tue Oct 30, 2012 7:46 pm

Sadly, that didn't change anything.

The Alerts query in the RDL has two places where the CONVERT() function states 105 as the format code - that's ITALIAN.
Code: Select all
CONVERT (varchar, DateTimeRaised, 105) AS AlertDay
     , CASE
          WHEN @TimeInterval = 'Hourly' THEN CONVERT (varchar, DateTimeRaised, 105) + ':' + LTRIM(STR(DATEPART(hh, DateTimeRaised))) + 'h'
          ELSE NULL
       END AS AlertDayHour

Can I suggest that the RDL be modified so that when "Daily" just the date portion is returned, else the date plus hour in a CAST( x AS datetime) field (from your util.tick-conversion). IMO, the "h"-style can be disposed of in favor of a standard-appearance of date+hh:00 to obviate format and content issues. Then code an expression in the chart's x-axis Format code, which it can have, despite there not being an expression icon next to it:
Code: Select all
=IIF(Parameters!TimeInterval.Value="Daily","d","g")

You won't then need the expression for the x-axis label value.

This boils down to: allow formatting to be performed upon presentation, i.e., in NOT in the underlying query...

How does this sound to you...
PDinCA
 
Posts: 516
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests