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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics