enforce integer for axis label

hello all,

i have stacked bar in tablix group repeats many times.  max value y axis anywhere 3 300.  300 auto interval works fine values such 50, 100, 150, etc.  when max 3 auto interval 0.25, 0.5, 0.75, etc.  don't want fractional values shown, integers.  

colin.

hi colin,

here didn’t give version of sql server reporting service. generally, in sql server reporting service2005, might not able control value of minimum, maximum, interval @ our own will. in sql server reporting service2008, write expression reset these property’s value control whether display fractional values or not, mentioned 0.25,0.5,0.75 etc. steps ssrs2008 below:

1.     right-click y-axis, , select axis properties

2.     in value axis properties dialog box ,you see property of interval, click fx button type in control expression. such =iif(max(fields!datafield.value)<4,1,0). interval value on y-axis 1 if maximum <4, otherwise, interval auto.

if have question, please feel free ask.

regards,

challen fu

SQL Server  >  SQL Server Reporting Services, Power View