Red Gate forums :: View topic - SSRS Pack - Please make dates sensitive to the Regional Sett
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

SSRS Pack - Please make dates sensitive to the Regional Sett

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
PDinCA



Joined: 25 Jul 2005
Posts: 500
Location: Costa Mesa, CA, USA

PostPosted: Thu Oct 25, 2012 10:05 pm    Post subject: SSRS Pack - Please make dates sensitive to the Regional Sett Reply with quote

"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.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 309
Location: Cambridge, UK

PostPosted: Tue Oct 30, 2012 5:42 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 500
Location: Costa Mesa, CA, USA

PostPosted: Tue Oct 30, 2012 7:46 pm    Post subject: Reply with quote

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:
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:
=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...
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group