Call SQL stored procedure from within Report Designer

rbuser

Hi,

I would like to be able to call a SQL stored procedure from an event runtime
within the report without having to code a Delphi wrapper program.

What would be realy great were the possibility of adding buttons to a report
and calling i.e. SQL procedures from those events. :-)

Regards
Hans

rbuser

I realized that I forgot to put a question in her:

Is it possible, how can it be done and do you concider adding design buttons
to report designer?

Regards
Hans


"Hans Christian Stadtler" skrev i melding

nicocizik

Hi Hans,

There is no built-in way to call a stored procedure from ReportBuilder
however this is something we have on our to-do list for a future release.

Currently it is possible to leverage the AutoSearch feature to give your
users the ability to execute stored procedures from within ReportBuilder.
It is necessary however to create a custom dataview for each one. An
example of this can be found in the \Demos\4. EndUser Databases\SQL
Server\2. ADO\StoredProc\... directory.

This demo shows how to create stored proc custom dataviews to be used with
SQL Server and ADO however the concepts are the same if you were to create
them for another DB or connection object.

--
Regards,

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

rbuser

Thanks Nico,

this would be great stuff for release 11.5 ;-)

Thanks for your information!

Hans