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 Link to this post

    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,

  2. Neli
    Admin
    Neli avatar
    100 posts

    Posted 21 Mar 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

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