This is a migrated thread and some comments may be shown as answers.

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

22 Answers 2184 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Alexandre Jobin
Top achievements
Rank 1
Alexandre Jobin asked on 04 Oct 2011, 07:59 PM
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

22 Answers, 1 is accepted

Sort by
0
Squall
Top achievements
Rank 1
answered on 07 Oct 2011, 02:15 PM

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

0
Alexandre Jobin
Top achievements
Rank 1
answered on 07 Oct 2011, 02:52 PM
Hi Squall!

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


0
Pavel
Top achievements
Rank 1
answered on 27 Jun 2012, 03:43 PM
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
0
Peter
Telerik team
answered on 02 Jul 2012, 02:13 PM
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

BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >

0
Kelly Harris
Top achievements
Rank 1
answered on 13 Jul 2012, 04:03 PM
I looked at the report, is there a way to have the group header on the top of the page to say "(continued)"?
0
Elian
Telerik team
answered on 17 Jul 2012, 02:30 PM
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

BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >

0
Steven
Top achievements
Rank 1
answered on 18 Jan 2013, 04:55 PM
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"


0
Elian
Telerik team
answered on 23 Jan 2013, 12:41 PM
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

HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

0
Paul
Top achievements
Rank 1
answered on 21 Feb 2013, 08:41 PM
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
0
Massimiliano Bassili
Top achievements
Rank 1
answered on 22 Feb 2013, 10:43 AM
RowHeadersPrintOnEveryPage=true.
0
Ibrahim
Top achievements
Rank 1
answered on 27 Nov 2013, 12:28 PM
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
0
Peter
Telerik team
answered on 29 Nov 2013, 01:02 PM
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

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

0
Jolanta
Top achievements
Rank 1
Veteran
answered on 20 Oct 2014, 11:06 AM
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
0
KS
Top achievements
Rank 1
answered on 21 Oct 2014, 01:10 PM
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
0
Sneha
Top achievements
Rank 1
answered on 26 Jun 2015, 09:36 AM

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.

 

0
Stef
Telerik team
answered on 30 Jun 2015, 10:03 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Nicolo
Top achievements
Rank 1
answered on 04 Dec 2017, 11:10 AM

[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.

0
Katia
Telerik team
answered on 07 Dec 2017, 08:13 AM
Hello Nicolo,

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

Regards,
Katia
Progress Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Jolanta
Top achievements
Rank 1
Veteran
answered on 28 Jul 2020, 02:30 PM
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

0
Todor
Telerik team
answered on 31 Jul 2020, 12:14 PM

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

0
Jolanta
Top achievements
Rank 1
Veteran
answered on 31 Jul 2020, 12:23 PM
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
0
Todor
Telerik team
answered on 04 Aug 2020, 02:05 PM

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

Tags
General Discussions
Asked by
Alexandre Jobin
Top achievements
Rank 1
Answers by
Squall
Top achievements
Rank 1
Alexandre Jobin
Top achievements
Rank 1
Pavel
Top achievements
Rank 1
Peter
Telerik team
Kelly Harris
Top achievements
Rank 1
Elian
Telerik team
Steven
Top achievements
Rank 1
Paul
Top achievements
Rank 1
Massimiliano Bassili
Top achievements
Rank 1
Ibrahim
Top achievements
Rank 1
Jolanta
Top achievements
Rank 1
Veteran
KS
Top achievements
Rank 1
Sneha
Top achievements
Rank 1
Stef
Telerik team
Nicolo
Top achievements
Rank 1
Katia
Telerik team
Todor
Telerik team
Share this question
or