Exporting Report to Excel without Design

2 posts, 0 answers
  1. Murugesan Jambukesan
    Murugesan Jambukesan avatar
    16 posts
    Member since:
    Sep 2009

    Posted 18 Mar 2019 Link to this post


    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



  2. Neli
    Neli avatar
    255 posts

    Posted 21 Mar 2019 Link to this post

    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

    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
Back to Top