locked
Merge Cells Created On SSRS > Excel Export RRS feed

  • Question

  • Hi there:

    We have an SSRS 2008 report which includes 2 columns: FNAME  and LNAME

    When exported to Excel, these 2 columns appear as MERGE CELLS incorporating 3 Excel cells.  This makes it impossible to SORT.

    Report is based on a tablix -- source is SQL Server 2008.  Has anyone out there had this experience?

    Thanks!


    A. Wolf

    Friday, December 13, 2013 5:11 PM

Answers

  • Hi Wolf,

    Based on your description, you cannot sort the data on exported EXCEL file because of the merge cells, right?  

    I have tested it on my local environment, if we have any title headers or images attached in the report header, we need to make the width size of the text boxes exactly the same as the table width in the detail section. If an image (like a logo) is on the top left corner of the page header, make that width size the same as the first column width size of the detail table and align it.

    So in your scenario, if the merge cells were avoided, we can sort the column without any problem. To avoid the merged cells, the rows of the two tablixes must be aligned horizontally strictly, e.g. a row in the first tablix and the corresponding row in the second tablix must be in the same Excel row perfectly. 

    Here is a similar issue with yours for your reference.
    http://social.technet.microsoft.com/Forums/office/en-US/7fbb3d31-fc1b-4c9b-8a7d-afc76cbb0291/ssrs-2012-report-export-to-excel-and-sort-thje-data-on-excel-spreadsheet?forum=sqlreportingservices

    If I have anything misunderstood, please point it out and elaborate your iqque, if possible provide us a screenshot about it, so that we can make further analysis.

    Regards,
    Charlie Liao

    If you have any feedback on our support, please click here.


    Charlie Liao
    TechNet Community Support

    Sunday, December 15, 2013 3:56 AM

All replies

  • Are these columns part of group in your actual tablix?

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Friday, December 13, 2013 5:38 PM
  • Hi Wolf,

    Based on your description, you cannot sort the data on exported EXCEL file because of the merge cells, right?  

    I have tested it on my local environment, if we have any title headers or images attached in the report header, we need to make the width size of the text boxes exactly the same as the table width in the detail section. If an image (like a logo) is on the top left corner of the page header, make that width size the same as the first column width size of the detail table and align it.

    So in your scenario, if the merge cells were avoided, we can sort the column without any problem. To avoid the merged cells, the rows of the two tablixes must be aligned horizontally strictly, e.g. a row in the first tablix and the corresponding row in the second tablix must be in the same Excel row perfectly. 

    Here is a similar issue with yours for your reference.
    http://social.technet.microsoft.com/Forums/office/en-US/7fbb3d31-fc1b-4c9b-8a7d-afc76cbb0291/ssrs-2012-report-export-to-excel-and-sort-thje-data-on-excel-spreadsheet?forum=sqlreportingservices

    If I have anything misunderstood, please point it out and elaborate your iqque, if possible provide us a screenshot about it, so that we can make further analysis.

    Regards,
    Charlie Liao

    If you have any feedback on our support, please click here.


    Charlie Liao
    TechNet Community Support

    Sunday, December 15, 2013 3:56 AM