Object cannot be cast from DBNull to other types

[Mex]

I have a report that depends on database made of not null and null values which are updated by different users in different levels. The report should display all information including updated 1, but i keep on getting the above error when i run report after updating records in database but when i remove filtering it works but sometimes it refuses. Can any1 help me with solution on how to handle this error. My report should filter some records form others. For example; it should display information of hired staff from list of registered staff. when i remove the filtering it displays all staff info including those who are not posted for job. Help me with how to handle null values in report.

Regards
Mex

[Mark Maggiore]

I had the same problem, and after searching the Telerik support forums, it seems that nobody really had an answer.  I really think it is a bug in the reporting tool.  DateOfTravel is my filter field which would never be null.  After several hours, I finally figured out how to get around this.  In my dataset, I modified my query in the 'where' clause like this:
AND DateOfTravel IS NOT NULL

Hopefully this will help you.