I want to summarize a column with time intervals (total duration of conversations). Data type of the field in my database is string (varchar). I tried to convert the string to datetime, but I always got same format: 1900-01-01 hh:mm:ss. I tried to convert with 108 or 8, it doesn't matter what I write inside the convert function, 1900-01-01 is still there. I can get ride of 1900-01-01 if I change placeholder properties (formatting number and date) in the report but I still can't summarize the column. I even tried with following expression =System.TimeSpan.FromTicks(Sum(Fields!Total_Duration_of_Conversation.Value)) but I just got #error. I even tried to write some UDF in the database but I still can't use SUM either in the query or in the report. Any suggestions how to solve this, I just wanna have total and grand total, it doesn't matter if I do it in my database and or in the report. Please help! :)
Submit an article or tip