Execute a Dataset based on parameter value -SSRS
<p>I have an <code>SSRS report</code> which have two <code>datasets</code>. One Dataset for showing the Amount of purchase in detail level for All Region Managers &amp; other <code>dataset</code> is for displaying amount of purchase for individual manager. If the user select all managers as input, the report displays data from both <code>datasets</code>. If the user select a single manager, Detail level information will be hidden and <code>data</code> for that manager alone will be displayed ( Handled this by creating <code>visibility</code> expression in <code>dataset</code>). But whenever the report exectuted <code>stored prcoedures</code> for both <code>datasets</code> called. Is it possible to <code>configure the execution</code> of report <code>dataset</code> based on <code>parameter values?</code></p>

<p>for e.g : In <code>dataset1</code> properites I gave below <code>expression</code>,</p>

<pre><code>=iif(Parameters!ManagerID.Value= -1,exec procedure1 ,0)
</code></pre>

<p>But it gave me error. How to make a <code>dataset</code> execute based on a parameter value?</p>