Possible to Loop thru dataset using Custom Code?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sorcerdon - 29 Dec 2005 16:49 GMT

Is there a way to pass a record set into a function of custom code?
If so?
What datatype should I use?
I have been told its impossible to loop thru the dataset...

Can you get the INDEX of the First row and the INDEX of the last row as
a parameter into a custom function?

regards,

Stas K.

Reply to this Message

Potter - 29 Dec 2005 18:10 GMT

Mr. Sorcerdon,

Your best bet would be to implement a Custom Data Processing extension.

This will give you access to dataset being consumed by the report.

Specifically, the IDataReader has a Read method which walks the
dataset.

Andy Potter

Reply to this Message

Sorcerdon - 30 Dec 2005 16:25 GMT

I dont you to go too deep into it, but basically make an Object as a
parameter and then read that object using this extension?
Is there a place where I can get code for this Custom Data Proccessing
extension?

Reply to this Message

Potter - 30 Dec 2005 17:43 GMT

It is a class library that sits between your data source and your
report's dataset. It implements interfaces from MSRS.

Here's the MSDN article about a Custom Data Processing Extension.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_
prog_extend_dataproc_5c2q.asp

There are several good samples out there. Teo Lachev has a good one
that a google search will return.

Andy Potter

Reply to this Message