Sql Store Procedures

rbuser

How use store procedures (sql server 2000) in a report end-user ??

thanks

Pd. excuse my english

nicocizik

Hi Juan,

Reportbuilder does not natively support stored procedures with DADE however
it is possible to create a custom dataview that allows them to be used.
Take a look at the demo located in the \RBuilder\Demos\4. EndUser
Databases\SQL Server\2. ADO\StoredProc\... directory for an example of using
stored procedures with SQL Server and ADO.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks Nico

But

I dont have this directory : \RBuilder\Demos\4. EndUser Databases\SQL
Server\2. ADO\StoredProc\

I use the Report Builder Enterprise 7.03

Do you have this sample ???

Thanks for all

nicocizik

Hi Juan,

Unfortunately we do not have this example available for RB 7.x. You could
possibly download a trial edition of RB 10.06 to see the example and code.
Another option would be to take a look at the Custom Dataviews example
located in the \RBuilder\Demos\3. EndUser\2. Custom Data Views\...
directory. The Stored Procedures example follows the same idea of creating
a custom dataview that interacts with Stored Procedures using the Autosearch
dialog to do so.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com