Crystal report does not return the value as shown in SQL query

[GSG]

Hello,

I am struggling to show the BreakTime value if it meets the condition but, Crystal report shows the zero value. If I execute the SQL report which is generated by Crystal report it has non-null values. Here is the formula created in Crystal report:

If {Events.SCHID}=Previous({Events.SCHID}) and {EventStrings.EVSTRNAME} = Previous({EventStrings.EVSTRNAME}) and {Events.EVSTRID}={EventStrings.EVSTRID} and {Events.ACTIVITY} = 8 then ({Events.DWELLTIME})/3600

Please let me know if you have any other questions. I am very new to Crystal report. Hopefully was able to explain my concern. Thanks

GG

[former_member205840]

Hi

Also, open the formula and on top of formula editor, you will see 'Exception for Nulls', click on the drop down and select 'Default Values for Nulls' and save the formula and see.

Thanks,

sastry

[GSG]

Thank you Sastry, I tried as you said but no luck.

Gurpreet