sum two string field

ronak · Post by **ronak** » Tue Aug 09, 2011 12:57 pm

hi i have a time field in string format now i want to sum time at end of my report
i have a string field like this data 05:30 16:10
now i want to sum these clock field

Post by **HighAley** » Wed Aug 10, 2011 3:04 am

Hello.

ronak wrote:hi i have a time field in string format now i want to sum time at end of my report
i have a string field like this data 05:30 16:10
now i want to sum these clock field

Please try to use next expression

Code: Select all

{TimeSpan.Parse(YourField1) + TimeSpan.Parse(YourField2)}

Thank you.

ronak · Post by **ronak** » Wed Aug 10, 2011 3:28 pm

thanks
i dont have a two field i have a data table that contain dynamic field of time and after that in a footer band i want to sum a fields that contain a time

Post by **HighAley** » Thu Aug 11, 2011 6:01 am

Hello.

ronak wrote:thanks
i dont have a two field i have a data table that contain dynamic field of time and after that in a footer band i want to sum a fields that contain a time

In this case you can create variable of timespan type and accumulate time in it. Please see attached report.

Thank you.