| Author |
Message |
PDinCA
Joined: 25 Jul 2005
Posts: 469
Location: Costa Mesa, CA, USA
|
 Posted: Thu Oct 25, 2012 10:05 pm Post subject: SSRS Pack - Please make dates sensitive to the Regional Sett |
 |
|
"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 |
|
 |
chriskelly
Joined: 19 Apr 2010
Posts: 262
Location: Cambridge, UK
|
| Posted: Tue Oct 30, 2012 5:42 pm Post subject: |
|
|
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 |
|
|
PDinCA
Joined: 25 Jul 2005
Posts: 469
Location: Costa Mesa, CA, USA
|
| Posted: Tue Oct 30, 2012 7:46 pm Post subject: |
|
|
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 |
|
|
|
|
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
