Reporting Services - Chart x-axis - define HH:MM for a group category?
I have a chart that I am grouping data by Year, Month, day then Hour (this is to view server performance data) - however i need the label for the hour grouping to be in the format of HH:MM and not H:M by using expression
=HOUR(Fields!Timestamp_perfmon.Value) &":"&MINUTE(Fields!Timestamp_perfmon.Value)
...but this as you would kind of expect returns 0-23:0-5 ie 18:1 whereas i need it to return 18:12 or 8:12 PM..
when i change the format code for the x-axis it unfortunatey screws up all my other group by values and labels..
can anyone help?
October 5th, 2007 1:11pm
Hi dems01,
What about setting the Label property for the Axis group to the following:
=Right("0" & HOUR(Fields!Timestamp_perfmon.Value),2) & ":" & Right("0" & MINUTE(Fields!Timestamp_perfmon.Value),2)
I hope this helps.
Best regards, Christopher Sorensen
Free Windows Admin Tool Kit Click here and download it now
December 30th, 2010 1:51pm