title: Substitute command for OVER in SSRS
body: <p>How can I implement the OVER() command in SSRS 2008?</p>
  
  <p>Is there a trick to it, or am I stuck?</p>
  
  <p>And if I am indeed not able to use OVER(), then how can I use PARTITION in a SSRS report?</p>
  
  <p>OVER() satisfies my requirements, and Telerian (another member) was very helpful  by pointing it out - but SSRS doesn't seem to be able to use it for reporting.</p>
  
  <p>Every time I use a variant of OVER() or PARTITION in the SSRS SELECT statement, I get rebuffed by the system - any thoughts or work-arounds?</p>
  
  <p>The error message that I was receiving from the 2008 Query Studio was:</p>
  
  <pre><code>The OVER SQL construct or statement is not supported.
  </code></pre>