Cross Tab

[iansmithwolves]

CR 8.5

Is it possible to get the main row headings central, both vertically and horizontally in a cross tab, ie so that they appear in the centre of the first column, which is appended to several rows in subsequent columns.

 

[lbass]

To get the horizontal centering, click on the row label and use the centering icon. To get vertical centering, one way is to go into the crosstab expert, click on the row field->group options->customize group name->use a formula to customize name->x+2 and enter:

replicatestring(chr(13),2) + totext({table.number},"0000")

...where you would replace the "2" with the number of returns you would like. If your row field is a number, format it something like I did to reflect the maximum number of digits, so that it sorts correctly. Otherwise, if it's a string, remove the totext(,"0000"). This isn't actual vertical centering, but gives you a tool to play with alignment anyway.

-LB

 

[MRWARNER]

Thanks, this was a great tip. Do you know how we could do this with the summarized fields and the totals?

Thanks again!

 

[lbass]

Well, I suppose you could add the summary in multiple times and then in preview suppress the top and bottom values in the summary and totals sections to get vertical centering.

-LB

 

[MRWARNER]

Hmmmm,
The way your mind works is amazing.
I'll give that a try.

Thanks

 

[iansmithwolves]

LB

I've tried the formula, my headings disappeared, what am I doing wrong?

 

[iansmithwolves]

LB

Just out of interest what does the 13 in the formula represent?

 

[lbass]

chr(13) is a return. They "disappeared" because the values are now hidden below the bottom margin of the cell. Click on the row label and drag it down to make it taller--then you will see the value.

-LB

 

[chelseatech]

See if "Can Grow" is available on that object.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm