Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Having issue while exporting data to excel from SSRS

Hi Team,

     Having some issue while exporting data from two different tables. i have two different tables in SSRS one for XX department and second table is for YY department in single page. When exporting to excel from result there is separate line between two tables. I want to remove that line and want to show looks like single table. Any idea or suggestion to exclude that row please.

 

Regards,

Sampath. 

@Power BI Report Builder

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    For reports that contain groups of rows or columns, you need to make changes after exporting to Excel before you can display the exported data in a pivot table. You must add the group values to the cells that are missing the group values. As a result, the worksheet becomes a flat table with values in all cells. The following figure shows the updated worksheet.

    Ensure that there are no extra rows or spaces between two tables in the SSRS report design. Sometimes even small gaps can cause the exported file to appear separated.

    Below is the official link will help you:

    Export a paginated report to Microsoft Excel (Report Builder) - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.