How to populate a Tablix referencing data from another Tablix dataset?
<p>I have two <code>Tablix</code>: <strong>Tablix A</strong> and <strong>Tablix B</strong>:</p>

<p>Each <code>Tablix</code> is connected to different <code>datasets</code> as illustrated in the image below:</p>

<p>How do I populate Tablix B by looking up data in Tablix A?</p>

<p>For example: Tablix A contains Vehicle models but I also need to populate Tablix B with Vehicle colors using the VehicleID in both dataset.</p>

<p>Using a <code>Lookup Function</code>, this only works if both datasets are references in the same tablix, how do I do this using separate tablix?</p>

<p>Attempting to use separate tablix, I get the below error:</p>

<pre><code>[rsFieldReference] The Value expression for the text box 
‘Textbox57’ refers to the field ‘VehicleColor’.  

Report item expressions can only refer to fields within the current dataset scope or, 
if inside an aggregate, the specified dataset scope. 
Letters in the names of fields must use the correct case.
</code></pre>

<p>Illustration:</p>

<p><a href="https://i.stack.imgur.com/4pUcD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4pUcD.png" alt="enter image description here"></a></p>