Field automatically resize

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
paulb
Posts: 6
Joined: Fri Dec 05, 2008 6:06 pm

Field automatically resize

Post by paulb »

How do you make a field in a report automatically expand or retract in size depending on how much data there is to view?
OOo 2.3.X on Ms Windows XP
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Field automatically resize

Post by Villeroy »

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
ptoye
Posts: 225
Joined: Mon Apr 21, 2008 11:07 am
Location: Reading, England

Re: Field automatically resize

Post by ptoye »

Ouch! Does this work for reports as well as forms though? (Sorry for butting in, but I'd like to expand a report detail to multiple lines if a field is too long for the width.)
Peter
OO 4.1.1 on MS Windows 7 64-bit
User avatar
DrewJensen
Volunteer
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: Field automatically resize

Post by DrewJensen »

No - the code used in the other thread is NOT going to work for Base Reports.

The funcitonality is planned for the Sun Report Builder (yeah it's an extension - sort of) but when I don't know.

You can see what is planned at this page:
SUN Report Builder - PlannedFeatures

Many of the features listed on that page will be in the 3.1 release of OO.o but I have not heard anything about Flowing Text as part of that.
 Edit: I posted a question to the developers mailing list regarding the when question - when something comes back from the developer I'll pass it along here 
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
ptoye
Posts: 225
Joined: Mon Apr 21, 2008 11:07 am
Location: Reading, England

Re: Field automatically resize

Post by ptoye »

Thanks Drew. I await this one with interest as I've a lot of free-form text fields.
Peter
OO 4.1.1 on MS Windows 7 64-bit
jairey
Posts: 1
Joined: Sun Jun 21, 2009 2:57 pm

Re: Field automatically resize

Post by jairey »

Any update on this? I'm running the latest versions, and I need to be able to have a field do what my ACCESS 2000 calls "can grow" which automatically allows a field to expand to the size it needs to be.

Jean
OOo 3.1.X on Ms Windows XP
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Field automatically resize

Post by r4zoli »

Feature not implemented into 3.1 and not in development version for 3.2, until now.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
griffinba
Posts: 4
Joined: Thu Feb 18, 2010 12:08 am
Location: Buffalo, NY

Re: Field automatically resize

Post by griffinba »

I've recently loaded 3.2 and noted that it is not apparent, it would be a great feature when enabled. (PS, the words used to describe are "Flowing Text")
OPen Office 3.2 on Windows xp/Home svp 3
griffinba
Posts: 4
Joined: Thu Feb 18, 2010 12:08 am
Location: Buffalo, NY

Re: Field automatically resize

Post by griffinba »

For those who need to have an approach to putting the "long text" data to a report, I was able to do that using the "Mail Merge" function. This gives one access to the tables and queries and by ignoring the addressing steps, going to the document itself, inserting the appropriate mail merge fields as if setting up a report with spacing, font characteristics, etc, then following each occuraance of the field group with a "next record" and pasting the entire group as many or more times as the occurances of the targeted records, and then completing the merge" a passable report is produced. Surely not a "production" process but it does alow one to get the flowed text in a form usable by non-tech folks, the ability to have dynamic field sizing like "can grow" (and hopefully "can shrink") in MSO will be a great addition but this may be a route for minor needs in the meantime.

The power of the Form functions is really enhanced by the ability to display and report variable passages.
OPen Office 3.2 on Windows xp/Home svp 3
A. Feit
Posts: 9
Joined: Fri Jul 08, 2016 2:48 pm

Re: Field automatically resize

Post by A. Feit »

Has this feature been implemented yet in report builder? If not is there a work around?
OpenOffice 4.1.2 in Windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Field automatically resize

Post by Villeroy »

Do not use the report builder. Use Calc or the tabular old-style report or may be even mail merge fields.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
A. Feit
Posts: 9
Joined: Fri Jul 08, 2016 2:48 pm

Re: Field automatically resize

Post by A. Feit »

I've tried mail merge and succeeded in corrupting the data base. In addition to resize I need to use two data sources in one mail merge document. The old-style report may work.
OpenOffice 4.1.2 in Windows 10
User avatar
Sliderule
Volunteer
Posts: 1278
Joined: Thu Nov 29, 2007 9:46 am

Re: Field automatically resize

Post by Sliderule »

Perhaps there is another way to accomplish your task, or, put another way, if it were me, I would do it as described below.

Since, you do not want to have another instance of a corrupt Base file ( *.odb ) as I indicated to you in the recent past, use HSQL, preferably Version 2.3.4 ( as of the date I am writing this ), as an external database . . . and . . .
  1. Use a tool, such as, SqlTool.jar to compose / write your report as an HTML file ( or, alternatively, simple raw text ) . This will allow you to include 'raw' HTML code, and, you can 'format' the output as you wish.
  2. Use SqlWorkbench/J to create your report.
  3. Any other external database reporting tool of your choice ( that is outside of OpenOffice / LibreOffice ).
Sliderule
longi
Posts: 110
Joined: Mon Jul 15, 2013 5:04 pm

Re: Field automatically resize

Post by longi »

Hi!
You have several options to work, but none of them is easy. I worked about reports, specially no ORB reports.
I attach several examples I developed.
I know my code is a mess (I am not a programmer, I am only a copy-and-paste user),so it should be modify in order to do things in an easy way, but the important is that things are possible:

A. Old fashioned system:

1. You can use a cell which is in the main table in the report, in the design mode, use the ‘autoheight’ function.
In this case you won’t be able to use the field for other different thing than text you have in the text field.
You will be able to justify the text (left and right) using macros if you are using the legacy report builder (OpenOffice).
2. You can, in the design mode, erase all your main table, then, you can add a new subform ( a report has that structure).
In that subreport you can write whatever you want, and you can put between two words, a field based on the subform data source.
Here is the place in which you can use the Villeroy’s suggestion (as I used)
You won’t be able to justify the text if you have more than one line of text.
3. You can reduce the length of a textfield to no see it, copy its text, and past it in the writer document which is in every report in base.
In this case you are able to justify perfectly your block of text.
4. You can combine these techniques with other, getting a combination of text, table, images, charts and other tables, with other origins ( a subreport )

B) With Oracle Report Builder

1) You have to take into consideration that ORB works with three tables in the simplest report, and the main table is the number two.
You can modify a row of that table to ‘autoheight’, and it works fine, but it is a bit difficult to know the number of the row to modify.
The ‘autoheight’ function only is possible with macros (I think).
You are able to justify the text without using macros in LibreOffice.

The example is too large, so you can find it in:

https://drive.google.com/open?id=0B9p04 ... VJuQ1FmeUE

I have to say that last three reports don't work properly with LibreOffice. They have a chart which is visible with Openoffice, but not with LibreOffice, due to the way in which the chart get data from its source data. Nothing important.
Good luck!
OpenOffice 4.1.5 on Windows 10
LibreOffice 5.1 on Windows 7
LibreOffice 6.0.1 on Windows10
Post Reply