Running report builder stored procedure

rbuser

Gentlemen

I'm using RB7. Is there any way to use a stored procedure in the Report
Builder End User runtime designer?

I have some stored procedures that I need to pass some parameters and it
returns a dataset that is like a query. At Report Designer, it only shows
real tables and views in the "Tables" pane.

Thanks

Marcos Lima



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Marcos,

ReportBuilder does not natively support the use of stored procedures for the
end-user environment, however it is possible to manually implement them
using custom dataviews. There is an example of creating and using custom
dataviews located in the \RBuilder\Demos\3. EndUser\2. Custom Data Views\...
directory. Also, due to popular demand, we included a Stored Procedure demo
for SQL Server and ADO in the latest version of ReportBuilder (10.02). This
demo makes use of custom dataviews for use with stored procedures. Note
that this demo will only work with the new archetecture of RB 10.

--
Regards,

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