hide 0 on X-axis in SSRS report
Hi,
Is ther any way to avoid displaying 0 on X axis so that it would display count if it is more than 1
thank you,
vishal
May 6th, 2011 1:06pm
got the answer... It was displaying 0 for group which does not satisfy the condition and would not display... solution is in chart properties in the data tab, edit the group and type that if count is 0 then display blank... some thing like...
=IIF( Count(Fields!DisplayAnswer.Value) = 0,
"",Count(Fields!DisplayAnswer.Value))
Free Windows Admin Tool Kit Click here and download it now
May 6th, 2011 2:39pm