Thanks for your answers. It's nice to know it can't be done at the moment and it's not me being unable to do it. Hopefully we'll see this feature available one day. I'll try the technique you've described and get better reports. Regards Paolo
On Tuesday 27 November 2007 11:29:42 Drew Jensen wrote: > Regina Henschel wrote: > > HI Paolo, > > > > Paolo schrieb: > >> After a while away, I'm back "playing" with OO Base and Sun Report > >> builder. > >> Now I have one question: is it possible to have variable height > >> report fields? > >> > >> That is, every report line I'm printing includes a "memo" text, and > >> the content here could be empty, one single word, or a few lines of > >> text. > >> > >> It seems to me that you have to draw a bounding box trying to foresee > >> the worst case, that is the maximum lenght of the text, or it could > >> be truncated during the output. > >> > >> So I wonder, is it possible to have a text field to automatically > >> change its own height according to the real lenght of the content? > >> that would allow for a nicer layout on the page and save a lot of > >> blank space. > > > > It sounds like issue > > http://www.openoffice.org/issues/show_bug.cgi?id=77605 > > which is still "OOo later". > > Well, this isn't really a 'solution' - but. > > You can't grow the control size, but you can shrink the text at runtime > based on the length of the string being printed. > > To do this you would use conditional formatting along with the built in > function LEN( [Field Name] ) > > Conditional formatting allows you to setup a list of conditions, each > can have a unique format - this format setting allows you to set the > Font Name, Face, Size, Spacing and Width. Now you couldn't get to > carried away or you would have something illegible - but still it would > allow you to handle some reasonable overflow. > > For example > LEN([Field]) < 50 = Tahoma, 10pt, 100% width, normal spacing > LEN([Field]) =>50 AND LEN([Field]) < 70 = Tahoma, 9pt, 100% width, > normal spacing > LEN([Field]) => 70 AND LEN([Field]) < 100 = Tahoma, 8pt, 100% width, > normal spacing > LEN([Field]) =>100 = Tahoma, Tahoma, 8pt, 90% width, condensed .5 > > > Just a thought > > Drew > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- Paolo --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
