Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
toddthompson
Starting Member
1 Post |
 Posted - 2007-10-05 : 18:21:51
|
| I’m stuck and I haven’t been able to find anything about this on the internet despite hours of research.Basically I need to format a duration (in seconds as integer based on DateDiff function) into a simple chart as an aggregated amount of time in the y-axis.For example, a retrieval time could be between 1 sec (or “00:00:01”) to many hours (for example 2,987,557 or “829:52:37”).I’ve tried several methods including simple formatting (FormatDatetime) to DateTime.FromOADate and even custom code but I cannot get SSRS to understand that it is a value of time, not a date. This is so easy to do in Excel that my boss is having a hard time understanding why I can't get this to work in SSRS.Any help is greatly appreciated!!!Thanks,Todd |
|
|
|
|
|
SSRS 2005 - Time as Aggregate in y-axis