Excel Page Width

[Mohsin]

There is a setting in page layout where you can set the page width from automatic to 1 page, 2 page. Can we use this feature while exporting the telerik report to excel. This will enable the report to be printed on a single page.

[Stef]

Hello Mohsin,

Telerik reports are rendering in Excel format based on the Design Considerations for Excel Rendering article. The Excel renderer is a logical layout renderer, which purpose is to put data with formatting close to the visualized in the report's interactive preview. The available settings for the renderer are listed here.

Controlling the print settings from Excel is not supported, instead you can test using PDF format.
In PDF there is a Javascript device setting allowing you to inject functionality in the document, which will be interpreted by the PDF reader. You need to set the report's PageSettings to a custom page format and size the physical page to gather the reports content. And export the report with injected a Javascript as in this code library post, which will force the PDF reader displaying the produced file to open its Print Dialog. Then the user can select the Adobe Print Dialog's Fit option (if not selected), which will use the Adobe Reader's resizing capabilities to gather the document on a single page.

Let us know if you have any further questions.

Regards,
Stef
Telerik

 

 

[Moe]

Hi Stef,

I would like to know until the logic not change? My problem also same Mohsin what he wants.

 

Thanks

Moe

[Silviya]

Hello Moe,

Only in in PDF there is a Javascript device setting allowing you to inject functionality in the document, which will be interpreted by the PDF reader.
In Excel (and other formats), you will have to manually configure the document or select proper Report.PageSettings (PaperSize, Margins, Landscape).

Regards,
Silviya
Progress Telerik

[Moe]

HI Silviya,

But still 2 pages . May I know do you have control of  'Fit Sheet On Page' for excel?

 

Thanks

Moe

[Silviya]

Hi Moe,

By design the exported Excel file is configured to use the default scaling option which happens to be No Scaling. The export to Excel settings do not expose an option to change this configuration to Fit Sheet on One Page at the moment. You can request such feature in the Ideas & Feedback portal.

Regards,
Silviya
Progress Telerik