Thursday, October 01, 2009 11:32 PM gperera

SSRS Report Show Dynamics CRM Note Attachment

We've had couple of instances where we needed to embed existing image attachments in dynamics crm into sql server reporting services reports. Here are the steps you need to take in order to make it happen. It's pretty straight forward.

  1. Create a new report
  2. Add a new table
  3. Drag an image control onto the table and place it into the column that you want, select 'Database' from the options
  4. Click on the image -> go to the 'Properties' tab -> from the 'Value' dropdownlist select '<Expression...>' and use the following bit of code
    =System.Convert.FromBase64String(Fields!documentbody.Value)
  5. 'documentbody' is the field from the FilteredAnnotation view.

    EXAMPLE



    RESULT


Enjoy!

Filed under: , ,

Comments

# Twitter Trackbacks for SSRS Report Show Dynamics CRM Note Attachment - Kids, don't try this at home! [asp.net] on Topsy.com

Thursday, October 01, 2009 7:05 AM by Twitter Trackbacks for SSRS Report Show Dynamics CRM Note Attachment - Kids, don't try this at home! [asp.net] on Topsy.com

Pingback from  Twitter Trackbacks for                 SSRS Report Show Dynamics CRM Note Attachment - Kids, don't try this at home!         [asp.net]        on Topsy.com

Leave a Comment

(required) 
(required) 
(optional)
(required)