Export only data instead of report while exporting to excel in report viewer

[RAVINDRA]

Hi

I am using ReportViewer to display the reports and also to export the reports in the required format. Here i want a change in the existing system such that when user tries to export to excel, instead of displaying the report in the excel, we want to display the underlying data in the excel sheet. Please let me know whether the existing system support this functionality?

Thanks in advance
Ravindra

[Peter]

Hi Ravindra,

The Excel Rendering Extensions tries to reproduce as much of the original report as possible regarding layout and styling. In order to export only data we recommend you to use CSV rendering extension. Another option is to have a second report layout for exporting raw data and export this raw data report as elaborated in Accessing Report Engine help articles.

All the best,
Peter
the Telerik team

[RAVINDRA]

Thanks for the response Peter. Can you please let me know how do i override the csv rendering for the report the way i wanted to display the data?

Thanks
Ravindra

[Peter]

Hi Ravindra,

I am not sure I have correctly understood your inquiry. Generally the available options for the CSV rendering extension are listed in the CSV Device Information Settings help article. However if those options don't cover your requirements for CSV export you can create your own rendering extension for Telerik Reporting as shown in the attached sample solution.

Greetings,
Peter
the Telerik team