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.
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.
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.