title: Adding values to a Report when there is no Data in query SSRS for both Datasets
body: <p>The intro for this little problem starts here:
  <a href="https://stackoverflow.com/questions/33282098/adding-values-to-a-report-when-there-is-no-data-in-query-ssrs">Adding values to a Report when there is no Data in query SSRS</a></p>
  
  <p>After that:
  <a href="https://stackoverflow.com/questions/33348130/adding-values-to-a-report-when-there-is-no-data-in-query-ssrs-between-datasets">Adding values to a Report when there is no Data in query SSRS Between Datasets</a></p>
  
  <p>Now a basic introduction of what Im trying to accomplish.
  With this expression:</p>
  
  <pre><code>=IIF(IsNothing(Lookup(Trim(Fields!total_Cod_vendedor.Value) &amp; "-" &amp; ReportItems!G2.Value, Fields!AgregarMost.Value, Fields!most_atados.Value, "EfectividadDeFrecuencias_Most")) = True, "0", Lookup(Trim(Fields!total_Cod_vendedor.Value) &amp; "-" &amp; ReportItems!G2.Value, Fields!AgregarMost.Value, Fields!most_atados.Value, "EfectividadDeFrecuencias_Most"))
  </code></pre>
  
  <p>What I'm doing is check if the combination of a <code>Somefield.Value</code>-<code>reportitemName.Value</code> exists on the other <code>Dataset</code> where said content is saved in a calculated field inside that other <code>Dataset</code>. When the <code>IsNothing</code> is <code>true</code>, then put a <code>"0"</code> if not, <code>"Dosomething"</code> which in this case it doesn't matter.</p>
  
  <p>So the idea was to put <code>0</code> each time it doesn't exist that combination for the <code>Dataset</code> Im right now.</p>
  
  <p>Now, the idea is to do the same but when the other <code>Dataset</code> does not have values.</p>
  
  <p>Imagine my tablix have <code>"Dataset"</code> where in a certain <code>Textbox</code> have that expression but at the same time it could be possible that <code>"Dataset"</code> does not have the values that <code>"Dataset1"</code> have. I can't Nest Lookups because I was trying to do the following:</p>
  
  <pre><code>=IIF(IsNothing(Lookup(Trim(Fields!total_Cod_vendedor.Value) &amp; "-" &amp; ReportItems!G1.Value, Fields!AgregarMost.Value, Fields!most_atados.Value, "EfectividadDeFrecuencias_Most")
  AND IsNothing(Lookup(Lookup(Trim(Fields!total_Cod_vendedor.Value) &amp; "-" &amp; ReportItems!G1.Value, Fields!AgregarMost.Value, Fields!most_Cod_vendedor.Value, "EfectividadDeFrecuencias_Most") &amp; "-" &amp; ReportItems!G1.Value, Fields!Agregar.Value, Fields!total_atados.Value, "EfectividadDeFrecuencias_Total")
  )) = True
  
  , "0"
  
  ,Lookup(Trim(Fields!total_Cod_vendedor.Value) &amp; "-" &amp; ReportItems!G1.Value, Fields!AgregarMost.Value, Fields!most_atados.Value, "EfectividadDeFrecuencias_Most"))
  </code></pre>
  
  <p>So to give a more visual example, this was the original Case:
  <a href="https://i.stack.imgur.com/zGpxn.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zGpxn.jpg" alt="enter image description here"></a></p>
  
  <p>See how <code>Dataset2</code> does not have the same values as <code>Dataset1</code> so with this Expression it put 0s where is not Equal that combination (Sales Rep+Category).</p>
  
  <p>Now the idea is to the same thing the other way around, when <code>Dataset2</code> have data that <code>Dataset1</code> does not have IN THE SAME expression (that means the same textbox where it resides the Tablix which at the same time have the Scope on <code>Dataset</code>).</p>
  
  <p>How would you do this?</p>