September 15, 2009 at 11:32 am
I have a simple line chart I've made in Report Builder 2.0. Revenue (data) by Fiscal Year (category). I want to filter the chart so that it only shows a Fiscal Year when Revenue is <> 0. Revenue is the data type "float".
When I add a chart filter [Revenue] <> 0 and try to run the report I get the error message:
"An error has occurred during report processing. The processing of FilterExpression for the chart 'Chart1' cannot be performed. Cannot compare data of types System.Decimal and System.Double. Please check the data types returned by the expression."
I tried setting the filter Value to the expressions CDbl(0) or CDec(0) and got the same error messages.
Any suggestions?
December 24, 2009 at 10:45 am
right click on chart ->chart properties>filters>select correct expression which is related to year select operator != then value = blank or =0.. should work.. it worked for me
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply