Expression in Text property of 'Text3' can't be evaluated!

[isoft]

Hi.

In my report I have a databand with data that has a column that represents some integer values. In ReportSummaryBand in a TextBox I use the Sum function with that column to summarize all the values. Actually this value is the total number of seconds, so I would like to show it in the HH:mm:ss format. So, in the GetValue event of that TextBox I used this code:

Dim ts As New TimeSpan(0,0,e.Value)
e.Value = ts.Hours & ":" & ts.Minutes & ":" & ts.Seconds

The problem is that I am getting the following error:
"Expression in Text property of 'Text3' can't be evaluated!"

It's as though the value is Null and not the result of my Sum function.

Please, can You help me.

Thank You.
Ivan

[Ivan]

Hello,

Please try to write following code in GetValue event:

Code: Select all

Dim ts As New TimeSpan(0, 0, Totals.Sum(Products, Products.UnitsInStock))
e.Value = ts.Hours & ":" & ts.Minutes & ":" & ts.Seconds

Thank you.

[isoft]

That worked great!

Thank You!