Creating reports and dashboards | Stimulsoft community forum

Hi

FinalDuration field datatype is datetime in access database. In table few rows are blank without data. I am using the below formula to calculate the field value.

Hour(DownloadTourMaster.FinalDuration) * 3600 + Minute(DownloadTourMaster.FinalDuration) * 60+ Second(DownloadTourMaster.FinalDuration)

but in database table few rows are blank without data. so its displaying the runtime error
Null referenece as Object reference not set to an instance of an object.

So I need to write a check condition so that if field is blank , its not calculate the field value.

Please help me.

Thanks
Vikas

Hello,

Can you please send us a sample report with data, which reproduces the issue?

Thank you.

Hi Ivan

Issue is that if in database table are missing few records in finalduration column then runtime error is coming.

I want to check that if row does bot have the data in particular row , in that case its not show thw error. So i need to implement a IF condition.

Please see the attachment throuigh my first post.

Please suggest

Thanks
Vikas

Hello,

Use the following code:

Hour(DownloadTourMaster.FinalDuration.GetValueOrDefault()) * 3600 + Minute(DownloadTourMaster.FinalDuration.GetValueOrDefault()) * 60+ Second(DownloadTourMaster.FinalDuration.GetValueOrDefault())

Thank you.