SSRS Add an external image using a URL string from data

kirbedin 6 Reputation points
2022-11-01T13:26:46.33+00:00

Hello,

I am trying to add an image to a report which is a URL, but the URL will change depending on the data used to run the report.

For example, I have event names such as Aladdin and The Temptations. When these are set up in the system, the user will input an image URL into an attribute which we can then output as a string.

Example data:

Event Name: Aladdin Event Image URL: https://upload.wikimedia.org/wikipedia/en/b/be/Aladdin_Disney_pose.png

I have tried just using the Event Image URL attribute in the settings as shown below, but the image outputs as a small red cross.

256113-image.png

I have tested by typing in the URL directly, and this works successfully.

I was wondering if anyone had any ideas on how I could achieve this?

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,870 questions
0 comments No comments
{count} vote

2 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,571 Reputation points
    2022-11-02T01:30:56.427+00:00

    Hi @kirbedin ,
    When you use an external image in a report, the image source is set to External and the value for the image is the URL address or path to the image. Please typing the full URL of the image in the Use this image box: for example, https://\<SharePointservername>/\<site>/Documents/images/image1.jpg.
    When the report is run on the report server, the image in the report may not be displayed if the server credentials are not sufficient to access the image (You must verify that the image exists and that the report reader has permissions to access the image). In that case, contact your system administrator.
    For more information, see:
    Specifying Paths to External Items (Report Builder and SSRS).
    Add an external image to a paginated report (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.


  2. AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor
    2022-11-02T02:57:22.803+00:00

    Hi @kirbedin
    I don't particularly understand what you mean by the event image URL attribute. Is it a parameter or something?
    Do you want the user to enter an image URL of any website and display it in the report?
    I set a parameter "image" and then use it when adding the image. When the user enters a valid image url, it displays the corresponding image.
    256262-1.png
    256230-2.png
    If I misunderstood what you mean, please tell me more details.
    Best regards,
    Aniya