Instead of using the pass/fail field as a column, create separate formulas like this:
//{@Pass}:
if {table.category} = "Pass" then 1
Repeat for {@Passwcomments} and {@Fail}. Also create a formula {@0}:
whilereadingrecords;
0
Then add these as your summary fields in the crosstab, and add sum of {@0} as your last two summaries (add it twice--these will just be used to hold your results). Use sums for your five summaries (not counts).
Go to the customize style tab and choose summarized fields->horizontal and "show labels". Edit the labels to show the last two columns as "Total" and "% Pass" and to remove the "@"s.
Then in preview mode, select sum of {@pass} and sum of {@passwcolumns}->right click->format field->suppress->x+2 and enter:
whileprintingrecords;
numbervar tot := tot + currentfieldvalue;
numbervar pass := pass + currentfieldvalue;
false
Select {@fail}->right click->format field->suppress->x+2 and enter:
whileprintingrecords;
numbervar tot := tot + currentfieldvalue;
false
Then select the fourth column ({@0}->right click->format field->display string->x+2 and enter:
whileprintingrecords;
numbervar tot;
totext(tot,0)
Select the last column {@0} to hold the percentage->right click->format field->display string->x+2 and enter:
whileprintingrecords;
numbervar tot;
numbervar pass;
totext(pass%tot,2)+"%"//2 for two decimals
Then while the fifth column is still selected, go to the borders tab->color->background->x+2 and enter:
whileprintingrecords;
numbervar tot := 0;
numbervar pass := 0;
crNoColor
This last formula will reset (per row) the manual running totals that were used for the summaries.
-LB