title: Create a dataset which is a subset of another dataset in SSRS
body: <p>In my SSRS report, I already have a dataset A(by running a SQL script), and parameter P1 use all the records in A. Now I want to get a subset of A, and use another parameter P2 to refer to it.</p>
  
  <p>Is it possible that get the whole and the subset of the dataset at the sametime and only run the script once?</p>
  
  <p>I guess creating a shared dataset is a possible way, but the dataset A is just for locally use and shouldn't be shared.</p>