Ask Your Question
1

When using Base Report Wizard, why do the field headings repeat for every record line?

asked 2018-11-05 04:14:33 +0100

JohnBoy gravatar image

I am using LO v6.0.6.2 (64-bit). I have created an address book database and registered it. I set up a query. Now I am trying to print a report listing the address book records. The problem is the field headers (First, Last, Addr1...) print above each line on the page. I only need them to print at the top of each page. I cannot figure out how to get the output the way I want.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2018-11-05 04:39:13 +0100

Ratslinger gravatar image

Hello,

You have a group set up with the titles in the group header. The grouping is probably set on each name. The grouping should be removed and the titles go into the page header.

You can find a bit more on this in the LO documentation -> LibreOffice Base Handbook. Look in Chapter 6 - Reports.

edit flag offensive delete link more
0

answered 2018-11-05 05:32:44 +0100

JohnBoy gravatar image

I select the Report Wizard. I select my query and the fields I want to print and click NEXT. On the Labeling and Grouping screens I change nothing (ie; I am not "grouping" any of the records). On the Sort Option page, I select "Last" and "First" fields to sort ascending.... NEXT. On the Choose Layout page I leave it at Tabular (Layout of the Headers and Footers only has "Default" in it)... NEXT. On the Create Report page I leave the defaults of Dynamic and Create Report Now and click FINISH. The field headers repeat for every line (record).

So I did try recreating the report and at the end I selected Modify The Report and FINISH. It shows the layout and where the data would go (in the Detail section), but I see nothing in the Group Header or Page Header sections. No difference.

I finally tried Editing the report I created, and now I see the field headings in the Group Header section. I moved them to the Page Header section and now it prints the way I want it to.

Thanks.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-11-05 04:14:33 +0100

Seen: 115 times

Last updated: Nov 05 '18