Referencing input parameters for SQL in report

rbuser

Hi, I have a report that is saved in a database via its template. The data
is coming from a stored procedure with an SQL statement that calls it from
my ibQuery object. I would like to list the input parameters that were
passed to this stored procedure on my report. I know I can do this by
having my stored procedure return the input parameters back to me, but it
seems that there should be another way to do this. And of course this needs
to be done in RAP.

If I have not explained this situation well enough, just let me know as this
is all still new to me.

TIA,
Carolyn

digitalmetaphors

Do you mean autosearch? Then call Report.GetAutosearchDescriptionLines,
passing a TppMemo.Lines object. See the autosearch demos for an example of
this.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

No we are not using autosearch. We have an ISAPI program that is sending
the report request to web tier via a URL (and passing the parameters through
the URL string). I am hoping there is a way to interpret what the stored
procedure parameters are via RAP without having to essentially echo them
back as output fields in the stored procedure.

Thanks,
Carolyn

digitalmetaphors

You'll have to create a RAP pass through function in order to access the
parameters that you set on the stored proc. There are examples of creating
RAP pass through funciton in the RAP tutorials and demo in the RBuilder
installation.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Not exactly what I was hoping to hear, but at least it can be done. I'll
tackle that new learning experience next week with a fresh brain (if I can
find one ).

Expect more questions then.

Thanks,
Carolyn