Crosstab data labels

[DuncanSutcliffe]

I'm almost embarrassed to post this one, I really should know the answer.

I have a crosstab which includes two summarized fields. These just print one underneath each other in each column of each row. Is there any way of labelling the crosstab so users can tell what each figure is?

Using CR 8.5, and *very* reluctant to build a manual crosstab as I won't be here to rebuild it all next year when all the column titles change.

TIA
Duncan

 

[Mike Lewis]

Duncan,

Do you mean that you want two pieces of fixed text in the left hand side of the cross-tab, with one just below the other?

If so, create a formula which returns the text, using CHR(10) where you want the line-break to appear. For example:

'Average Sales:' + CHR(10) + 'Total Sales:'

In the Cross-tab Expert, drag this formula from the Available Fields box and drop it in the Rows box.

If I have misunderstood the requirement, my apologies.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[DuncanSutcliffe]

Ah, solved it myself. Just create a formula

WhileReadingRecords;
"First Label" + Chr(13) + "Second Label"

Then put it in as the last row in the crosstab.

If only I could give myself a star!

Duncan