Page 1 of 1

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

Posted: Sun May 31, 2009 8:46 am
by 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

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

Posted: Mon Jun 01, 2009 3:10 am
by 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.

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

Posted: Mon Jun 01, 2009 5:16 am
by isoft
That worked great!

Thank You!