Stored Procedure as Table in End User Designer

rbuser

I am using Delphi 7.01, ReportBuilder 7.04, BDE (not SQL Links), ODBC and
SQL Server 2000.

I would like to have a stored procedure with a date (or more) parameter(s)
return a dataset that can be accessed via the end user designer.

Is this possible? If so, what would it look like?

nicocizik

Hi Isaac,

ReportBuilder does not natively support Stored Procedures in DADE, however
it is possible to implement them using custom dataviews. For RB 10, we
added a new demo that shows how custom dataviews can be implemented to allow
Stored Procs to be used with SQL Server. If you would like to see this demo
in action, you can download a trial edition of RB 10.02 for Delphi 7. There
is also a custom dataview example for your version of RB located in the
\RBuilder\Demos\3. EndUser\2. Custom Data Views\... directory.

--
Regards,

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

rbuser

Thanks Nico.

I'll have to try that when I upgrade.

rbuser

We have done this (using Firebird) just by simply adding a stored proc to
the RB_TABLES table.
Of course we cannot pass parameters but we do not need to for what we are
doing.

We would love to be able to pass params so we shall take a look now at the
solutionoffered by Nico

Cheers

Mark