Base Report: 6-record table → grid report, 2x3

Discuss the word processor
Post Reply
capemayal1
Posts: 90
Joined: Fri Dec 31, 2010 5:16 pm

Base Report: 6-record table → grid report, 2x3

Post by capemayal1 »

I currently have a base report for a 6 record table.

I need to put 3 or 4 columns in the detail section with 2 fields - item and date.

I would like to have 2 rows only, thus 3 columns.

Although can format 3 columns, the records all listed in the 1st column.

I think the biggest part of the problem might be the column's height, not sure.

I would like the data to either vertically for 2 records, with the next record in the 2nd column.

I would think a 3 or 4 column table might work, but would need a different record in each column.

I would appreciate any help you could give.

Thank you, Al
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Base Report Columns

Post by Villeroy »

Use Calc as report engine.
Drag the query icon from the left pane of the data source window into a spreadsheet. This creates a linked database range.
Link the cells yiou need to some other cells, format them as needed and define them as print range.
To refresh the data, click any cell in the database range and call menu:Data>Refresh
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
Post Reply