Display Total Column in a crosstab - Crystal 9 1

[shaleen7]

How do you only display the total column in a crosstab?

I want to suppress all the previous column values.
Current Results
total
Riley 20 10 30
Jim 15 25 40
Desired Results
total
Riley 30
Jim 40

 

[synapsevampire]

What's in the column group? You don't show any header there, yet you have columns.

Try eliminating that.

-k

 

[lbass]

If you don't need the column values, you don't really need a crosstab. You would use the column field (from your crosstab) in your detail section, insert a summary on it, and suppress the details.

If you were creating a manual crosstab, and using formulas like:

if {table.value} = x then {table.amt}

...where "x" is a value specific to a particular column, again you would just add {table.amt} to the details instead of adding any conditions in a formula.

If there is some reason you need the crosstab format (e.g., for consistency) and still want to display only the total column, remove the column field to get a display with only the row totals.

-LB

 

[shaleen7]

Thanks.