[Solved] Report headers/footers

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

[Solved] Report headers/footers

Postby rosam » Mon Jun 06, 2016 8:32 pm

After adding a report header and footer to my report I see that they appear after my page header and before my report footer, respectively. This is obviously not what I want, but I see no way to change the order and move the report header to the first section of my report and the report footer to the last section, where they belong. Any advice?
Last edited by rosam on Wed Jun 22, 2016 7:22 pm, edited 1 time in total.
OpenOffice 4.1.2 on Windows 10
rosam
 
Posts: 7
Joined: Wed May 18, 2016 3:54 am

Re: Report headers/footers

Postby MTP » Wed Jun 08, 2016 3:23 pm

Are you using the report wizard bundled with OpenOffice, or have you downloaded the Oracle Report Builder extension?
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
MTP
Volunteer
 
Posts: 1618
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA

Re: Report headers/footers

Postby Sliderule » Wed Jun 08, 2016 4:12 pm

In addition to the important question asked above by user MTP, if, you are using the Oracle Report Builder, and, you want to see a sample database ( HSQL-WORLDAREA4.odb ), with some report files, including the use of headers, please see the forum post below, and, download the database file ( it uses the HSQL Embedded Database ). Because of the file size, I used Mediafire to store the file for download.

Download Sample Report File: HSQL-WORLDAREA4.odb

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1098
Joined: Thu Nov 29, 2007 9:46 am

Re: Report headers/footers

Postby rosam » Thu Jun 09, 2016 7:14 pm

I am using Oracle Report Builder extension. I would rather not download the sample database, as I don't think it would help me. I just need to know if there is a way to put the report header and footer in the right place.
OpenOffice 4.1.2 on Windows 10
rosam
 
Posts: 7
Joined: Wed May 18, 2016 3:54 am

Re: Report headers/footers

Postby Sliderule » Thu Jun 09, 2016 8:14 pm

rosam wrote:I am using Oracle Report Builder extension. I would rather not download the sample database, as I don't think it would help me. I just need to know if there is a way to put the report header and footer in the right place.

Yes.
User avatar
Sliderule
Volunteer
 
Posts: 1098
Joined: Thu Nov 29, 2007 9:46 am

Re: Report headers/footers

Postby rosam » Thu Jun 09, 2016 8:28 pm

How?
OpenOffice 4.1.2 on Windows 10
rosam
 
Posts: 7
Joined: Wed May 18, 2016 3:54 am

Re: Report headers/footers

Postby Sliderule » Thu Jun 09, 2016 8:38 pm

Since, I do cannot see your database / report, and, you prefer not to review the sample database I posted above, I do not know any way I can help you.

Perhaps someone else in the forum might be able to be of additional assistance.

Below are links to some of the Oracle Report Builder documentation, found in Base wiki:

  1. http://wiki.pentaho.com/display/Reporting/Pentaho+Reporting+Community+Documentation

  2. https://wiki.openoffice.org/wiki/SUN_Report_Builder/Documentation

  3. https://wiki.openoffice.org/wiki/SUN_Report_Builder/Documentation#Report_Navigator_-.3E_Report_-.3E_Page_Header_-.3E_Properties_of_General_Tab

  4. https://wiki.openoffice.org/wiki/SUN_Report_Builder/Documentation#Report_Navigator_-.3E_Report_-.3E_Report_Header_-.3E_Properties_of_General_Tab
Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1098
Joined: Thu Nov 29, 2007 9:46 am

Re: Report headers/footers

Postby Nocton » Mon Jun 13, 2016 11:31 am

Maybe just not seeing the page header and footer on the pages with your report header and footer would solve your problem?

Go to the report navigate (F5) and in the Report Properties change the options for the Page Header & Footer.

Regards

Nocton
OpenOffice 4.2.0 on Windows 10
Nocton
Volunteer
 
Posts: 444
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: Report headers/footers

Postby rosam » Fri Jun 17, 2016 8:20 pm

Sliderule, I did decide to download the samples because I wasn't able to get the answer to my question. However, the sample reports had only page headers and report footers, but not page headers together with report headers or page footers together with report footers. My issue is that I want to add both a page header and footer and a report header and footer, but as I said the page header appears before the report header in both the edit window and on the actual report, and the same for the footers. I can't understand why I am the only one with this issue. How does everyone else include both page and report headers and footers in a report and have them come up in the proper place in the report, i.e. first report header, then page header, and first page footer then report footer?
OpenOffice 4.1.2 on Windows 10
rosam
 
Posts: 7
Joined: Wed May 18, 2016 3:54 am

Re: Report headers/footers

Postby Nocton » Fri Jun 17, 2016 9:07 pm

I can't understand why I am the only one with this issue. How does everyone else include both page and report headers and footers in a report and have them come up in the proper place in the report, i.e. first report header, then page header, and first page footer then report footer?

rosam, I think you are not understanding what is meant by report and page header and footer. A page header is what it says - it comes at the head/top of the page; similarly with a footer. They are not part of the body of the page. That is where the report is printed. It is exactly the same with spreadsheets and word-processing documents, with OpenOffice or Microsoft Office. So in answer to your question: they are in the proper place in the report.
As I have mentioned, you can turn off the page headers and footers on the first or last page if you want to make the report first and last pages look 'cleaner'.
If you really must have the information that is in the page header after your report header, then just put it in the report header after what you already have there and then use the option I previously mentioned to turn off the page header on the first page. That will give you what you want.

Nocton
OpenOffice 4.2.0 on Windows 10
Nocton
Volunteer
 
Posts: 444
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: Report headers/footers

Postby rosam » Wed Jun 22, 2016 7:17 pm

Nocton, thanks for clarifying this. I see now that I was thinking of the page header as more like a table header and I was trying to use it for column headings that appear once on every page. Now I am using a group header instead to do the job. Thank you for picking up on the root of the confusion!
OpenOffice 4.1.2 on Windows 10
rosam
 
Posts: 7
Joined: Wed May 18, 2016 3:54 am


Return to Reporting

Who is online

Users browsing this forum: No registered users and 2 guests