Re: [libreoffice-users] LO Base report Auto Grow function

Thanks! I suspected it might be be something like that. 

I am using LOBase with a mariadb backend, so I an not sure how that
should be handled. In any case, the Query GUI does not like my formula
as is.

Cheers
Harvey

On Wed, 2024-10-30 at 08:13 -0400, Java Joe wrote:
> I have not tested, but would suspect it is evaluating the length of
> the
> formula rather then the length of the content the formula produces.
>
> If your data source is a query it should be possible to produce the
> string you want in the query, then just reference the field instead
> of
> using a formula.
>
> I mainly work with PostgreSQL, not sure if this exact syntax and
> functions are available in Base (hsqldb) but your formula in SQL
> would
> start something like this:
>
> "Ort1" || COALESCE(CHR(10) || CHR(13) || NULLIF("Ort2", ''), '')
> > > COALESCE(CHR(10) || CHR(13) || NULLIF("Ort3", ''), '')
> ...
>
>
> On 10/30/24 07:57, Harvey Nimmo wrote:
> > I have a report field that contains the following data Value
> >
> > =[Ort1]&IF(NOT(ISBLANK([Ort2]));UNICHAR(13)&UNICHAR(10)&[Ort2];"")&
> > IF(N
> > OT(ISBLANK([Ort3]));UNICHAR(13)&UNICHAR(10)&[Ort3];"")&IF(NOT(ISBLA
> > NK([
> > Staat]));UNICHAR(13)&UNICHAR(10)&[Staat];"")
> >
> > As the field from the attached database query may have anything
> > from 2
> > to 5 lines of text, I would like to use the function Auto Grow.
> > There
> > is enough free room below the report field for the maximum line
> > number.
> >
> > 'Auto Grow = Yes' is accepted and apparently saved without
> > objection on
> > exiting edit. But on generating the report, the field is not
> > autogrown.
> > And the setting has returned to 'Auto Grow = No'.
> >
> > I want to use autogrow to optimise the use of paper space. The
> > thought
> > occurs to me that, for Auto Grow to make more sense, the report
> > sections, in particular the Detail section, should also have
> > autogrow/(autoshrink?) settings.
> >
> > For the moment, is there a way to Autogrow my field, or am I
> > obliged to
> > set the field to the maximum available?
> >
> > Cheers
> > Harvey


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy