Can't see image in the text box after export rdl report to Excel and Word

Dada 1 Reputation point
2022-11-25T13:45:38.573+00:00

Hello,

I have rdl report with a text box. In the text box background image is set to Embed and the embedded image is added.

Preview shows the image and text as expected.

When I choose Export to PDF everything works fine, but when I export the same report to Word and Excel only text is visible, but image is not.

Is there any additional setting that should be set?

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.
2,798 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,566 Reputation points
    2022-11-28T02:33:12.777+00:00

    Hi @Dada
    When you export to Excel format, The following limitations apply to images:

    • Background images for report items are ignored because Excel does not support background images for individual cells.
    • The Excel rendering extension only supports the background image of the report body. If a report body background image is displayed in the report, the image is rendered as a worksheet background image.

    When exporting to Word format, Report body and page background images and colors are not rendered.

    See more:
    Export a paginated report to Microsoft Excel (Report Builder).
    Export a paginated report to Microsoft Word (Report Builder).
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.

    0 comments No comments

  2. Dada 1 Reputation point
    2022-11-28T08:50:37.127+00:00

    Thank you for the explanation.

    Actually, I wanted to display cell background as shown in the picture bellow and followed instructions I got in the link below. It works for PDF, but not for Word and Excel.

    https://stackoverflow.com/questions/74391022/stripes-in-background-in-rdl

    264668-strpies.jpg

    Is it possible to get stripes in the tablix cell background in rdl?

    Thanks.

    Regards,
    Dragana

    0 comments No comments