ssrs 2005
I have a sales report where the user can choose if they are wanting to display dollars or quantity. In the matrix portion of the report I have the variable formatted by an expression similar to this so that when the user wants to see Price they get the $.
that works great.
now the tough part. On this report we also show a chart. On that chart I can switch the Quantity/Price easy enough, but we were using the chart's Y Axis "Format Code" as a "C" and there is no way that I see to put an expression in there. Do I format it in the Value section instead or does someone have a better idea to make the chart format the numbers based on a parameter?
I have a sales report where the user can choose if they are wanting to display dollars or quantity. In the matrix portion of the report I have the variable formatted by an expression similar to this so that when the user wants to see Price they get the $.
Code:
=IIF(Parameters!Display.Value="Price","C","N")now the tough part. On this report we also show a chart. On that chart I can switch the Quantity/Price easy enough, but we were using the chart's Y Axis "Format Code" as a "C" and there is no way that I see to put an expression in there. Do I format it in the Value section instead or does someone have a better idea to make the chart format the numbers based on a parameter?