SSRS footer text color not changing?

Question

We are applying a stylesheet to SSRS report footer. Footer Font color is set dynamically based on the configuration in the database. When report is exported into Excel, footer color is always black. It is always black in the SSRS report as well. However PDF export shows the footer color correctly. Has anyone faced this issue with footer color in Excel export? Is it not possible to change the footer color in Excel export? Any tips are appreciated. Thanks in advance

Answer 1

Move footer content into the report body

If Excel formatting matters:

1. Place the “footer” text in a textbox at the bottom of the report body
2. Set:
3. RepeatWith = <tablix name>
4. KeepTogether = false
5. Apply your dynamic color expression there

This will export correctly to Excel.