title: Adding values to a Report when there is no Data in query SSRS
body: <p>I have a query that returns Sales representatives number, Category, Sales.</p>
  
  <p>The result is something like this:</p>
  
  <p><a href="https://i.stack.imgur.com/6KfZ7.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6KfZ7.jpg" alt="enter image description here"></a></p>
  
  <p>There are 4 categories called <code>G1,G2,G3,G4</code>.</p>
  
  <p>As you can see the Sales representative <code>11</code> sold 10 each category (Yellow rows).
  But Representative <code>12</code> sold only for category <code>G3</code> and <code>G4</code>.</p>
  
  <p>The idea is to show in the report all the categories and populate with 0 all those who did not sell on that particular category.</p>
  
  <p>It must be grouped by Sales Representative so if you make a tablix grouping by Sales Representatives you will have something like this:</p>
  
  <p><a href="https://i.stack.imgur.com/fOLit.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fOLit.jpg" alt="enter image description here"></a></p>
  
  <p><strong>But you want something like this:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/np5Z1.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/np5Z1.jpg" alt="enter image description here"></a></p>
  
  <p>Is there any expression I could use to add these?</p>
  
  <p>What I did so far is to create a group, that group of course are my Sales representatives and combine the cells for that Column and created a Row group for each category, is something like this:</p>
  
  <p><a href="https://i.stack.imgur.com/ZRQFk.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZRQFk.jpg" alt="enter image description here"></a></p>
  
  <p>But if you execute that report it will repeat all categories G1,G2... For each time that category exists for that particular Sales Representative.</p>
  
  <p>Another problem is, how can you evaluate The hardcoded category in your report if it does not exist in your datasource you cant make <code>Iif("G1" = Fields!Category.Value,Fields!Sales.Value,"0")</code> as you are not comparing <code>G1</code> with <code>Null</code> or <code>IsNothing</code>, you are comparing what it exists.</p>