I am trying to transition from a very old version of Works and OO and am stuck hard.
I set up a small table and then built a report but can't figure out how to connect the two.
The best I have done so far is to print a report in the format I made but it just contains Latin junk instead of my table.
What am I missing?
Thanks
js
Connecting table to report
-
- Posts: 2
- Joined: Wed Dec 20, 2017 6:36 am
Connecting table to report
open office 4.1.4
win xp
win xp
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Connecting table to report
Welcome to the Forum
Assuming you are using the built in Report builder that comes with Base open the report in the Design Mode (right click on the report and select Edit).
Along the bottom of the report window click on the Form Navigator icon (usually 6th from the left).
In the Form Navigator dialog right click on Report Source and select Properties.
In the Form Properties dialog select the Data tab.
For Content Type select Table.
Then for Content select the name of your table from the list of available tables.
<Ctrl>S should Save the report form, then Close it.
Now run the report.
If you still get garbage then I would suggest you upload a sample database so one of the volunteers could look at your problem.
[Forum] How to attach a document here
Be aware that the built in Report builder has limited capabilities but the Oracle Report Builder extension has more features.
https://extensions.openoffice.org/en/pr ... rt-builder
Assuming you are using the built in Report builder that comes with Base open the report in the Design Mode (right click on the report and select Edit).
Along the bottom of the report window click on the Form Navigator icon (usually 6th from the left).
In the Form Navigator dialog right click on Report Source and select Properties.
In the Form Properties dialog select the Data tab.
For Content Type select Table.
Then for Content select the name of your table from the list of available tables.
<Ctrl>S should Save the report form, then Close it.
Now run the report.
If you still get garbage then I would suggest you upload a sample database so one of the volunteers could look at your problem.
[Forum] How to attach a document here
Be aware that the built in Report builder has limited capabilities but the Oracle Report Builder extension has more features.
https://extensions.openoffice.org/en/pr ... rt-builder
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
-
- Posts: 2
- Joined: Wed Dec 20, 2017 6:36 am
Re: Connecting table to report
Got to the of instructions and got the same garbage instead of my list.
Understand why I stuck to works. Take about 3 clicks to set up a data base. Unfortunately, no one else can read the files.
We sorting through rubble from a disasterous fire a data base would be a big help.
I am attaching the odb and two odt files.
r33 has proper layout but Latin garbage
r331 looks good but prints most of it off the page
new datebase is the odb file
js
Understand why I stuck to works. Take about 3 clicks to set up a data base. Unfortunately, no one else can read the files.
We sorting through rubble from a disasterous fire a data base would be a big help.
I am attaching the odb and two odt files.
r33 has proper layout but Latin garbage
r331 looks good but prints most of it off the page
new datebase is the odb file
js
- Attachments
-
- New Database.odb
- (46.58 KiB) Downloaded 143 times
-
- 331.odt
- (10.04 KiB) Downloaded 166 times
-
- r33.odt
- (10.29 KiB) Downloaded 191 times
open office 4.1.4
win xp
win xp
Re: Connecting table to report
Both of your .odt files look good to me.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Connecting table to report
I think the other persons do not use OpenOffice. Tell them they should download and use OpenOffice.JACK SCHMIDLING wrote:Unfortunately, no one else can read the files.
Romke
LibreOffice 7.1.4.2 on openSUSE Leap 15.2
Re: Connecting table to report
Any office document can be exported to PDF which is readable on every device.
PDF is not an editable office format so keep your original documents.
PDF is not an editable office format so keep your original documents.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Connecting table to report
r331 looks good but prints most of it off the page
is caused by the report form being wider than the page size set in Format->Page.
As to the Latin, it is a nonsensical phrase traditionally used by printers as a place holder.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Re: Connecting table to report
I just downloaded Oracle Report Builder, installed it into LO 6.x, then opened up my file, then Insert > Report...Created report with two fields (I've done LO Base Reports before so I know what I am doing).
The above error is what I get...
Does Oracle Report Builder (ca. 2007) work with newer versions of LibreOffice?
It complains it "Cannot open Business Contacts.odt", but yet in Queries everything is just working as was befor .oxt installation.
LibreOffice 6.1.3.2 (Linux Fedora 29 on x86_64) with 'Notebookbar'
OpenOffice.org since 2002-12. LibreOffice user since 2013-current.
HSQLDB 2.5.0
OpenOffice.org since 2002-12. LibreOffice user since 2013-current.
HSQLDB 2.5.0
Re: Connecting table to report
The report builder is part of LibreOffice. No need to install anything.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice