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
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!
+19Hello,
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
two issues with this solution:
Ok, I was reading >1 too literal I think. Understanding now that width and height is number of cells.
+19Yes, I did mean a number greater than 1 cell!
Laura
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.
+3Hi
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.