title: Creating a report with SSRS that iterates over a parameter
body: <p>I am modifying an existing report which is setup to let you view statistics per sales rep. You do this by changing the parameter <code>sales rep</code> in the report view.</p>
  
  <p>I need to modify the report so that it can display a page for each sales rep. This will then be exported to Excel with each sales rep statistics being displayed in a separate tab.</p>
  
  <p>I have researched this and found people talking about iterating over a report but I don't think that what they are referring too is what I am asking:<br>
  <a href="http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/27ffabcc-6286-4fed-a8bf-0e5d78560be3" rel="nofollow">http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/27ffabcc-6286-4fed-a8bf-0e5d78560be3</a><br>
  <a href="http://jameskovacs.com/2005/08/04/digging-deep-into-reporting-services/" rel="nofollow">http://jameskovacs.com/2005/08/04/digging-deep-into-reporting-services/</a></p>