title: SSRS conditional execution of dataset
body: <p>I have two different datasets in SSRS report which gives different number of output fields.I have used this two data set into two different tables in report.</p>
  
  <p>1) One table will display output at a time in execution based on condition.</p>
  
  <p>Actually  while running the report two datasets are executing the SP and it takes more time to display the output.</p>
  
  <p>Requirement:
  I need to execute the one dataset SP at time based on condition.Other Dataset SP should not Execute.</p>
  
  <p>Example:
  Dataset1 executes Sp1
  Dataset2 executes Sp2</p>
  
  <p>Table1 uses Sp1
  Table2 uses Sp2</p>
  
  <p>Normally while executing report Table1 will display output(Based on default parameter selection)</p>
  
  <p>But SP1 and SP2 are executing on same time.so report takes more time to display output.</p>
  
  <p>I need to execute 1 SP at a time based on condition.so that other dataset SP will not execute.</p>