How to call the function

[Siang Hwee]

Hi,

I plan to Sum the databand detail in each group footer band and then convert it to others format by calling the dll function. I manage to hardcode the dll path and set a reference at this moment. My question is how to convert the Sum value to others function.

Let assume my case is as below.

Emp No Emp Name OT
001 ABC 33
002 DEF 52
----------------------------------------------
Group Footer Band Total 01:25
----------------------------------------------

At the case above, i need to call a sum function {Sum(GroupHeader1,DynamicDataSchema.overtime)} but it will only return 85. In this case, i need to convert this 85 minutes to time which is 01:25. Assume i have a function call ConvertToTime(int min), how should i call my function and which event should i call?

[Edward]

Hi, Goh.

You can use that function as an argument for your custom function, as follows:

Code: Select all

{ConvertToTime(Sum(GroupHeader1,DynamicDataSchema.overtime))}

Thank you.

[Siang Hwee]

Edward,

Thanks. I tried and it works but with some problem. There are 10 columns which need conversion. However, the 2nd column total actually getting the next group summary info.

For example,

OT Lateness NPL
Emp001
01/01/08 10 0 0
02/01/08 20 0 0
-----------------------------------------------
00:30 00:15 00:00
-----------------------------------------------

Emp 002
01/01/08 10 5 10
02/01/08 20 10 10
------------------------------------------------
00:30 00:37 00:20
--------------------------------------------------

Emp 003
01/01/08 10 27 10
02/01/08 23 10 10
------------------------------------------------
00:33 00:00 00:20
--------------------------------------------------


Some of the report even funny, the first sum of data appear correctly as 12:34, the second row appear something like {Sum(GroupHeaderEmployee, DynamicDataSchema.number1}.

Please assist. Thanks

[Siang Hwee]

I think I know the exact problem. When my function found the figure is 0 it will return string.Empty where stimulReport will continue to calculate until it get not empty string, therefore it will go for next group of summary. Anyway, I already solve the problem by return some value instead of empty string.