title: Can I pre-process data before passing it off to SSRS 2005?
body: <p>We are considering migrating to Sql Server 2005 Reporting Services. Many of our existing reports require pre-processing of the data before rendering it.</p>
  
  <p>For example, we have a query for a report that returns GPS coordinates (Latitude and Longitude) from a stored procedure, but before passing off the DataSet to our reporting engine (currently Crystal) we call out to a Web Service to reverse geocode the coordinates and get an address string. We push this into the <code>DataSet</code> object.</p>
  
  <p>I've read a bit about <a href="http://msdn.microsoft.com/en-us/library/ms152816.aspx" rel="nofollow noreferrer">Data Processing extensions</a> but I'm not sure that's what I want, as then (if I understand correctly) I would need to implement the <em>entire</em> processing flow (including retrieving the data from the stored proc) just to massage it a bit at the end.</p>
  
  <p>How can I interject and pre-process the dataset after retrieving it from the data source, but before passing it on to the renderer?</p>