using a stored procedure

rbuser

I want to use a stored procedure to populate a report. Not sure if this is
the right place to ask. I am using D5 with SQLServer 2000.

I am unclear as to how to get a dataset from a stored proc and how to hook
that to the report.

Thanks for any help.

Matthew.

nicocizik

Hi Matthew,

Are you using DADE? DADE dataviews don't natively support stored procs.
You would need 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. However, the query tools become disabled once
you save edited SQL text.

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

StoredProc -> Datasource -> Datapipeline -> Report

--
Regards,

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

rbuser

Nico,

Thanks, it works fine.

Matthew