How to have multiple rows of data for each record

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
dongwoo17
Posts: 3
Joined: Mon Jul 27, 2009 5:25 pm

How to have multiple rows of data for each record

Post by dongwoo17 »

Hello. I'm using OpenOffice 3.3.0.

I'm trying to generate a report for a list of families and their descriptions.
The record for each family has many fields and when I make the report the columns come out too narrow to read the content, even in the small fonts.

I tried to move the fields by creating addition tables underneath the first row of data on the report. But when I execute with the new format, the second row simply does not appear on the generated report.

How would I make a report that has multiple row of data for each record?

Thanks in advance for any help...
OOo 3.1.X on MS Windows Vista
JohnV
Volunteer
Posts: 1585
Joined: Mon Oct 08, 2007 1:32 am
Location: Kentucky, USA

Re: How to have multiple rows of data for each record

Post by JohnV »

This assumes your Base file is registered as a data source (default behavior when creating a new db).

Open a new Writer file and press F4. Open your db (or Bibliography if yours isn't there), open the Tables item and click your table. Click the box to the left of the field names to select all records. Click the Date to Text icon and put the bullet in either Fields or Text. Move the fields from left to right using as many rows as you like. Be sure to insert at least one blank row at the end to separate your records.

Click OK and you are done.
Post Reply