title: Should I use stored procedures for reports in SQL Reporting Services
body: <p>When I write report for SQL Reporting Services I put SQL-script inside my report (rdl). When I run this script in SQL Management Studio it takes about 1 second, but report are generated very long time (Sometimes report throws exception about timeout).</p>
  
  <p>Should I write stored procedure and use it in report? Will it be faster? </p>
  
  <p>And one more question - When SQL-script returns a lot of rows, does report get all rows and show only one page, or it takes only one page from SQL-server?</p>
  
  <p>Thanks in advance.</p>