Can I pre-process the data before transferring it to SSRS 2005?

Question

We are considering moving to Sql Server 2005 Reporting Services. Many of our existing reports require data pre-processing before rendering.

For example, we have a query for a report that returns GPS coordinates (latitude and longitude) from a stored procedure, but before passing the DataSet to our reporting engine (currently Crystal), we call the web service to geocode the coordinates back and get address bar. We insert this into the object DataSet.

I read a little about data processing extensions , but I'm not sure what I want, then (if I understand correctly) I would need to implement the entire processing flow (including extracting data from a stored procedure) in order to massage it a bit at the end.

How can I insert and pre-process a dataset after retrieving from a data source, but before passing it to the visualizer?

Answer 1

You can create a .NET assembly using a method that processes a single record. Then include this assembly in the report and call this method when each row is rendered. This would do the processing and display of the result.

, , :

= Code.ReverseGeocode(, , , )

. http://msdn.microsoft.com/en-us/library/ms155798.aspx .

Answer 2

SSIS ( ).

, , : - .

, , EII

Answer 3

- ReportViewer .

ASP-NET, , .

, SSRS /​​DLL, , ( = Code.ReverseGeocode). RBAR .

Answer 4

, , SQl, , . where . proc .