COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: GED4le on 15 Aug 2023 05:57:37 AM

Title: fixed height or reduced text leanth
Post by: GED4le on 15 Aug 2023 05:57:37 AM
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



Title: Re: fixed height or reduced text leanth
Post by: dougp on 16 Aug 2023 03:41:18 PM
Decide what a maximum string length should be, then use something like
substring([my crosstab header query item], 1, 8)
Title: Re: fixed height or reduced text leanth
Post by: GED4le on 17 Aug 2023 12:12:56 PM
perfect thanks so much for the help, really obvious now I've seen it