Liveware Publishing Support Forum

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

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.

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__

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

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