<div>
<div class="content wysiwyg-content">
I am trying to simply filter out all the rows in a report that have a zero dollar amount in a certain column. &nbsp;I tried doing a filter for any value that is &lt;&gt;&nbsp;0 but i get an error that says, &quot;The processing of FilterExpression for the dataset cannot be performed. &nbsp;Cannot compare data of types System.Decimal and System.Double.
</div>
</div>


I am trying to simply filter out all the rows in a report that have a zero dollar amount in a certain column.  I tried doing a filter for any value that is <> 0 but i get an error that says, "The processing of FilterExpression for the dataset cannot be performed.  Cannot compare data of types System.Decimal and System.Double.

SSRS - Filter out zero dollar rows.  System.Decimal and System.Double Error

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.