Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Serge
Starting Member
44 Posts |
 Posted - 2008-03-05 : 06:18:32
|
| Hi,Is it at all possible to pass the whole dataset from SSRS report to custom assembly. So if you have SQL query returning a table with two columns i.e. Name and Age, I can pass the whole column Age to my custom assembly, process it and than return in back to SSRS?Cheers |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-05 : 08:56:16
|
| why do you want it? what processing you're trying to do by means of assembly? |
 |
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-03-05 : 09:06:11
|
| I am working on some data analysis, the data that I get from the database contains anomalities. I need to purify the data before I let SSRS work with it. The SSRS is not capable to do what I need, so what I want is to grub the dataset, put it through some filtering functions and than let SSRS display it.An example would be Kalman filter the dataset. You cant use it on a single value as you need access to previous values. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-05 : 11:11:50
|
| Data cleansing can be done using SSIS too. Try if you can make use of that before you go for assemblies. |
|
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-03-05 : 11:19:03
|
| I have never used SSIS and it will be starting from scratch for me. So its easier if I can use assembly for now. |
|
|
|
|
|
|
Passing Datasets to custom assembly