Report sent with subscription missing logo (.jpg)

  • Hi,

    I built report in SSRS 2012 with logo in its header (which is listed in Report Data/Images) , I can see logo perfect once I ran on server or in VS, and once downloaded as xls,pdf.

    But when I ran this report via subscription I don't see this logo on email (i'm on Lotus Notes).

    Anybody experienced this strange behavior ?

    Thanks

    mario

  • Update for all and another call for help!!

    I figured out that subscription is running under service account, so I need to provide <Image access for this account>, not sure how to do this, as I don't have full access to our server.

    But this path sounds promising..

    Anybody knows what is default service account name for SSRS subscriptions? I can edit report security, but I can't see that account name.

    At the same time I see that img got translated into Image_Data in binary format, so I think rdl should be self inclusive..?

    Best

    Mario

  • mario17 (2/8/2016)


    Update for all and another call for help!!

    I figured out that subscription is running under service account, so I need to provide <Image access for this account>, not sure how to do this, as I don't have full access to our server.

    But this path sounds promising..

    Anybody knows what is default service account name for SSRS subscriptions? I can edit report security, but I can't see that account name.

    At the same time I see that img got translated into Image_Data in binary format, so I think rdl should be self inclusive..?

    Best

    Mario

    Unless Lotus Notes can see the path of the logo, it's not going to be able to find it to display it. If you send it offsite, whomever uses it offsite won't be able to see it unless you include it somewhere offsite that folks can see.

    I think there's a way to embed the logo in SSRS like you do with PDFs but I'm not a decent SSRS user. I try to avoid such "visual" things. 😉

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Thanks Jeff,,

    I tested this on iphone and yahoo and it's same result, so it's not Lotus.

    Also!!!!

    THere is no path in .rdl file to that picture, so I don't think "path of the logo" is applicable in this case, rdl/xml file has this picture embedded,

    something like in sample below. I think upon rendering it getting back to image file but because of all those formatting in email it could not be seen in the right place.

    In yahoo mail I got image as attach file without extension (jpg), once downloaded was able to see perfectly.

    I think we can't do anything about this.

    ....

    <EmbeddedImage Name="report_logo">

    <MIMEType>image/jpeg</MIMEType>

    <ImageData>/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAIBAQIBAQICAgICAgICAwUDAwMDAwYEBAMFBwYHBwcGBwcICQsJCAgKCAcHCg0KCgsMDAwMBwkODw0MDgsMDAz/2wBDAQICAgMDAwYDAwYMCAcIDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAz/wAARCAFFA+sDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD9/KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACi

    iigAooooAKKKKACiiigAooooAKKKKACiiuc8Z/F/wv8ADu+it ......

Viewing 4 posts - 1 through 3 (of 3 total)

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