creating formulas based on stored procedure fields?

[retygh45]

Using CR11, I inherited a very long SQL 2000 stored procedure, which outputs a grid to Crystal:

Client review_type1 review_type2 review_type3
johnson 25 32 75
smith 33 44 21
jones 45 20 35

This works fine, but now, based off this data, I'm trying to create some graphs and charts. So, for example I'd like to make a bar chart showing each client and their review_type1 amounts.

But since they're coming from a stored procedure, Crystal will not let me create formulas to add up or total the columns.

Is there any way to access individual fields like this? Or do I have to start from the beginning and recreate the data source? Any help is greatly appreciated, thanks!

 

[retygh45]

please disregard, I figured it out, just restructured the queries, took only a few minutes, thanks!