Report Parameter -filter is not working

[dhinesh]

Hi,

I have added a report parameter with display member and  value member, but datasource is binded in the codebehind file. Am able to see the drop down with the display member values, but when i add a report filter using this report parameter, its throwing an error-"An error has occurred while processing Report 'ReportName':Object cannot be cast from DBNull to other types".

Only after adding the filter, am facing this error, without the filter the report displays the chart with the actual values.

I have tried adding the filter to the report and also to the report parameter available values, but none works.
please help, asap...



 

[Peter]

Hi Dhinesh,

The error is caused by null value that can't be handled. Our suggestion is to use IsNull function for the nullable fields. 

All the best,
Peter
the Telerik team

[Nader]

May Allah`s peace , mercy and blessing be upon you 

I have exception Message!
http://s16.postimage.org/v43dcb579/Run_Time_Error_Telerik.jpg

[Peter]

Hello Nader,

Do you use Telerik Reporting Q3 2010 release? If this is the case we have already introduced a fix and our suggestion is to upgrade to a newer Telerik Reporting version. 

Regards,
Peter
the Telerik team

[Nader]

Thank you for fast response
Yes I use Telerik Reporting Q3 2010