stored procedures

[Gary_(Guest)]

We have purchased an upgrade to RR Infinity and I am evaluating the SQL version. I am trying to desing a report to access a stored procedure that uses a parameter. I want the report to prompt the user to enter a date at runtime and have had no luck in achieving this. The documentation doesn^t seem to cover using stored procedures very deeply and I am running out of ideas. Can anyone shed some light on this?____Thanks,__Gary

[Simon_Bray_(Guest)]

From my experience of using R&R SQL you can not access Stored Procedures or even Views. You can not perform complex joins - namely ones where you link from Table A to Table B and from Table B to Table C but where there are not always any records in Table B for each record in Table A so you would like these to return blanks from both Table B and Table C. ____You could do this with R&R Xbase and you can do this in a SQL statement but you can not do this in R&R SQL. ____It is ashame because I have used R&R for 15 or so years and at the simple things it is really great. It could just do with handling more complex SQL scenarios.

[kfleming]

Views should appear in the table list for an auto SQL report. To use a stored procedure, you need to create a User SQL report and use the syntax:____EXEC PROCNAME____if the procedure has parameters you enter them after the procedure name. To make them replaceable, you surround each one in double angle brackets.____There is an RI_REPLACE field that can be used in a runtime control file to pass values to the stored procedure. But there is not a built in way to prompt the user for these values.____One one you can provide user prompting is to create a front end report and use R&R parameterr fields to prompt the user for the replacement values. You then send the results of this report to a text file that is formatted as R&R input file. You run this report first to create the control text file and then immediately run the report using this control text file as an input.____Let me know if you would like me to send you a more detailed example of this technique.____Kathleen__R&R Support__

[Gary_(Guest)]

Thanks for the replies. Do Liveware plan on supporting prompting the user for parameters at runtime when using stored procedures in a future release?

[Gary_(Guest)]

Please email me a more detailed description of the workaround. My email is gdhigbee@nospamcai-engr.com (Please remove nospam).____Thanks,__Gary