Create report that have many columns

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

Create report that have many columns

Postby msngu72 » Wed Aug 06, 2014 9:51 am

Hi,
I am new to openoffice. I want to create a report in OpenOffice Database. How to create a report which can display to multiples pages because i have too many column which cannot fix into a single page width.
Hope someone that is expert to this can help.

Thanks
openoffice 4.1.0
Windows 7 Professional
msngu72
 
Posts: 3
Joined: Wed Aug 06, 2014 9:42 am

Re: create report that have many columns

Postby Villeroy » Wed Aug 06, 2014 10:52 am

Use Calc as alternative report engine: [Tutorial] Using registered datasources in Calc
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28220
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: create report that have many columns

Postby MTP » Wed Aug 06, 2014 4:35 pm

I'm not sure I understand what you are asking. Is this correct: you have created tables, and your tables have data in them? And you want a read-only (no data entry) way to view this data over multiple pages in a Writer (the default Form/Report) or a Calc file?
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
MTP
Volunteer
 
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA

Re: create report that have many columns

Postby Villeroy » Wed Aug 06, 2014 5:16 pm

A Writer report is limited to a paper sheet layout which becomes messy when you dump 20 columns side by side. On a spreadsheet you can view up to 1024 columns, show and hide columns, format them nicely and print them in different ways.

P.S. I just noticed that I can open an embedded report for editing, turn on menu:View>WebLayout, do some dummy edit (insert and delete some character) drag column as wide as needed, save the report and the web layout remains fixed for this particular report.
Last edited by Villeroy on Thu Aug 07, 2014 8:41 am, edited 1 time in total.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28220
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Create report that have many columns

Postby msngu72 » Thu Aug 07, 2014 2:42 am

Thanks MTP & Villeroy for your replies.
MTP,
I use OpenOffice Base to create tables, queries, forms and report to keep track of my inventory listing.
Now i want to have report which can show me 20 fields, but as Villeroy mentioned Writer report is limited to a paper sheet layout. I am wondering is there any setting where i can do to show all these fields expanded to few pages inside OpenOffice Base reporting function?
openoffice 4.1.0
Windows 7 Professional
msngu72
 
Posts: 3
Joined: Wed Aug 06, 2014 9:42 am

Re: Create report that have many columns

Postby Villeroy » Thu Aug 07, 2014 8:39 am

Try the web layout trick.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28220
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Create report that have many columns

Postby msngu72 » Thu Aug 07, 2014 10:46 am

Hi Villeroy,
i try to use the wizard to create the report, then i go to edit mode. Then i go to "View", "Web Layout", but the report still squeeze to 1 page only
openoffice 4.1.0
Windows 7 Professional
msngu72
 
Posts: 3
Joined: Wed Aug 06, 2014 9:42 am

Re: Create report that have many columns

Postby Villeroy » Thu Aug 07, 2014 11:12 am

It's an ordinary Writer document having one table with one row for the column headers and one place holder row for the data. While in web layout view, drag the table columns as wide as you need them. You can format the table, apply number formatting to numeric cells in the second row, add descriptive text, drawings, headers, footers, Writer fields etc.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28220
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Create report that have many columns

Postby MTP » Thu Aug 07, 2014 4:34 pm

I have very limited experience with reports; my guesses would be to try landscape orientation instead of legal orientation. Or maybe tell it you have a bigger paper size than 8 1/2 x 11.
(I won't be able to offer anything else, but in case someone else with more knowledge of reports chimes in - are you using Report Builder, or the standard Base reports? I suspect your original idea of spreading the columns out over several "rows" tall enough to force them to separate pages would be more feasible in Report Builder.)

Otherwise I second Villeroy's suggestion of using a Calc form as a report (see also [Tutorial] Standalone Forms / Switchboard).
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
MTP
Volunteer
 
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA


Return to Reporting

Who is online

Users browsing this forum: No registered users and 1 guest