Horizontal Paging - columns repeating

[Peter]

Hi;

I'm new to Telerik reporting and would like to ask a question. I have a report that will paginate horizontally. To clarify - there will be more columns that can fit on a single page. This report will also contain 2 columns that are required to display on each page. So - the report will have the following - 2 columns (displayed on the left side) - that will show on every page. 1 or more columns that will be displayed to the right of the first 2 columns - and these columns may require horizontal pagination.

What I would like to know is how to configure a Telerik Report to operate like this. I was thinking using multiple groups - but I've found that groups will be displayed sequentially on the report - and I do not know how to get groups to to disaply beside each other. I looked at the table item and it looks like it is suppose to handle horizontal paging - but I need some way to set the table to repeat columns on a page. Or find another way to do this part.
Peter

[Petio Petkov]

Hi Peter,

We're not sure that we fully understand your requirements. Are the two columns on the left static i.e. do they contain static contain and that is the reason you want to repeat them? If so, then you can easily achieve such a layout with the Table item with the two columns in question being Table row headers. Then in order to repeat the row headers on every page whenever horizontal carry over occurs, you need to set the RowHeadersPrintOnEveryPage property of the Table to true.
If the columns are not static, then please elaborate? Is this going to be a free multi-column layout? If so check the Creating Multi-Column Reports functionality.
You can get a general overview of how the Telerik Reporting can be used, by looking at our online demos, which are available here.

Hope this helps.

Greetings,
Petio Petkov
the Telerik team

[Peter]

Hi;

It's actually 3 columns on the left - and yes they could be thought of as being static. With a table - are you saying that certain columns in a table could be locked (i.e. appear on each page) and the rest would display based on what page they render to?


Peter

[Petio Petkov]

Hi Peter,

Yes, if those "columns" are actual headers of the CrossTab item, then using the table's RowHeadersPrintOnEveryPage Property and they would beprinted on each page.

Let us know if you have any other questions.

Regards,
Petio Petkov
the Telerik team

[Peter]

Ok;

I am trying to still get my head around how to perform this task. Maybe some clarity. I have a data source that will contain 3 or more fields. On the report the first 3 fields will be repeated. For example - if there is a total of 7 fields and the report will break horizontally then the following is the output I'm looking for:

Page 1
Field1    Field 2    Field 3    Field 4    Field 5
1            2             3             a             b
4            5             6             c             d
7            8             9             e             f

Page 2
Field1     Field 2    Field 3    Field 6    Field 7
1             2             3             g             h
4             5             6             i              j
7             8             9             k             l

I need to be able to repeat the first 3 fields. This is related to the data set. It contains records with 7 fields - but the content related to each record can not fit on a page horizontally.

I am putting this report together via code - and I am using the report designer to get me close. But I cannot see how to perform the above. The RowHeadersPrintOnEveryPage function has no documentaion on how it is used - and when I attempt to use a CrossTab report it crashes. I would say that the docunetation on the API is lacking and is not up to the level for the UI interface designer which makes it a bit difficult to figure out how to use via code. It has been trial and error - which is not very efficient.

Peter

[Petio Petkov]

Hello Peter,

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. 

The CrossTab control doesn't support frozen columns feature. You can achieve similar behavior only if you use static data as a column header and set RowHeadersPrintOnEveryPage property to true. So, if there is not enough space for all CrossTab columns to fit on a single page they will be moved to the next one and all row headers will be printed on each page.

Regards,
Petio Petkov
the Telerik team

[Peter]

Ok; I'm having a really hard time understanding your responses. I needs an exact example similar to what I'm trying to achieve. You mention static data - and I have no idea what you mean by this. Did you look at the layout and datasource description I gave in my previous post? Does it look like data within that context can be layed out in a report the way I described?

When I supply information I would expect that your answer refers to it so I can corelate. The answers you give seem to be standard responses and in no way help. I looked at the example supplied by Telerik - and I cannot see how it works. It looks like it was generated via the UI tool - I'm doing this directly in code.

Also the RowHeadersPrintOnEveryPage property is available within the table item control - are you saying that the Table control does not have this ability?

Peter

[Petio Petkov]

Hi Peter,

To prevent any future misunderstanding, let us summarize. 
The CrossTab/Table controls don't support frozen columns feature. This means that the layout you want can't be achieved. 

A similar layout could be achieved when you use RowHeadersPrintOnEveryPage property to true. For your convinience I created an example against the AdventureWorks database. Please find it attached. The Table's RowHeadersPrintOnEveryPage property is set to true and all the Row headers(background color:Red) are printed on every page.

Let us know If you have any other questions.

Greetings,
Petio Petkov
the Telerik team

[Peter]

Will review what you supplied. I understand the limitations. My question was not explcilty related to any part but was a general question to identify how to perofrm what I needed to do.

Peter