title: How to display an image from a SQL query that gives a file path in SSRS Report?
body: <p>I am working on a report, which I would like to display an image in my database from a query with a parameter. For example:</p>
  
  <pre><code>SELECT pictureATTACHMENT
  FROM   myDatabase.dbo.ATTACHMENT
  WHERE  DESCRIPTION LIKE @thisCampaign + '%'
  </code></pre>
  
  <p>My query returns a file path to the image:
  For example:</p>
  
  <pre><code>\\DASERVER\FOLDER\FOLDER\Data\Attachment\filename.png
  </code></pre>
  
  <p>How do I need to format the expression for the report to display the image?</p>
  
  <p>I have tried doing: <code>=file:\\DASERVER\FOLDER\FOLDER\Data\Attachment\filename.png</code></p>
  
  <p>But no luck.</p>
  
  <p>Many thanks in advance!!</p>