ReportDesigner error loading template with filters

[Stratos Geroulis]

Hello,

I am having trouble loading and running an RDL file in the designer that has column filters. When there are no filters everything works fine. When I add a filter to a column (to filter out empty lines) the template works on the designer with no problem. I save it and exit the designer and then open the designer and reload it. Then, the preview throws an unexpected error with the following trace:

StackTrace: 

   at Syncfusion.RDL.Data.ReportModel.GetModel(ReportItem reportItem, Boolean isTablixChild, Boolean isKeepTogether, String dataSetName)

   at Syncfusion.RDL.Data.ReportModel.ParseExpression()

Attached is a sample RDL file that creates this error along with an xls file with sample data.

Any advice would be highly appreciated.

Attachment: reporting_sample_2c0388fa.zip

[Vinoth Srinivasan]

Hi Stratos, 

 

Thanks for contacting Syncfusion support. 

 

In the report which you have shared, the filter value is used as empty which is not a valid value to filter the rows of empty data which lead to the exception. We have to set IsNothing as expression to filter the empty values of row. We have modified your report and it can be downloaded from the below location. 

 

http://www.syncfusion.com/downloads/support/forum/126132/ze/simple-167674578 

 

Regards,   

Vinoth S. 

[Stratos Geroulis]

Thank you very much, that makes a lot of sense. The confusing part was that the way I had it setup it was working before you closed the editor and reloaded.

Thanks again!

[Vinoth Srinivasan]

Hi Stratos, 

Thanks for your update. Please let us know if you need any other assistance.  

Regards, 

Vinoth S.