Oracle Stored Procedure for RDLC Dataset

Is it possible to use an Oracle Stored Procedure for an RDLC report. There are posts I've read that deal with RDL reports that use the data tab and command type of "Stored Procedure", but I don't have that installed. I just create a new dataset that the report uses. I can do reports just fine with SQL statements, but I want to be able to call a stored procedure...

Thanks

Another post that seeks to answer this question is at

http://www.codenewsgroups.net/group/microsoft.public.dotnet.framework.aspnet.webcontrols/topic6588.aspx

"Hi, i have used rdlc with the informix database. What is did was add a empty
dataset to the rdlc and i have a business layer (a vb class) which has a
function which returns a dataset. When you add a report to the page add an
objectdatasource and specify the type as the vb class and the select method
as the funtion. This works for me. "

Is this the only way to accomplish this? Does someone have the definitive answer of "No, an

Oracle Stored Procedure cannot be called by a setting in the dataset wizard for a client-side (RDLC) report."

Also, here is a post that deals with just the RDL report:

http://www.developer.com/db/article.php/3524781

Oracle and SQL query in one rdl

I am currently creating a query wherein all of the records returned
from an SQL Server table will have to be queried against an Oracle
database. The following algorithm describes how I intend to do the
report:
* Get the start and end dates (report parameters)
* Run the following SQL Server query:
select ID from SQL_server_table
where logtime >= startdate
and logtime <= enddate
* For each ID returned from the SQL server table
* Query the Oracle datebase
select info1, info2 from Oracle_table
where id = ID_from_SQL_server
* Report on the SQL_Server.ID, Oracle_info1, Oracle_info2
How should I do that in an SRS?
Thank you so much in advance!Read up on subreports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<joychua97@.gmail.com> wrote in message
news:1143818223.627860.28200@.i39g2000cwa.googlegroups.com...
>I am currently creating a query wherein all of the records returned
> from an SQL Server table will have to be queried against an Oracle
> database. The following algorithm describes how I intend to do the
> report:
> * Get the start and end dates (report parameters)
> * Run the following SQL Server query:
> select ID from SQL_server_table
> where logtime >= startdate
> and logtime <= enddate
> * For each ID returned from the SQL server table
> * Query the Oracle datebase
> select info1, info2 from Oracle_table
> where id = ID_from_SQL_server
> * Report on the SQL_Server.ID, Oracle_info1, Oracle_info2
> How should I do that in an SRS?
> Thank you so much in advance!
>