We currently have a push-model architecture with Crystal in which we simply push an ADO.NET DataSet object to Crystal. Crystal then binds that data to the report (i.e. rpt file) , then we render the report.

For example,
report.SetDataSource(myAdoDataSet);

However, I can not seem to find a way to do this in Sql Reporting Services, is this possible ?

People have already told me to just use a data processing extension (dpe), but that doesn't solve the problem, b/c I need to dynamically (programatically) pass parameters to the report, using my newly created dpe. However, my dpe needs parameters, and they need to be more than just strings. I have params that are ArrayList, Hashtables, etc. I can't figure out how to pass objects like the aforementioned to my report ?

Any suggestions would be greatly appreciated.

-------------------
C# Enthusiast

Passing a dataset will be supported in the report controls that will ship in
Visual Studio 2005.

In the meantime, you could always send the structure as a string containing
XML and then parse it out in your DPE.

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]
simply push an ADO.NET DataSet object to Crystal. Crystal then binds that
data to the report (i.e. rpt file) , then we render the report.
[quoted text, click to view]
but that doesn't solve the problem, b/c I need to dynamically
(programatically) pass parameters to the report, using my newly created dpe.
However, my dpe needs parameters, and they need to be more than just
strings. I have params that are ArrayList, Hashtables, etc. I can't figure
out how to pass objects like the aforementioned to my report ?
[quoted text, click to view]

you can't use the query pane to send parameters to your DPE?
the sample DPE provided by Microsoft use this query pane to send a target
folder to the DPE.

the "CommandText" property of the IDbCommand interface is used to send the
query statement to the DPE.
This text can be anything you want. (for example XML tags, simple value,
coma separated values...)

"RBisch" <RBisch@community.nospam> a écrit dans le message de
news:20D5D19E-1380-4991-ABAA-A7809C89C0E3@microsoft.com...
[quoted text, click to view]
simply push an ADO.NET DataSet object to Crystal. Crystal then binds that
data to the report (i.e. rpt file) , then we render the report.
[quoted text, click to view]
but that doesn't solve the problem, b/c I need to dynamically
(programatically) pass parameters to the report, using my newly created dpe.
However, my dpe needs parameters, and they need to be more than just
strings. I have params that are ArrayList, Hashtables, etc. I can't figure
out how to pass objects like the aforementioned to my report ?
[quoted text, click to view]