Sorting issue while export to EXCEL in Merged Cells. RRS feed

  • Question

  • I need help in solving this issue..i built an report but this report has been used by the Business users only in the Excel format.So need to export this Report to Excel..

    The problem is In my report i had an Header and Footer.when we export to excel this header will show as Merged Cells and The Users can not Sort any of the Columns.When they select any Columns then if they try to Sort them they are getting an error message...Sorting cannot be done on The Merged Cells.

    Monday, January 10, 2011 12:01 AM