Dear Telerik,
I'm using the CrossTab report for the first time, and have a very simple (seemingly) report. The rows of the report contain a list of equipment numbers, the columns contain a list of dates rotated 90 degrees, and the detail cell contains a simple integer value (like 30, 60, 90).
The report could produce 200-300 rows of equipment numbers, AND 100-200 dates across the top. (This report is "tall" and "wide")
For the life of me, I can't figure out how to get the "horizontal" data to break to new pages (and thereby repeating the equipment numbers, with the next set of dates at the top). It simply vaporizes off the side of the report. I have set the page size, and have tried the "KeepTogether" properties of all controls, etc.
The report is producing the proper layout...data..etc. I just need it to break new pages when it grows too wide for the page, and repeat the eqiupment numbers on the new page.
I have read the report tutorial PDF, and have scoured the website for an answer...I must be missing something simple...
Thanks!
Jason Perry
I'm using the CrossTab report for the first time, and have a very simple (seemingly) report. The rows of the report contain a list of equipment numbers, the columns contain a list of dates rotated 90 degrees, and the detail cell contains a simple integer value (like 30, 60, 90).
The report could produce 200-300 rows of equipment numbers, AND 100-200 dates across the top. (This report is "tall" and "wide")
For the life of me, I can't figure out how to get the "horizontal" data to break to new pages (and thereby repeating the equipment numbers, with the next set of dates at the top). It simply vaporizes off the side of the report. I have set the page size, and have tried the "KeepTogether" properties of all controls, etc.
The report is producing the proper layout...data..etc. I just need it to break new pages when it grows too wide for the page, and repeat the eqiupment numbers on the new page.
I have read the report tutorial PDF, and have scoured the website for an answer...I must be missing something simple...
Thanks!
Jason Perry
5 Answers, 1 is accepted
0
Hi Wedge,
To repeat the "equipment numbers" you should place them in a row group header and set RowHeadersPrintOnEveryPage=True. Unfortunately from your explanations I do not understand what exactly the layout of the crosstab is. If you send us a report with sample data we can give a more detailed advise.
Best wishes,
Hrisi
the Telerik team
To repeat the "equipment numbers" you should place them in a row group header and set RowHeadersPrintOnEveryPage=True. Unfortunately from your explanations I do not understand what exactly the layout of the crosstab is. If you send us a report with sample data we can give a more detailed advise.
Best wishes,
Hrisi
the Telerik team
0
Wedge
Top achievements
Rank 1
Rank 1
answered on 31 Mar 2011, 04:37 PM
Dear Telerik,
My apologies for not being more clear...
Attached are a couple of screen shots of the report. The columns of the cross tab are comprised of a "Service Date", and are grouped on "Service Date". The rows are comprised of "Tail Number" and are grouped on "Tail Number" (see the image report_layout.jpg).
When running the report (see the second image report_with_data.jpg), the list of columns (Service Dates) is so long, they run off the right-hand-side of the report page. I would like a new page to be generated when the page width is reached/exceeded.
In the example images I provided, 2 pages should have been created, but only one was created.
I appreciate your help!
Thanks,
Jason Perry
My apologies for not being more clear...
Attached are a couple of screen shots of the report. The columns of the cross tab are comprised of a "Service Date", and are grouped on "Service Date". The rows are comprised of "Tail Number" and are grouped on "Tail Number" (see the image report_layout.jpg).
When running the report (see the second image report_with_data.jpg), the list of columns (Service Dates) is so long, they run off the right-hand-side of the report page. I would like a new page to be generated when the page width is reached/exceeded.
In the example images I provided, 2 pages should have been created, but only one was created.
I appreciate your help!
Thanks,
Jason Perry
0
Hello Jason,
You have not mentioned the most important thing that is not obvious from your screenshots - the format you're rendering the report to.
If you're using a non page oriented format (i.e. logical page layout), then the report would be stretched as much as needed in both directions, unless you explicitly define a page break. Page breaks in Telerik Reports can be applied only per report sections.
Kind regards,
Steve
the Telerik team
You have not mentioned the most important thing that is not obvious from your screenshots - the format you're rendering the report to.
All Telerik Reporting output formats have specific characteristics that determine their usage and impose ceratin limitations, which need to be taken into consideration when designing reports.
The following rendering extension categorization shows how extensions vary:
- Data rendering extensions: CSV
- Logical page layout rendering extensions: HTML, Excel
- Physical page layout rendering extensions: Image, PDF, RTF, XPS, PPTX, DOCX
If you're using a non page oriented format (i.e. logical page layout), then the report would be stretched as much as needed in both directions, unless you explicitly define a page break. Page breaks in Telerik Reports can be applied only per report sections.
Kind regards,
Steve
the Telerik team
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 Public Issue Tracking
system and vote to affect the priority of the items
0
Wedge
Top achievements
Rank 1
Rank 1
answered on 05 Apr 2011, 06:57 PM
Thank you Steve,
Please forgive my ignorance - I'm totally new with these reports and simply don't know much about them - or the proper questions to ask.
Right now, I am trying to display the data on a web page, using the Telerik ReportViewer. That's where the screen shots came from, and that's where they will primarily be viewed. However, I need to be able to Export to both PDF and Excel.
The ReportViewer, on the web page, needs to have page breaks based on a standard page size of 8.5" / 11", like any piece of paper if it were printed out. This report will be exported also (PDF, XLS). Based on your explanation, I realize two things: the PDF export will need page breaks (as the data grows to the right, like my screen shots), and Excel will not need page breaks (it can be as wide as necessary).
I'm not sure how to approach this. I apologize for dragging this out for so long...any help is very much appreciated!
Jason
PS: I love Telerik! Your component suite has made my website (an aircraft scheduling and maintenance system) a huge success. It is fast, easy to maintain, and very, very attractive. You're the best, by far! My customer loves it!
Please forgive my ignorance - I'm totally new with these reports and simply don't know much about them - or the proper questions to ask.
Right now, I am trying to display the data on a web page, using the Telerik ReportViewer. That's where the screen shots came from, and that's where they will primarily be viewed. However, I need to be able to Export to both PDF and Excel.
The ReportViewer, on the web page, needs to have page breaks based on a standard page size of 8.5" / 11", like any piece of paper if it were printed out. This report will be exported also (PDF, XLS). Based on your explanation, I realize two things: the PDF export will need page breaks (as the data grows to the right, like my screen shots), and Excel will not need page breaks (it can be as wide as necessary).
I'm not sure how to approach this. I apologize for dragging this out for so long...any help is very much appreciated!
Jason
PS: I love Telerik! Your component suite has made my website (an aircraft scheduling and maintenance system) a huge success. It is fast, easy to maintain, and very, very attractive. You're the best, by far! My customer loves it!
0
Hi Wedge,
Your report in WebViewer will be shown in whole width, eventually with horizontal scrollbar. For now this behavior could not be changed. Hopefully, print preview in WebViewer is in our plans for the next release.
When exporting it to any page oriented format, the reporting engine will create additional horizontal pages to accommodate the width of the Crosstab.
Nevertheless, you can implement your own print preview by showing the pdf of the report in a separate window (e.g. RadWindow).
Kind regards,
Hrisi
the Telerik team
Your report in WebViewer will be shown in whole width, eventually with horizontal scrollbar. For now this behavior could not be changed. Hopefully, print preview in WebViewer is in our plans for the next release.
When exporting it to any page oriented format, the reporting engine will create additional horizontal pages to accommodate the width of the Crosstab.
Nevertheless, you can implement your own print preview by showing the pdf of the report in a separate window (e.g. RadWindow).
Kind regards,
Hrisi
the Telerik team
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 Public Issue Tracking system and vote to affect the priority of the items