I am trying to create a bar chart that looks like this:
http://www.webfound.net/chart3.jpg (sketch from a user).
ignore the first set of bars in the above, I'm just trying to create the rest for AZ and IL..the other 2 sets of bars in my chart in SSRS 2005
I have created a dataset that runs a stored proc and resturns the following values:
http://www.webfound.net/values1.jpg
My bar chart looks like this in layout mode:
http://www.webfound.net/chart_layout.jpg
And my results do not look like what I want:
http://www.webfound.net/chart_results.jpg
Questions
1) Why is it not giving me just 3 bars for IL and 3 bars for AZ based on the series groups GrossGoal, InHouse2, and ProjFee? It's instead just showing one bar for all 3 fields - as seen in the legend
I should be getting 3 columns per category...see below
http://msdn2.microsoft.com/en-us/library/ms160349.aspx
"Series groups are optional. The series group list is used to provide dynamic groups of data in the chart. For example, in a column chart, data from the categories list will result in a column for each series group, in each category."
http://msdn2.microsoft.com/en-us/library/ms155847.aspx
2) How can I get this to work for both IL and AZ? this is more complicated than originally thought
Was able to resolve this with the help of Jon http://weblogs.sqlteam.com/jhermiz/category/197.aspx
I had to do 2 things to get this to work:
1) do not use any fields in series
2) add GrossGoal, InHouse, and ProjFee fields into the Data section of the bar chart
3) Add the Category field that contains the group names (which I was already doing)
No comments:
Post a Comment