fixed height or reduced text leanth

[GED4le]

Hello,

In my Cross tab i would like the Row header cells to be a fixed height and width, currently the width is fixed but if the text wraps over 3 lines the height auto sizes.

is there a way to either fix the height or limit the text  characters so it will never resize?


Thanks

[dougp]

Decide what a maximum string length should be, then use something like

Code Select Expand

substring([my crosstab header query item], 1, 8)

[GED4le]

perfect thanks so much for the help, really obvious now I've seen it