Hi,

I'm new to Crystal. I sure hope someone will be able to assist me in this fairly easy problem.

I have sets of data that returns values for each of the 4 quadrants. An example:

Quadrant A: 7
Quadrant B: 20
Quadrant C: 8
Quadrant D: 2

The above is for Group 1. I also have a Group 2 with its own data. I'm using a stored procedure in MS SQL to return the data. The proc takes a GroupID which then returns the data as shown above.

I added 2 Commands using the Database expert, one for each Group. This allowed me, when designing the bar chart to 'Show values' from both commands. (Using a 'For Each Record' on the Quadrant)

This is all good. So my question is this. I don't always know how many Groups are in a Company (Groups belongs to Companies). Therefor I need to firstly get all the groups for the company, secondly get all those groups' data, and 'Show Values' for all those results.

I'm comfortable in getting all the groups, and getting their data. My issue is how to bind the bar chart, to dynamically display all the results. I.e. different colors, and bars.

I sure hope I explained this well.

Thanks!