This is a migrated thread and some comments may be shown as answers.

Exporting Report to Excel without Design

1 Answer 446 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Ravi
Top achievements
Rank 1
Ravi asked on 18 Mar 2019, 02:00 PM

Hi,

Is it possible to export a report to excel using a sqldatasource, without considering the layout , groupings we have drawn inside the telerik report designer.

We need to use a same report to export both pdf and Excel. But in Excel we dont want to see the groupings etc.

We need to show the flat data like in oracle reports delimited data

 

Thanks,

1 Answer, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 21 Mar 2019, 08:41 AM
Hello Murugesan,

Try using the CSV export format. Most of the formatting will be ignored there. Keep in mind that items like Page Header/Footer Section, Shape, PictureBox, Chart are ignored during processing. In a data item, the columns are ordered as follows: corner members, row hierarchy members, column hierarchy members, and then cells. More details are available in the Design Considerations for CSV Rendering article.
For excel format you may take a look at Design Considerations for Excel Rendering

Regards,
Neli
Progress Telerik
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 Feedback Portal and vote to affect the priority of the items
Tags
Report Designer (standalone)
Asked by
Ravi
Top achievements
Rank 1
Answers by
Neli
Telerik team
Share this question
or