Forum Discussion
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 e...
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:
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.