[Solved]Group splits on pages w/o header repeating on new pg

Discuss the database features

[Solved]Group splits on pages w/o header repeating on new pg

Postby pizzipie » Sat Jan 26, 2019 12:36 am

The attached files show my problem much better than I can explain it.

In spite of what it says above I am using LibreOffice V. 6.0.7.3 Ubuntu 16.04.

Thanks for your help in advance.

R.
Attachments
Selection_070.png
Group Header
Selection_069.png
Sorting and Grouping
reportBuild.png
The results
Last edited by pizzipie on Mon Jan 28, 2019 8:10 pm, edited 2 times in total.
LibreOffice Version: 5.0.5.2 - Using Ubuntu 14.04 - MySql and PHP
pizzipie
 
Posts: 39
Joined: Sat Sep 13, 2008 2:28 am

Re: Group splits on pages w/o header repeating on new page

Postby UnklDonald418 » Sun Jan 27, 2019 7:20 am

On the Group Header properties dialog try setting Repeat Section to Yes.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1199
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Group splits on pages w/o header repeating on new page

Postby pizzipie » Mon Jan 28, 2019 2:04 am

When I do that it makes a new page for each record!!!

Is there no place that explains the workings of Group Settings? I can't find any.
Attachments
Selection_074.png
LibreOffice Version: 5.0.5.2 - Using Ubuntu 14.04 - MySql and PHP
pizzipie
 
Posts: 39
Joined: Sat Sep 13, 2008 2:28 am

Re: Group splits on pages w/o header repeating on new page

Postby UnklDonald418 » Mon Jan 28, 2019 5:13 am

There is some documentation in the Reports chapter of the LO Base Handbook
https://documentation.libreoffice.org/en/english-documentation/base/
and
https://wiki.openoffice.org/wiki/SUN_Report_Builder/Documentation
but I think development and documentation stopped in the SUN to Oracle transition.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1199
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Group splits on pages w/o header repeating on new page

Postby UnklDonald418 » Mon Jan 28, 2019 5:28 am

Other thoughts
Have you tried to use Mail Merge?
Sometimes displaying the data on a spreadsheet and printing from there works better than the Report Builder.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1199
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Group splits on pages w/o header repeating on new page

Postby pizzipie » Mon Jan 28, 2019 7:54 pm

I never thought about the support being lost when Sun went away!

Great idea about mail merge.

Thanks for help. I will give this some thought and try it out. Might be easier to accomplish too.

R.
LibreOffice Version: 5.0.5.2 - Using Ubuntu 14.04 - MySql and PHP
pizzipie
 
Posts: 39
Joined: Sat Sep 13, 2008 2:28 am


Return to Base

Who is online

Users browsing this forum: No registered users and 5 guests