External Images

  • Card Gunner

    SSC Veteran

    Points: 248

    So I'm trying to get an external image to show after I deployed the report. When I run the unpublished report in Visual Studio it's not an issue. I have the Image Properties picture value to be somethings like this "File://L:/EQuipmentdata/100305/100305/thumbs/100305_tn.jpg" and it displays in design and preview. No problem. I deploy it and the picture does not show. There is nothing there. I have made sure the user in execution account is an admin.

    If I change the value to a web url of an image it works as intended.

     

  • scdecade

    SSC-Addicted

    Points: 498

    Card Gunner wrote:

    So I'm trying to get an external image to show after I deployed the report. When I run the unpublished report in Visual Studio it's not an issue. I have the Image Properties picture value to be somethings like this "File://L:/EQuipmentdata/100305/100305/thumbs/100305_tn.jpg" and it displays in design and preview. No problem. I deploy it and the picture does not show. There is nothing there. I have made sure the user in execution account is an admin.

    If I change the value to a web url of an image it works as intended.

    If a web url works then how about moving the file 100305_tn.jpg to somewhere it can be referenced by a web url?  What does "File://L:/EQuipmentdata/100305/100305/thumbs/100305_tn.jpg" mean to your deployment server?  Probably it cannot connect with that letter-name file path.

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Card Gunner

    SSC Veteran

    Points: 248

    I did have the images linked to our images folder on web server but it was taking a long time to render the report. It would time out after 30 minutes or more. It just started happening. I was told "Why don't you retrieve them from the local shared folder, thru the L directory. It will be less resourceful" That is what I'm trying to do. It is around 400 thumbnails. It worked for years but it progressively got slower and slower and now times out.

  • scdecade

    SSC-Addicted

    Points: 498

    What lead you to conclude it was the images which were causing the render to take so long?  400 thumbnails are tiny.  Is there a query being run too?

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Card Gunner

    SSC Veteran

    Points: 248

    Yes there is a query. It is a query I wrote years back, have never had an issue running it by itself, time wise. Just recently the report has timed out. The short end is I was told to try to capture the pics from our local shared drive, instead of reaching out to our off site web server,  and pull the photos in from there. And that works just fine till I run the deployed report. Should I be able to render photos from a local shared drive in the deployed report?

  • scdecade

    SSC-Addicted

    Points: 498

    The short answer is no.  Ideally the "share drive" would not be read from by your reporting server and definitely not by letter-aliased file path.  In reality it always depends.  But in general it's not a good idea imo.

    Are the 400 fingernails static?  Are they logos and borders and buttons that don't change?  Or are they images of xrays, profile pics, or pics that get replaced often?

    Do you have access to an Azure blob storage or S3 storage account?  I would use one of those.  If the files are static make it read only and if you're concerned about speed/scalability then add a CDN (Content Distribution Network) service to the storage directory.  If the files are replaced often then adjust the cache window in the CDN.  I think Azure defaults to up to 24 hours for file replacement (which end users could find annoying).

     

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Card Gunner

    SSC Veteran

    Points: 248

    My director found the answer. Replaced the letter drive "l" with the fully qualified name 'ServerName/FileShare/" and it works.

    So instead of File://L:/EQuipmentdata/100305/100305/thumbs/100305_tn.jpg it is File://Localservername/Filesharefolder/EQuipmentdata/100305/100305/thumbs/100305_tn.jpg

    Works great.

    To answer your question the 400 are static. No borders. I would create the borders in the report anyways. They are images of construction equipment.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply