FSG Formatting in Excel 2007
We have an FSG Row Set where after each subtotal we have set the Number of Lines to Skip After to 1. This is to make the subtotals stand out on the report. In the corresponding Excel Template we have formatted the subtotal rows by adding shading to the cells and formatting the font to bold. Again this is to make the subtotals stand out on the report.
However, when we publish the report to Excel, the subtotal formatting is also carried down onto the blank row underneath each subtotal. i.e.
Total Operating Revenue | xxxxx | xxxxx | xxxxx | xxxxx |