Share via

SSRS report - Excel export and images

mark goldin 706 Reputation points
2023-02-10T13:31:28.9133333+00:00

I have a report where some columns show small icons. Everything like good in the Browser but in Exccel images size is not right. Here is how it looks in Excel:

User's image

Row 9 show the correct size. Image settings as following:

User's image

I tried other Sizings. Nothing worked. Obviously, when a group has more than one row the image is not sized properly. Any idea?

Thanks

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.
Microsoft 365 and Office | Excel | For business | Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-13T02:25:56.69+00:00

    Hi @mark goldin

    I found two ways.

    One is that after you download the picture, re-edit its size to the size you want, and then add it to the report, select "Original Size" for the size.

    Another method is to add the image, select "Fit proportional", and then adjust the Position Size in the image properties panel.

    1

    Preview:

    2

    Best regards,

    Aniya

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.