Using Stored Procedures as Tables

rbuser

In Interbase it is possible to select a stored procedure and use it as a
table. Is there any way to use a stored procedure in report builder without
having to create a pipeline?

digitalmetaphors

You always need a datapipeline:) Are you using DADE? DADE dataviews don't
natively support stored procs. You would have to create your own custom
dataview template to handle them, or enter it in the SQL text tab of the
Query Designer. You can write any SQL that you want into a DADE dataview
(SQL tab). RB validates it by submitting it to the server. The query tools
become disabled once you save edited SQL text.

If you are using components on a form, then you should be able to use a
TStoredProc component to connect up:

StoredProc -> Datasource -> Datapipeline -> Report


Cheers,

Jim Bennett
Digital Metaphors