Removing one field from a circle graph

[Eric G]

I have a report that displays a circle graph of Reasons as follows:

SELECT Reasons.Reason, Count(*) AS [Count] FROM Reasons INNER JOIN
Detentions ON Reasons.ReasonID = Detentions.ReasonID GROUP BY
Reasons.Reason, Detentions.ReasonID;


There are 9 possible reasons that can be drawn from a Reason table.
As records are added to a Detention table, a Reason code is inserted.

I'd like the Reason Report (above code) to display a circle graph of
the Reason data BUT exclude one of the reasons (number 9).

In addition I'd like the segments of the circle graph to show their
respective percentage of the total circle.

Help in how to achieve this would be greatly appreciated.

Eric

 

[SA]

Eric:

SELECT Reasons.Reason, Count(*) AS [Count] FROM Reasons INNER JOIN
Detentions ON Reasons.ReasonID = Detentions.ReasonID WHERE
Detentions.ReasonID <> 9 GROUP BY
Reasons.Reason, Detentions.ReasonID;

--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

I have a report that displays a circle graph of Reasons as follows:

SELECT Reasons.Reason, Count(*) AS [Count] FROM Reasons INNER JOIN
Detentions ON Reasons.ReasonID = Detentions.ReasonID GROUP BY
Reasons.Reason, Detentions.ReasonID;


There are 9 possible reasons that can be drawn from a Reason table.
As records are added to a Detention table, a Reason code is inserted.

I'd like the Reason Report (above code) to display a circle graph of
the Reason data BUT exclude one of the reasons (number 9).

In addition I'd like the segments of the circle graph to show their
respective percentage of the total circle.

Help in how to achieve this would be greatly appreciated.

Eric

 

[Eric G]

Hi Steve,

Thanks very much for your help.
The code worked out perfectly. I now have eliminated reason 9 from the
pie chart.

Would you know how I can display the percentages of each pie segment
and perhaps the segment names, next to the percentages?

Thanks! Eric

Eric:

SELECT Reasons.Reason, Count(*) AS [Count] FROM Reasons INNER JOIN
Detentions ON Reasons.ReasonID = Detentions.ReasonID WHERE
Detentions.ReasonID <> 9 GROUP BY
Reasons.Reason, Detentions.ReasonID;

--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

I have a report that displays a circle graph of Reasons as follows:

SELECT Reasons.Reason, Count(*) AS [Count] FROM Reasons INNER JOIN
Detentions ON Reasons.ReasonID = Detentions.ReasonID GROUP BY
Reasons.Reason, Detentions.ReasonID;


There are 9 possible reasons that can be drawn from a Reason table.
As records are added to a Detention table, a Reason code is inserted.

I'd like the Reason Report (above code) to display a circle graph of
the Reason data BUT exclude one of the reasons (number 9).

In addition I'd like the segments of the circle graph to show their
respective percentage of the total circle.

Help in how to achieve this would be greatly appreciated.

Eric