Keeping table headers on next page?

[Yessen]

So I have a table that spills to the next page if it doesnt fit into one page?

I want my table header to be appearing if report is more than one page. How can I do that? I tried so many things and cant figure it out.

Right now it is like this:
COLUMN1 COLUMN2
ROW 111111111111
ROW 222222222222
ROW 333333333333
END OF PAGE 1
ROW 444444444444
ROW 555555555555
ROW 666666666666
END OF PAGE 2
ROW 777777777777
ROW 888888888888
ROW 999999999999
etc...


I want it to be like this:
COLUMN1 COLUMN2
ROW 111111111111
ROW 222222222222
ROW 333333333333
END OF PAGE 1
COLUMN1 COLUMN2
ROW 444444444444
ROW 555555555555
ROW 666666666666
END OF PAGE 2
COLUMN1 COLUMN2
ROW 777777777777
ROW 888888888888
ROW 999999999999

etc...

 

[Kafrin]

Two options:

1) Put the headings in the PageHeader section (not the ReportHeader section).
2) Put the headings in a GroupHeader (depending on your grouping) and set the RepeatSection property for the Header to "Yes".

 

[Yessen]

Two options:

1) Put the headings in the PageHeader section (not the ReportHeader section).
2) Put the headings in a GroupHeader (depending on your grouping) and set the RepeatSection property for the Header to "Yes".

One the first page there is some information before the table starts

INFORMATION
INFORMATION
COLUMN1 COLUMN2
ROW111111111111
ROW222222222222

But on the next page if the table is long, it will contain only the table.

If I do the way you told me the headers of the table will be constantly fixed at the top of the page i.e page header. isnt it?

is there a way to say something like IF PAGE > 1 then show the page header i.e table header

 

[Kafrin]

So your first page information should be in the ReportHeader, which will appear before the PageHeader.

ReportHeader:
INFORMATION
INFORMATION
PageHeader:
COLUMN1 COLUMN2
Detail:
ROW INFO

If you are in fact using grouping, then add another grouping level, but identical to your existing one. So in Sorting & Grouping you have two identical rows. Then instead use:

GroupHeader1 (RepeatSection = No):
INFORMATION
INFORMATION
GroupHeader2 (RepeatSection = Yes):
COLUMN1 COLUMN2
Detail:
ROW INFO

 

[Yessen]

So your first page information should be in the ReportHeader, which will appear before the PageHeader.

ReportHeader:
INFORMATION
INFORMATION
PageHeader:
COLUMN1 COLUMN2
Detail:
ROW INFO

If you are in fact using grouping, then add another grouping level, but identical to your existing one. So in Sorting & Grouping you have two identical rows. Then instead use:

GroupHeader1 (RepeatSection = No):
INFORMATION
INFORMATION
GroupHeader2 (RepeatSection = Yes):
COLUMN1 COLUMN2
Detail:
ROW INFO

that looks like what I need

How do i do that? where do I set the groups and set the repitition to yes/no?

 

[Kafrin]

With your report open in Design view, go to View, Sorting and Grouping.

Under Field/Expression choose the field you want to group on.

In the bottom half of the screen set Group Header to Yes.

Repeat to produce a second identical line. Close the Sorting and Grouping window.

The select the second GroupHeader and go to View, Properties. One of the properties is called Repeat Section, set this to Yes.

Note that using grouping will change your report layout, look into the Help files before you go too far with this if you're not sure what it's doing. If you don't need any grouping, you should use the Page and Report headers as detailed above.

 

[Yessen]

With your report open in Design view, go to View, Sorting and Grouping.

Under Field/Expression choose the field you want to group on.

In the bottom half of the screen set Group Header to Yes.

Repeat to produce a second identical line. Close the Sorting and Grouping window.

The select the second GroupHeader and go to View, Properties. One of the properties is called Repeat Section, set this to Yes.

Note that using grouping will change your report layout, look into the Help files before you go too far with this if you're not sure what it's doing. If you don't need any grouping, you should use the Page and Report headers as detailed above.

I think easier way for me will be to say something like:

my report is grouped by initiatives.

so i need to say if current initiative page is more than 1, i.e spilled to next page

then show the page header.

if not , dont print it.

is there a way to refer to pages per initiative when report is being generated.

so lets say I have 5 initiatives and 2 of them have 2 pages

I would have total 7 pages.
It means
1 initiative = #Pages = 1
2 initiative = #Pages = 2
3 initiative = #Pages = 1
4 initiative = #Pages = 2
5 initiative = #Pages = 1

so how can I say in initiatives 2 and 4 like what I said above, if their pages are > 1 then print the page header?

thank you for your big effort...

 

[Kafrin]

The GroupHeader method I detailed will put the headings at the top of each group (under your Initiative headings) and at the top of each page.

Page1
Initiative1
COLUMN1 COLUMN2
Rows
Page2
COLUMN1 COLUMN2
Rows
Initiative2
COLUMN1 COLUMN2


The Page/Report header method will put the headings at the top of each page. This means they would only show once per page, but would appear above your Initiative group headings.

I am unsure what you are trying to achieve.

 

[Yessen]

The GroupHeader method I detailed will put the headings at the top of each group (under your Initiative headings) and at the top of each page.

Page1
Initiative1
COLUMN1 COLUMN2
Rows
Page2
COLUMN1 COLUMN2
Rows
Initiative2
COLUMN1 COLUMN2


The Page/Report header method will put the headings at the top of each page. This means they would only show once per page, but would appear above your Initiative group headings.

I am unsure what you are trying to achieve.

So i am grouping my reports by initiatives. How can I get the current page?

I want to say something like if initiative page count > 1 then make the header of the table visible?

All I am asking is how to get the current page count of the current initiative? Not overall number of pages in the whole report but the initiative's own page count by which the report gets grouped.

probably something similar to if Me.GroupHeader.Page > 1 then Me.groupheader.visible = true else Me.groupheader.visible = false