Skip to main content
Solved

Excel Layout and Report Designer


claudematherne24
Jr Varsity III
Forum|alt.badge.img

Finding out an issue where the Header on my report does not cover all cells when I export to Excel.  This is my first attempt at updating/adjusting Excel formatting with Report Designer.

How do I adjust a group or header to match the total cells on the report?  Or, is there some documentation on the Excel formatting and Report Designer?

Best answer by Sagar Greytrix

Hi @claudematherne24,

Please expand the Excel settings for your subaccount field in the header section and change the width of that field to the maximum column number in a single line. For example, if the subaccount field's column is set to 2 in the Excel settings and the report contains a maximum of 10 fields in a single line, the width of the subaccount field should be set to 9. This will ensure that the report header covers the entire width of the report.

Hope this solution works for you!

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

6 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • June 5, 2024

Hello,

Please click the field that exports “too small” and then expand the Excel settings.  Enter Width > 1 to change the default width of your header field.

Laura


claudematherne24
Jr Varsity III
Forum|alt.badge.img

two issues with this solution:

  1. when I did >1 in the width on the field, it crashed the report when running it
  2. It’s not a “field” that I’m having issues with I don’t think.  It’s the highlighted property of the header group/

claudematherne24
Jr Varsity III
Forum|alt.badge.img

Ok, I was reading >1 too literal I think.  Understanding now that width and height is number of cells.


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • June 5, 2024

Yes, I did mean a number greater than 1 cell! 

 

Laura


claudematherne24
Jr Varsity III
Forum|alt.badge.img

For the moment my work around is to add a blank text box that covers the number of cells I am trying to extend to, but it feels like there is a better solution.


Sagar Greytrix
Captain II
Forum|alt.badge.img+3

Hi @claudematherne24,

Please expand the Excel settings for your subaccount field in the header section and change the width of that field to the maximum column number in a single line. For example, if the subaccount field's column is set to 2 in the Excel settings and the report contains a maximum of 10 fields in a single line, the width of the subaccount field should be set to 9. This will ensure that the report header covers the entire width of the report.

Hope this solution works for you!


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