Problems with Bar Chart Series Groups - SSRS 2005

Last Post 07 Mar 2006 10:53 AM by dba123. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dba123
New Member
New Member

--
07 Mar 2006 10:53 AM
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 / Problems
-------------------------

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


Acceptable Use Policy
---