Excel report displaying additional blank columns (paginated report)

Hi Marion 

Sorry I misunderstood it. I found some solutions to this problem of SSRS reports. Hope they are helpful. You would need to adjust the column header or text box widths and positions in the paginated report.

How to Eliminate Excel Column Merging in Exported SSRS Reports | PTR

How to Export to Excel Without Making a Mess - Red Three Consulting

How do I get rid of Excel column merging in export SSRS report? – QuickAdviser (quick-adviser.com)

Below the suggestions from the official document: Export a paginated report to Microsoft Excel (Report Builder). 

If it is important that reports exported to Excel worksheets can be sorted, then the following can help you reduce the number of merged cells in your Excel worksheets, which is the common cause for difficulties with Excel sort functionality.

• Not aligning items left and right is the most common cause of merged cells. Make sure the left and right edges of all report items line up with one another. Making items align and the same width will solve the problem in the majority of cases.

• Although you align all items precisely, you might find in some rare cases that some columns continue to be merged. This could be caused by internal unit conversion and rounding when the Excel worksheet is rendered. In the report definition language (RDL), you can specify position and size in different measurement units such as inches, pixels, centimeters, and points. Internally the Excel uses points. To minimize conversion and the potential inaccuracy of rounding when converting inches and centimeters to points, consider specifying all measurements in whole points for the most direct results. One inch is 72 points.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.