Paginated report: Excel Output Merged Columns

[abpgupta]

Hi All

We have well formatted report using Paginated report. It shows everything in correct format in PDF; however, in Excel, Multiple Excel columns are merged for few columns. Is there any way to have content only in Single cell for each table in Excel format?

There are other sections on report to display parameter selected.

Export to CSV is not option due to limitation on passing parameters (from previous issue posted in community) and have multiple tables.

Thanks for inputs!

[ofthelitch]

These tips from How to Eliminate Excel Column Merging in Exported SSRS Reports woked for me:

1. Ensure all of your unbound Textboxes are sized to match your tablix width.
2. Ensure all unbound textboxes fit within a tablix column.

[v-yalanwu-msft]

Hi, @abpgupta ;

If the PDF display is correct and cannot be exported to Excel due to limitations, consider using a third-party conversion tool to convert the PDF to Excel, such as：

https://smallpdf.com/pdf-to-excel

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.