title: SQL Server - Image Expression
body: <p>Using SSRS.</p>
  
  <p>I have created a car park map with set locations, each car park will have a different vehicle parked in said location. I want to create an expression to add to the image for each park to identify what is parked there and based on the column data display a different image.</p>
  
  <p>For example:</p>
  
  <pre><code>=CASE
  WHEN ParkingSpot = x AND NumberPlate = Y THEN "IMAGE OF THAT CAR.JPG"
  </code></pre>
  
  <p>I've tried a few different variations of the above but I've had no luck. If there is a better way of doing this be querying for the car's current location and creating a variable etc please let me know.</p>
  
  <p>I've tried a switch but I need more information.</p>
  
  <pre><code>=CASE
  WHEN ParkingSpot = x AND NumberPlate = Y THEN "IMAGE OF THAT CAR.JPG"
  </code></pre>
  
  <p>So in short what I'm trying to achieve is for each parking bay to show a picture of which car is there depending on the location/plate values.</p>
  
  <pre><code>If ParkingSpot = 4A AND NumberPlate = XXX-XXX THEN "Display Car Image"
  </code></pre>