Cross Tab with Percents

[cnice9]

I have created a grade distribution report in CR 9 that is intended to show the number of different grades given by a teacher, by their course and section. The report works fine but I need to be able to show percents as well as the totals in the cross tab report that I have inserted.
What I have so far is:

Report header - suppressed

Page Header – Displays header and parameter choices

Group header – (Grouped on Teacher)
Details – Suppressed

Group Footer – (grouped on Teacher) cross tap report
Columns – table. columndesc
Rows – table.coursetitle
Table.coursesection
Summarized fields – column totals (this is a running total that counts the grades)

This works fine and returns the following:

Teacher – J. Jones
A’s B’s C’s Total
English 1A Section 1200 2 4 2 8
Total 2 4 2 8
Total 2 4 2 8

What I need Is the report to look like the following:

Teacher – J. Jones
A’s B’s C’s Total
English 1A Section 1200 2 4 2 8
Total 2 4 2 8
Percents 25% 50% 25% 100%

Thank you in advance and any assistance is greatly appreciated.


C.Nice
RealTime Information Technology Inc.

http://www.realitinc.com/

 

[John43]

I believe you can create a formula for a crosstab report,
then place it where you want the result.

 

[e11a]

I've done something similar but put the totals in the group footer instead of using a cross tab.

A formula like Sum ({@f_A_grades}, {course}) * 100 / Sum ({@f_total_grades}, {course}) should calculate the percentage of A grades.