A little background...

I've got data in a database in which users have a
serviceplan of sorts... and basically changes are
journaled. So in order to determine which serviceplan they
are on, you just about have to loop through all the
records for that user up until x date, and that'll be the
rate plan they were on at that period of time.


Anyway, my question is, I need to be able to aggregate
data etc, in that manner, and for x month, I'd like to get
all the users... and which service plan they were on.

With the custom assembly stuff, can I chug through the
data before passing the end result data to reporting
services for tidying up, and presentation?

I know its a sort of vague question. I am just hoping
somone here's done somethng similar.

Yes. This is pretty strait forward with either a stored procedure on the
database side, or a custom Data Processing Extension. If you go the DPE
route, you basically implement several interfaces, one of which is the
IDataReader. You can do your initial query in a private method of your
DataReader and then preprocess it however you wish before exposing the final
result via the IDataReader interface. There are several examples of custom
DPE on this discussion group and on msdn.

One nice thing about a DPE is you have full use of the .net framework, which
is a plus if you are not keen with stored procedures.

One thing to be aware of is there are some initial setup things for
permissions when deploying your DPE that can trip you up at first, but once
you get the hang of things, it is a breeze.

Cheers, David

[quoted text, click to view]