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?
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.
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.
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.