Hello Telerik,
I am doing a report with the option of exporting to excel and pdf.
All run fine. But when I open the print preview in the excel file, I see an extra blank page..
I look for info about this behavior in the forums and I found I need to review the widths of the controls not to exceed the entire report document.
I checked that and all is fine... but the report continues generating an extra page.
I attached 3 files:
- PrintPreview.png : Shows the example for the extra page.
- NormalView.png: shows my report in excel.
- ReportProperties.png : contains all the source code for the report file. You can see how is set the page size and controls... I could not find anything wrong.
Can you help explain me how to avoid this behavior?
Thank you in advance.
Regards
I am doing a report with the option of exporting to excel and pdf.
All run fine. But when I open the print preview in the excel file, I see an extra blank page..
I look for info about this behavior in the forums and I found I need to review the widths of the controls not to exceed the entire report document.
I checked that and all is fine... but the report continues generating an extra page.
I attached 3 files:
- PrintPreview.png : Shows the example for the extra page.
- NormalView.png: shows my report in excel.
- ReportProperties.png : contains all the source code for the report file. You can see how is set the page size and controls... I could not find anything wrong.
Can you help explain me how to avoid this behavior?
Thank you in advance.
Regards
3 Answers, 1 is accepted
0
Hi ,
The print preview in Excel is out of the scope of the reporting engine and has its own page settings we do not have control over. Once the report is created, in the Report Designer's or viewer's Print Preview you can check how it will look in a physical format with the set report's PageSettings.
When you use the Excel report renderers, the report will be exported in logical page format, where the content is gathered in a single Sheet, unless you use a ReportBook where each report has its own sheet. For more details check our Design Considerations for Excel Rendering.
Regards,
Stef
Telerik
The print preview in Excel is out of the scope of the reporting engine and has its own page settings we do not have control over. Once the report is created, in the Report Designer's or viewer's Print Preview you can check how it will look in a physical format with the set report's PageSettings.
When you use the Excel report renderers, the report will be exported in logical page format, where the content is gathered in a single Sheet, unless you use a ReportBook where each report has its own sheet. For more details check our Design Considerations for Excel Rendering.
Regards,
Stef
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.
0
Enrique
Top achievements
Rank 1
Rank 1
answered on 21 May 2014, 12:07 AM
Hi Stef,
Thank you for the response.
I did some changes based upon your link provided. I changed to native headers, and seems to be the best approach.
However, there are two issues I found (you can view the issues on the screenshot attached) :
1) In the header appears a strange text of ".5" before the textboxes... Why is that?
2) using native headers, the expression Page # does not work properly. How can I hide that texbox when rendering in excel? Or is possible to make it work?
Thank you in advance.
Thank you for the response.
I did some changes based upon your link provided. I changed to native headers, and seems to be the best approach.
However, there are two issues I found (you can view the issues on the screenshot attached) :
1) In the header appears a strange text of ".5" before the textboxes... Why is that?
2) using native headers, the expression Page # does not work properly. How can I hide that texbox when rendering in excel? Or is possible to make it work?
Thank you in advance.
0
Hi ,
There is no attachment to your post. Our tests does not point to any issues with the Excel rendering, thus it would be better if you open a support ticket and send us a demo project that illustrates your report, settings and reproduces the problem.
Regards,
Stef
Telerik
There is no attachment to your post. Our tests does not point to any issues with the Excel rendering, thus it would be better if you open a support ticket and send us a demo project that illustrates your report, settings and reproduces the problem.
Regards,
Stef
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.