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 |
|
bushfoot
Yak Posting Veteran
53 Posts |
 Posted - 2010-11-02 : 11:32:38
|
| I have a column grouping report and I have enabled the subtotal column.The column data is an integer that represents time in seconds.The expression in the column is =Code.GetDurationAsString(Sum(Fields!TimeInSeconds.Value))(converts time in seconds to hh:mm:ss)The subtotal column is invalid it is always ONE of the no subtotal column values. It appears that the total column can NOT be summed before the call to code.If I remove the call to Code.GetDurationAsString, the value is ok. The problem is that I can not show the time on the report as time in seconds. Is there another way that I can convert the integer to time ? |
|
|
|
|
|
Column Grouping with Subtotal Column - incorrect