Dynamic cell height (crosstabs)

[fbreton]

Hello,

 

I would like to know if there's any way to make the cell height dynamic? (with dynamic cross tabs) In order to get a more visual report, instead of having a table with numbers only.

Here is the example of the result I would like to obtain :

 

size=499]http://img181.imageshack.us/img181/1747/sanstitre1cs6.jpg

 

Currently, it doesn't seem possible to use a variable in the "height" field of a row/column of a crosstab.

Is there any other way to do this, or is it something planned to be added in future releases?

Post edited by: fbreton, at: 2008/06/26 13:23

[aar]

Great! That sounds like a pretty interesting solution.

Has someone a way to do that?

 

Arno

[medopal]

I didnt get the idea exactly, but i would suggest to use some kind of conditions, as ternary statements so you can add "\n\n" in the text field to make it stretch.

NOTE: the nn is the enter character, but the escape character has escaped :D

Its not the best solution, or maybe dont solve anything in your case. But here is what im thinking about.

 

Make sure to check "Stretch with Overflow" in the textfield in the crosstab. Then something like this in the expression

"($V{PROFILE}.length()>8)?("\n\n"+$V{PROFILE}+"\n\n"):$V{PROFILE}"

 

This one simply makes the cell stretches by 4 lines if the word has more than 8 chars!!

You can change it to something like

 

"($V{PROFILE}==1)?("nn"+$V{PROFILE}+"nn"):$V{PROFILE}"

 

Anyways, if you can give more info. maybe we can help more.

 

HTH

Post edited by: medopal, at: 2008/07/16 14:21