Re-arrange Report Information!!

Getting your data onto paper - or the web - Discussing the reports features of Base

Re-arrange Report Information!!

Postby openoffice2020 » Wed Apr 26, 2017 8:43 pm

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
openoffice2020
 
Posts: 3
Joined: Wed Apr 26, 2017 8:08 pm

Re: Re-arrange Report Information!!

Postby Villeroy » Wed Apr 26, 2017 9:45 pm

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 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24584
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Re-arrange Report Information!!

Postby openoffice2020 » Thu Apr 27, 2017 2:35 am

What does a serial letter refer to?
Open Office 4.1.3 on Mac
openoffice2020
 
Posts: 3
Joined: Wed Apr 26, 2017 8:08 pm

Re: Re-arrange Report Information!!

Postby longi » Sat Apr 29, 2017 6:17 pm

Hi!

https://forum.openoffice.org/es/forum/viewtopic.php?f=31&t=12838&sid=551abe8a4d4c53861c50f28f28a07e9c

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.2 on Windows 10 and Windows 7
LibreOffice 5.1 on Windows 10 and Windows 7
longi
 
Posts: 83
Joined: Mon Jul 15, 2013 5:04 pm

Re: Re-arrange Report Information!!

Postby Villeroy » Sat Apr 29, 2017 6:52 pm

Serial_Biblio.odt
(14.73 KiB) Downloaded 41 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24584
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Reporting

Who is online

Users browsing this forum: No registered users and 3 guests