Skip to main content
Solved

How to order column alignment in excel when exporting a report designer


 

Best answer by Laura02

Hello,

I know this is an old post but I just spent some time figuring out how to “unsquish” columns and ran into this similar unanswered post on the way to my success.  Here is the solution I found, using Manual Excel Mode.

In the report 1 Report property (found by clicking upper-left corner of report as circled) look for Excel Columns Collection, where we can adjust individual column width across the whole report. Width of each Excel column can be seen as vertical dotted green lines when we click View → Excel Grid. Adjusting column width in Excel Columns Collection has no impact on the PDF or printed outcome of the same report.

Excel Columns Collection
“BEFORE”
“AFTER”

If new columns are added to report designer but not added to Excel Column Collection, report can look like this when exported to Excel:

Need to add columns to Excel Column Collection and extend lines.

Solution is to add more columns to Excel collection, and extend underlines in Report designer to the “new extended right side” of report.

Laura

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+5
  • Captain II
  • 398 replies
  • June 8, 2021

Hello,

     have you tried my suggestion in below post yet?
 

 

The cells starts with the same location position would export into a same column.

 

This is the only way I know now,

also, if you have better findings, please let us know.


  • Author
  • Freshman I
  • 1 reply
  • June 8, 2021

I created a report in Report Designer and I'm trying to export it to Excel. It exports ok, but the columns don't line up. Is there any way to fix this?

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • January 3, 2024

Hello,

I know this is an old post but I just spent some time figuring out how to “unsquish” columns and ran into this similar unanswered post on the way to my success.  Here is the solution I found, using Manual Excel Mode.

In the report 1 Report property (found by clicking upper-left corner of report as circled) look for Excel Columns Collection, where we can adjust individual column width across the whole report. Width of each Excel column can be seen as vertical dotted green lines when we click View → Excel Grid. Adjusting column width in Excel Columns Collection has no impact on the PDF or printed outcome of the same report.

Excel Columns Collection
“BEFORE”
“AFTER”

If new columns are added to report designer but not added to Excel Column Collection, report can look like this when exported to Excel:

Need to add columns to Excel Column Collection and extend lines.

Solution is to add more columns to Excel collection, and extend underlines in Report designer to the “new extended right side” of report.

Laura


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings