title: Reporting Services dynamic image source URL problems
body: <p>I have a report in SQL Reporting Services 2008 R2 that includes an image whose source is given by an expression.  The image won't render though.  This report was moved from a 2005 machine where it works just fine.</p>
  
  <p>The image source is set to:</p>
  
  <p>="http://example.com/SiteMap/Directory/EmployeePhotos/" + rtrim(Fields!employee_id.Value) + ".jpg"</p>
  
  <p>Which should render out to this source in the actual report:</p>
  
  <p><a href="http://example.com/SiteMap/Directory/EmployeePhotos/275.jpg" rel="nofollow">http://example.com/SiteMap/Directory/EmployeePhotos/275.jpg</a></p>
  
  <p>Instead I just get an empty image spacer; when I look at the properties in IE I get a bunch of "Not Available" values.</p>
  
  <p>I set up a row in my report with the exact expression above and it gives the expected value.</p>
  
  <p>Again, the image works just fine on the 2005 box and it looks fine when it's rendered in VS 2010.  Any ideas?  Thanks as always for your help.</p>