hi everyone again, i have a doubt with Active Report and Store Procedures. i never used Store Procedure, and im looked this line in the reports
ProcedureCall (String, Name of SQL StoredProcedure to run. "" if none.)
anybody know how to use SP en this reports? thanks again
That's not a stored procedure, it's an internal function in RMS, and I don't know of anyway to access it other than in the report it was intended for.
If you need to run a stored proc as part of a report, you can use the PreQuery1 & PreQuery2 entries. Use this syntax: EXEC spName param1 param2
I think that's the correct syntax, you might need () or commas...
Generally, I would expect that running a stored proc in a report would not be a very good solution...
Glenn Adams Tiber Creek C> hi everyone again, i have a doubt with Active Report and Store Procedures.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required