all groups > sql server reporting services > july 2006 >
You're in the

sql server reporting services

group:

Using a custom dll to create a dataset


Using a custom dll to create a dataset Michael
7/28/2006 2:39:01 PM
sql server reporting services: In the RS data tab, one can create a dataset using text or stored procedure.
I've also noticed there is an expression editor option available next to the
query string box. Is it possible to call a custom dll that is already
referenced by the report to return a dataset to the report? Essentially this
custom dll will poll a database and return a dataset type. Anyone ever used
the expression editor in this fashion?



Thanks in advance!
Re: Using a custom dll to create a dataset Michael
8/3/2006 3:03:03 PM
Thanks for the response Jon. That's what I thought I would have to do.
Seemed too easy to just call a custom expression to return a DS.

Thanks again!

[quoted text, click to view]
Re: Using a custom dll to create a dataset <Jon Meyer>
8/3/2006 4:58:09 PM
Michael,

I think what you want is a Custom Data Processing Extensions....

I would start reading about this here

http://msdn2.microsoft.com/en-us/library/ms152934.aspx

You should be able to create an extensions which will create a dataset which
will be read by the Report after processing has completed. Follow the
steps in the Implementing a Data Processing Extension. If you have further
questions about the details of implementing this solution please let me know
here and I'll do my best to answer.

Regards,

-Jon

[quoted text, click to view]

AddThis Social Bookmark Button