Column Chart not all Category Group details are displaying in the x axis SSRS 2008
Hi All,
I am trying to create a report which show the values on chart data based on States in Australia.
below is my SQL query
SELECT [State], SUM(Value) AS Value
FROM Country
GROUP BY [State]
I am keeping the Sum(value) in the Chart Data and [State] in the Category Groups. I can able to see only three States on the x-axis and i have more than three states but when it come to chart data it's showing all the sates value figures. Is there anyway
i can show all the states on the x-axis and do i need to set any property ??Dasari
August 10th, 2011 8:05pm
Goto Horizontal property in chart and make interval =1
Free Windows Admin Tool Kit Click here and download it now
August 10th, 2011 8:18pm