Crystal reports crosstab chart

If you right mouse click on the @columngroup  field in the crosstab -> format field -> common tab -> display string this contains the headings

"    Frame             Glass            CSI             Total " & chr(13) &
"   Revenue         Revenue     Revenue   Revenue"

Not sure why it's been done this way you could just have this as the formula for @columngroup

Mainly because I was thinking about the display string and didn't think about just changing the formula

mlmcc

I tried removing the field and checking the box and the cross tab didn't show anything.  It needs a column to be able to show the data.
You can suppress the column group and it does show the headings.

mlmcc

Here is a start at usiing GJParker's method

mlmcc
COQ-For-ExpertsRev3.rpt

Heres the one without using the columngroup formula

 COQ-For-ExpertsRev3-1-.rpt

Here is what CR XI does when you remove the columngroup from the columns in the expert
Are you using CR2008 or 2011?

mlmcc
COQ-For-ExpertsRev3a.rpt

You must have missed my earlier post #36717891

"You also need to uncheck 'Suppress row grand totals' on the customise style tab "

I'm using CR XI R2 but I've been using this method for many years in previous versions.

Thanks.  I missed the comment on unchecking the total suppression.  
What is shown is the row totals and not the columns

mlmcc

Reports I have built never lent themselves to cross tab except to create charts so I never really played with the options and features.

mlmcc

Thank you both for your help.