I don't have the time now to check your code, but if you stretch the field/label, you will be able to see which value you really have, and not only the stars. If you have a report, any number which is bigger than you have made room for, will show as stars. Increasing the size, will show the real value.
>hi,
>thanks, but i think i have somthing rong, at my report.
>i need to sum myfield plat atmyreport, this field is time as 04:45...
>i try to put the code as
>
>under reportexpression-->expression(plat),format ##:##:## ,common
>VAL(left(plan, 2))*3600 + VAL(SUBSTR(plan, 4, 2))*60 + VAL(SUBSTR(plan, 7, 2))
>
>
>
>
>
>>***** means overflow, you have to make the field wider and/or allow more digits.
>>
>>>hi,
>>>
>>>i see at my report result ****,
>>>thanks
>>>
>>>>> nothing happend.
>>>>
>>>>Did you places a field to show the result? What does it show?
>>>>
>>>>Well. then we'll need to drill it down :-)
>>>>
>>>>Place a field in your details to show the value of nTime on every detail row and check if it shows correct value.