OK,
Not sure how to do this...
Here is a query that will return ONE row:
SELECT S.PercentFree AS '% Free', S.PercentReduced AS '% Reduced', S.PercentPaid AS '% Paid'
FROM SchoolDemographics S
WHERE S.SchoolID = @SchoolID
AND S.SchoolYear = @SchoolYear
AND S.Grade = 'Total'
I want ONE pie chart to display the numeric values in the "slice" itself with the legend to the right to display column name, i.e.,
- % Free
- % Reduced
- % Paid
Is this possible?
Not sure how to do this...
Here is a query that will return ONE row:
SELECT S.PercentFree AS '% Free', S.PercentReduced AS '% Reduced', S.PercentPaid AS '% Paid'
FROM SchoolDemographics S
WHERE S.SchoolID = @SchoolID
AND S.SchoolYear = @SchoolYear
AND S.Grade = 'Total'
I want ONE pie chart to display the numeric values in the "slice" itself with the legend to the right to display column name, i.e.,
- % Free
- % Reduced
- % Paid
Is this possible?