How to repeat group header on each page with Table/Crosstable?

[Alexandre Jobin]

hi!

i have a report that use the Crosstable item. I have defined a group that can have many items below it. If a group must split on two pages, is there a property to tell the crosstable to repeat the group details? and if there's a function to do that, is it possible to add something to the group details? on the following example, the second page will continue to print the Group2 details and i would like to add "group2 (continued)"

                   | col1   | col2   | col3
group1
   item1      1           2           3
   item2      1           2           3
   item3      1           2           3
   item4      1           2           3
group2
   item1      1           2           3
   item2      1           2           3

===== change page =====

                 | col1    | col2   | col3
group2 (continued)
   item3      1           2           3
   item4      1           2           3





alex

[Squall]

Hi,
To repeat the crosstab on every page set Crosstab.ColumnHeadersPrintOnEveryPage to True.
SN

[Alexandre Jobin]

Hi Squall!

ColumnHeadersPrintOnEveryPage will only show the columns header on each page. I have edited my first post to be more specific.

[Pavel]

Hi All,

is there any update regarding this issue? I would say this has to be required behavior in lot of the reports which use row groping. Am I wrong?

Thank you,

Pavel

[Peter]

Hello,

The Product Sales online example has a CrossTab item with ColumnHeadersPrintOnEveryPage and RowHeadersPrintOnEveryPage  properties set to true. If you expand all the row headers and column headers and after that switch to Print Preview - row and column headers will be printed on each page. Thus you will see the appropriate header on each page. 

Kind regards,
Peter
the Telerik team

[Kelly Harris]

I looked at the report, is there a way to have the group header on the top of the page to say "(continued)"?

[Elian]

Hi Kelly,

When PrintOnEveryPage is set to true for the Group Header/Footer, the sections on each page are always identical. The section is processed only the first time and afterwards a copy of it is printed on the rest of the pages, so distinguishing between them is not possible. 

Greetings,
Elian
the Telerik team

[Steven]

We have data that is already flattened so we are using a regular table,  We also need the Row Headers to span the entire width of the columns.

=Report Explorer
[groupHeaderSection]
  - [SubReport - repeats on every page]
[detailSection]
  - [Table]
        [HeaderRowSpans as Group Title                                              ]
        [TitleColumn] [Data Col1 - Col6 (Flattened in storedprocedure)]


=Table Group Explorer
[OuterRowGroup]
     [Static]  --- I want to repeat this on every page
          [InnerRowGroup]
                 [Details]
          [Static InnerGroup Footer]
     [Static OuterGroup Footer]


Is there any way to get the Static Row to repeat on every page or do I need to move this to another outer group of the detailSection and then just filter the data when binding to the Table within the detailSection and Bind to "ReportItem.Parent.DataObject"

[Elian]

Hi Steven,

Only the Row and Column Headers can be set to be printed on every page. In this case, you will have to rearrange the report layout to fit you needs. 
 
All the best,
Elian
the Telerik team

[Paul]

In a situation where a particular group is larger then one page can that groups title be repeated? See below

Columns headers
______________________
Group1 | xinfox
             | xinfox
             | xinfox
             | xinfox
             | xinfox
             | xinfox
                             page 1
Column headers
______________________
Group1 | xinfox
             | xinfox
Group2 | xinfox
             | xinfox
             | xinfox
             | xinfox
                            page 2

[Massimiliano Bassili]

RowHeadersPrintOnEveryPage=true.

[Ibrahim]

Hi 


I have the same Problem 
I insert more than one row as Column header 
And more than one row as Row Header

and I delete allot of these headers may be I delete the default one
and I Made the property of the columnPrintOnEveryPage And RowPrintOnEveryPage  = True
But It is not appear with the pages just Appears in the first page and with the begin of the group but not with the beginning of every page

[Peter]

Hi,

Generally Table/Crosstab item template and wizard, generates table with a header. However if you have removed the table header, ColumnHeadersPrintOnEveryPage will not have any effect. Check out the attached video that illustrates how to create a table header.

Regards,
Peter
Telerik

[Jolanta]

Hi, I have a basic question, in similar matter:
I have a simple table with column headers, in a group section (e.g. group by the table first column). I want to display the column headers only the at the beginning (for first group), nextly I want to have a simple or an empty line (just to keep a distance to the next group).
I am beginner with telerik reports, that’s way this question.
Greetings,
Jola

[KS]

Hi,

Group sections are printed for each new group of data, and so is their content (the whole table in the group section) - Report Structure. Try other layout with TextBoxes only.

-KS

[Sneha]

Hi,

I am using a crosstab,and I need to display the first column to repeat on each page when it is exported in PDF or TIFF format.

For this I have set RowHeadersPrintOnEveryPage=True.On Exporting the data to Pdf format,I am getting an additional blank page at the end with only PageHeader and Page Footer Section getting display.

Please suggest a solution to get rid of this blank page.

 

[Stef]

Hi Sneha,

Please check the approaches from the Problem: Telerik Reporting renders blank pages KB article to determine which is the item causing the horizontal paging, and test applying the recommended settings.

I hope the provide information is helpful.

Regards,
Stef
Telerik

[Nicolo]

[quote]Paul said:In a situation where a particular group is larger then one page can that groups title be repeated? See below

Columns headers
______________________
Group1 | xinfox
             | xinfox
             | xinfox
             | xinfox
             | xinfox
             | xinfox
                             page 1
Column headers
______________________
Group1 | xinfox
             | xinfox
Group2 | xinfox
             | xinfox
             | xinfox
             | xinfox
                            page 2[/quote]

Hello @Paul did you find a solution for this issue?

 

Thanks in advance.

[Katia]

Hello Nicolo,

To repeat the Group Header section on each page, set PrintOnEveryPage property of this section to true.

Regards,
Katia
Progress Telerik

[Jolanta]

Hi,
Unfortunately, there is a case, where it does not work as declared:(
  When PrintOnEveryPage is set to true for the Group Header/Footer, the sections on each page are always identical. The section is processed only the first time and afterwards a copy of it is printed on the rest of the pages, so distinguishing between them is not possible.

Case:
You have PageHeader, then GroupHeader, then Details, then GroupFooter, then PageFooter.
In PageHeader - textBox, value = "Text- page-header", printOnEveryPage=true
In GroupHeader - textBox, value = "Text- group-header", printOnEveryPage=true
In Details, you have a table, which can spread horizontally. printRowHeadersOnEveryPage=true
In GroupFooter - nothing.
In PageFooter - textBox, value = PageNumber + "/" + PageCount

The table does not fit one page, horizontally.
Result:
- More pages are generated (OK)
- "Text- page-header" - repeated on each page (OK)
- "Text- group-header" - ONLY ON FIRST PAGE :-(
- Row headers of table - repeated on each page (OK)
- Page number/ page count - correctly printed on each page

So, only the GroupHeader printOnEveryPage does not work, and I need just this function...

Greetings,
Jola

[Todor]

Hello Jola,

You are right that in the described scenario the Group Header/Footer won't be printed on every physical page, as the physical paging is due to horizontal page breaks - see Understanding Pagination. By design, the Report Group sections occupy the entire Report width and for that reason cannot repeat on physical pages caused by horizontal page breaks.

In this case, the Group section is split horizontally between the pages. You may paint the backgrounds of the sections in different colors to see that all the sections but the Page sections get split horizontally between physical pages formed by horizontal page breaks. Upon vertical page break, the Group Header/Footer will re-appear.

This behavior is by design and is expected. For example, if there is a Crosstab in the Group Header/Footer that also grows, it will be split between the pages introduced with horizontal breaks as it cannot be accommodated on a single physical page. 

Regards,
Todor
Progress Telerik

[Jolanta]

Thank you for explanation. I have slowly understood the problem (I just made it with background color, as you here suggest.
I know, the horizontal spread is not usual wished. I just managed to make an workaround, by adding the header to pageHeader, as it was an artificial group - just for to be able to report reportHeader at each page.
I wonder, some features are not available,  what is the problem to allow it?
1). The ReportHeader (not the PageHeader) - has no possibility to be repeated on each page.
2). Page header does not except tables and all, and in particular, tables with its own DSource.

So, I had to add a "custom" table - just constellation of textBoxes, to the pageHeader, and add this "custom" table DS as report DS.
So, now it works, but if I had several DS to my report header, i would be not able to apply this workaround.

Greetings,
Jola

[Todor]

Hello Jola,

All the report sections have their purpose. The Report Header/Footer sections are the introductory/finalizing sections of the Report. They are displayed once by design. They can grow and may host data items.

The Page sections are displayed on every page and occupy a specified area that cannot change. They can be either visible or hidden on each page, but their height when visible cannot change. Due to the page counting that is specific for each rendering extension, the page sections get generated later in the workflow when the data is not available. This is the main reason why it is not possible to use data items in these sections. In addition, data items usually grow due to the number of data records. However, the Page sections cannot grow, hence in many cases the data would not be displayed correctly if there were data items in the Page sections. 

Regards,
Todor
Progress Telerik