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
0
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
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