Good evening.
I have a report made up in the following structure:
GroupHeader1: City (Grouping by city and with Keep Headline on Next Page checked)
GroupHeader2: Person (Grouping by Person and with the Keep Dataset Together option checked)
GroupFooter1: Suppressed
GroupFooter2: Suppressed
So far so good, considering that when I print the report it has the following configuration (example):
SÃO PAULO
======================
Informações da Pessoa1
======================
Informações da Pessoa2
======================
Informações da Pessoa3
======================
RIO DE JANEIRO
======================
Informações da Pessoa4
======================
Informações da Pessoa5
======================
The big problem is that depending on the volume of data it does not break the header city, as you would like it to do, resulting in the following impression:
Page 1:
SÃO PAULO
======================
Pessoa1
======================
Pessoa2
======================
Pessoa3
======================
Pessoa4
======================
RIO DE JANEIRO
======================
Page 2:
RIO DE JANEIRO
======================
Pessoa5
======================
Pessoa6
======================
As you can see, person 5 does not fit the page, but even so he prints RIO DE JANEIRO on page 1 and then again on page 2, now with Person5.
What I want to happen is that RIO DE JANEIRO does not print on page 1 if there is not room to print at least one person together. In that case it would only appear on the next page.
In addition, if there is space to print at least one person, he would print RIO DE JANEIRO on the first page along with the first person and RIO DE JANEIRO again on the second page, but now with the information of the next person. >
I tried to fix this with the Keep Data Set Together option also checked for GroupHeader1, but it does a page break, which is not expected.
Any ideas how to proceed?
Hugs!