locked
CRM Online - entityimage not working in SSRS RRS feed

  • Question

  • So, in the latest and greatest CRM you can get access to the Entity Image using “special attributes” within fetch:

    <fetch distinct="false" no-lock="false" mapping="logical"> 
      <entity name="account">
        <attribute name="entityimage" />
        <attribute name="entityimage_url" />
      </entity>
    </fetch>


    The first is supposed to return a byte array… doesn’t work in SSRS though for some reason.

    The second does indeed return the URL… but if I try to add it as an external image my entire report blows up (i.e. it’s not just the image that won’t display, the entire report won’t render).

    I’ve tried all sorts of things from relative and absolute URLs:

    /Image/download.aspx?Entity=account&Attribute=entityimage&Id=d5b8ab69-9e9a-e511-80d5-6c3be5becdb4&Timestamp=635991727111324831

    Vs

    https://[crmonlineurl]/Image/download.aspx?Entity=account&Attribute=entityimage&Id=d5b8ab69-9e9a-e511-80d5-6c3be5becdb4&Timestamp=635991727111324831

    Neither work in an image. If you navigate to the second URL you will indeed get the image. But CRM just refuses to render the report if I point an image at any of the above. Even if I manually type in the above as the image URL it will not render the report.

    Has anyone seen this?

    Or has anyone ever got a byte array returning in a CRM Online SSRS report?

    Additional notes:

    I discovered that CRM does not like distinct=true for entityimage. I still only get the text "System.Byte[]" back as opposed to an actual byte array.

    Wednesday, May 18, 2016 3:21 PM

All replies

  • In case anyone comes across the same problem I couldn't find a solution. So I scrapped the idea of trying to pull the entity image from the record. Instead we used the old fashioned annotations to store the image.

    Really annoying, because we have to save and maintain images in 2 locations within CRM Online. 

    Friday, May 20, 2016 12:12 PM