How to have multiple rows of data for each record

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

How to have multiple rows of data for each record

Postby dongwoo17 » Sun May 20, 2012 4:53 am

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
dongwoo17
 
Posts: 3
Joined: Mon Jul 27, 2009 5:25 pm

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

Postby JohnV » Sat May 26, 2012 5:48 pm

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.
JohnV
Volunteer
 
Posts: 1585
Joined: Mon Oct 08, 2007 1:32 am
Location: Kentucky, USA


Return to Reporting

Who is online

Users browsing this forum: No registered users and 1 guest