Data Source For Report Model Project

When I tried to generate ad-hoc reports with Microsoft reporting services
2005 (april CTP), it generally ask for the tables and views. Is there a way
that I can just put in a stored procedure and use the results as a data
feeder for the report model? Thanks.I don't think this is supported out of the box
You can however create a named query as part of the data source view
"Geek" wrote:
> When I tried to generate ad-hoc reports with Microsoft reporting services
> 2005 (april CTP), it generally ask for the tables and views. Is there a way
> that I can just put in a stored procedure and use the results as a data
> feeder for the report model? Thanks.sql

Data Source access

Hi All,
I'm looking to create an ad-hoc query generator so that I can create a
report on the fly, but I would like to use RS Shared Data Sources for this.
I have run into a problem though, in that I can't retrieve the password for
the Shared Data Source. Is there any way to get the Data Source back as a
connection to the database in ADO?
Thanks in advacne,
CathieNo you cannot get the data source back as connection. But you could try to
implement a custom RS data extension and use it then in the shared data
source.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cathie" <cathie@.somewhere.com> wrote in message
news:eqY8s64SFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Hi All,
> I'm looking to create an ad-hoc query generator so that I can create a
> report on the fly, but I would like to use RS Shared Data Sources for
> this. I have run into a problem though, in that I can't retrieve the
> password for the Shared Data Source. Is there any way to get the Data
> Source back as a connection to the database in ADO?
> Thanks in advacne,
> Cathie
>|||Hi Robert,
I'm sorry I don't understand how a custom RS data extension would help me.
I am want to be able to get any datasource's (within RS) tables, views,
stored procedures etc. How would a custom RS data extension help?
Cathie
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OIBjdIgTFHA.1404@.TK2MSFTNGP09.phx.gbl...
> No you cannot get the data source back as connection. But you could try to
> implement a custom RS data extension and use it then in the shared data
> source.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Cathie" <cathie@.somewhere.com> wrote in message
> news:eqY8s64SFHA.2128@.TK2MSFTNGP14.phx.gbl...
>> Hi All,
>> I'm looking to create an ad-hoc query generator so that I can create a
>> report on the fly, but I would like to use RS Shared Data Sources for
>> this. I have run into a problem though, in that I can't retrieve the
>> password for the Shared Data Source. Is there any way to get the Data
>> Source back as a connection to the database in ADO?
>> Thanks in advacne,
>> Cathie
>|||If you go through a custom data extension, you would need to implement our
IDBConnection etc. interfaces. Hence, in the custom data extension you would
see the actual connection string etc. used to connect to the data source.
You could use this information to do then some adhoc query generation. What
I'm basically saying is that you cannot easily do the adhoc query generation
from within the report in RS 2000.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cathie" <cathie@.somewhere.com> wrote in message
news:e5GQ9F4TFHA.2712@.TK2MSFTNGP09.phx.gbl...
> Hi Robert,
> I'm sorry I don't understand how a custom RS data extension would help me.
> I am want to be able to get any datasource's (within RS) tables, views,
> stored procedures etc. How would a custom RS data extension help?
> Cathie
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:OIBjdIgTFHA.1404@.TK2MSFTNGP09.phx.gbl...
>> No you cannot get the data source back as connection. But you could try
>> to implement a custom RS data extension and use it then in the shared
>> data source.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Cathie" <cathie@.somewhere.com> wrote in message
>> news:eqY8s64SFHA.2128@.TK2MSFTNGP14.phx.gbl...
>> Hi All,
>> I'm looking to create an ad-hoc query generator so that I can create a
>> report on the fly, but I would like to use RS Shared Data Sources for
>> this. I have run into a problem though, in that I can't retrieve the
>> password for the Shared Data Source. Is there any way to get the Data
>> Source back as a connection to the database in ADO?
>> Thanks in advacne,
>> Cathie
>>
>