Creating reports and dashboards | Stimulsoft community forum

I want to create a formula for displaying total work hours.

I have two DateTime fields,
ActualIn and ActualOut
If IsNull(ActulOut)
then
'0'
else

Total={DateDiff(AttendLog.ActualOut ,AttendLog.ActualIn)}

Please help me to achieve this.

In crystal report , i can do this,
But in stimulsoft,when i try to achieve this, the entire formula text is displaying.

Thanks in advance

Hello,

You can use the following expression in Text component: Thank you.

Thank you.............

Let me know one thing ,what about the syntax for if ..else in stimulsoft.net
As your post it is working,but iwant to include one more condition,
if(AttendLog.ActualIn==null) then '0'

i tried in this way
{(AttendLog.ActulOut == null ? "0" :AttendLog.ActulIn == null ? "0": DateDiff(AttendLog.ActualOut ,AttendLog.ActualIn).ToString())}

But it is not giving the expected result.

Thanks in advance....

Hello,

Also you can use function IIF() in expression: Thank you.

Thank you...
Do stimulsoft have any syntax help like crystal report??

Hello,

For most functions you can find description in dictionary.

Thank you.