Re-arrange Report Information!!

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
openoffice2020
Posts: 3
Joined: Wed Apr 26, 2017 8:08 pm

Re-arrange Report Information!!

Post by openoffice2020 »

Hi there!

Regarding the Database Report, I am looking to have the information be arranged in a manner that is in a text format, not in a table format.

For instance, Database arranges the data in a table format:

Inspection Date Inspection Time Trap Location
4/25/17 01:00:00 AM Attic

But I would rather the data be arranged like

On <<Inspection Date>> at <<Inspection Time>>, a mouse was found in the <<Trap Location>>.

So this would look like on

"4/25/17 at 01:00:00 AM, a mouse was found in the Attic."

Any thoughts about how to arrange the data in this manner?

Thank you greatly!
Open Office 4.1.3 on Mac
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Re-arrange Report Information!!

Post by Villeroy »

That would be a serial letter.
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
openoffice2020
Posts: 3
Joined: Wed Apr 26, 2017 8:08 pm

Re: Re-arrange Report Information!!

Post by openoffice2020 »

What does a serial letter refer to?
Open Office 4.1.3 on Mac
longi
Posts: 110
Joined: Mon Jul 15, 2013 5:04 pm

Re: Re-arrange Report Information!!

Post by longi »

Hi!

https://forum.openoffice.org/es/forum/v ... 8f28a07e9c

I'm sorry, it is all explained in Spanish.
You'll have some examples I made, working with reports with the old fashioned report builder (no the ORB), but they have code made by an illiterated programmer, so it is a bit large and strange. However, it has results.
Then, you also have how to make a mail-merge by code from base.
Later, you have a report made by the report designer, as a letter, changing only the text which is the same than the text of the fields.
Finally, you have an example made by Mauricio, using an external writer document, as template.
I think that the last one is your target, but the previous one is no bad (I think!)
I hope you can understand things in the code.

Bye!
OpenOffice 4.1.5 on Windows 10
LibreOffice 5.1 on Windows 7
LibreOffice 6.0.1 on Windows10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Re-arrange Report Information!!

Post by Villeroy »

Serial_Biblio.odt
(14.73 KiB) Downloaded 384 times
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
Post Reply