title: creation of multiple dataset in Reporting service report
body: <p>I have a SSRS report and  using PL/SQL for the dataset creation.
  My report needs two tables 
  1 one gives detailed view.(dataset 1)
  2 one below that gives a summary table (data should come from the calculations based on the data in 1 table) </p>
  
  <p>I am using a temporary table for the dataset one. </p>
  
  <p>What are the methods  to get calculated result for dataset 2.</p>
  
  <p>I wrote 2 procedures for each.
  since first table is a temporary one i am not getting result for second dataset.</p>
  
  <p>Why can be the options.</p>
  
  <p>Can I have multiple dataset out of single procedure?</p>