How to space at least the table header with one row on the same page or skip to the next

[julioarriaga]

Hi,

I want to know how to always put a row of column names with at least the 1st row of data or if there's not enough space to skip to the next page. I tried with the "Keep Together" function but it doesn't work. The data can change dynamically, so just changing the spacing will not work.

Thanks in advance.

How the data is shown right now

How it should be shown (option A)

how it should be shown in case there's too much data (option B)

[Frank_S]

@julioarriaga

It is not exactly clear what your requirement is but I will make a guess that you are trying to keep the same column headers on each page in a PixelPerfect report.

To do so, you must

• use Group header and footer
• In the group header properties use Repeat every page
• Optional - in group footer, use section Page Break and select 'after the band'

[Lech_Miszkiewicz]

@Frank_S , I believe the issue is different. The issue appears when header row happens to sit as a last row on the page in the report... so lats say you have first and second page filled with one table (header only on 1st page) and towards the end of the page - on last row - there starts second / different table, but only header row is shown as there is no more room for rows with data. 

What @julioarriaga wants to do is to move that either to next page (together with the table it belongs to) or keep it on the same page, but only if there is at least one row of folowing data with it.

So in short - is it possible to configure header that it never sits alone on the page?

I may do some more testing, but for now I was not able to achieve this..

cheers

[Ruggero_Piccoli]

Hi,

You could repeat the headers on every new page:

Best Regards,

Ruggero

[julioarriaga]

what Lech_Miszkiewicz  said is correct, the repeat header doesn't solve my problem (actually I already have it activated in my report). I need a way of at least have one row of data in the page, or if it doesn't fit, to move the table to the next table.

[Ruggero_Piccoli]

Hi,

I suggest you to repeat the headers on all pages because there is not an option to do what you are looking for. I did some test without succeeding.

Another workaround cloud be to add a page break after the end or before the beginning of every table. The new table will start on a new page qo you will have many rows.

Best Regards,

Ruggero