Share via

Export Header color

RoyB09 306 Reputation points
2020-09-16T15:49:11.28+00:00

Hello

I’ve got an expression on the Fill properties of the SSRS 2012 report header, =IIF(Globals!PageNumber<>1, "Blue", "Red") . The expression works on the report, the header on Page 1 is Red, all other pages the header is blue.

The problem happens when I export the report to PowerPoint, the header is a white colour.

Is there a straightforward way of getting over this issue?

Thanks in advance
Roy.

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

0 comments No comments

Answer accepted by question author

Joyzhao-MSFT 15,651 Reputation points
2020-09-17T05:53:36.953+00:00

Hi Roy,
@RoyB09
Since Powerpoint and SSRS have different concept about header/footer. Some render behavior is not exactly as we see in SSRS. Such as background color of report header will be ignored in PPTX file.
This is by design. I suggest you submit the requirement at https://feedback.azure.com/forums/908035-sql-server.
If the requirement mentioned by customers for many times, the product team may consider to add this feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided.
Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. RoyB09 306 Reputation points
    2020-09-17T09:05:37.847+00:00

    Thanks for the reply.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.