Export To Excel with Server side paging applied

[Harsh]

Hi,

I have applied server side paging in my application.I want to export data to excel.
But due to paging at any point of time i do have one page data only not the complete set.
How i can export whole data to excel.

Regards,
Harsh

[Vlad]

Hi Harsh,

 Why not use Telerik Reporting to export the data server-side and download the result? 

Best wishes,
Vlad
the Telerik team

[Harsh]

Thanks Vlad .

I am not clear how i will be doing that.I saw some of the reporting services sample but it was not clear to me after that as well.
I don't want to redirect user to any other page to export the data.The samples which i saw those were having some kind of
UI to export data.
I tried to install Reporting service sample app on my desktop but was not able to do so beacuse it was looking for SQL server installation which i am not having.

Please guide me to some link or sample program which can help me to figure this issue out.

Thanks in Advance.
Harsh

[Steve]

Hello Harsh,

I cannot comment on the GridView's export to Excel and how it works, but the Reporting tool is not a generic exporting tool. A report is a template following strict rules for layout and pagination and meant for generating documents.

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

The logical layout formats (HTML, Excel) are best suited for viewing and manipulating data, while the physical layout formats are intended for precise printing.

Having the above in mind, the Excel format does not offer physical pages and cannot follow any rules applicable for page oriented formats, so you would not be able to apply any custom paging. More information on the Excel format is available in the Design Considerations for Excel Rendering help article.
Another article that would be useful in your case: Exporting Report in Silverlight.

Best wishes,
Steve
the Telerik team