Page 1 of 1
Stored procedure User inerface
Posted: Fri Jan 27, 2006 3:35 pm
by SP_(Guest)
__Hi, ____I create a Report with exeuation stored procedure with a couple of parameters, but every single time I want change the parameter,I need manualy modify SQL Statement, Could you tell me if R&R Report has user friendly interface like ParameterRRfields for Stored procedure, every time I will update by __like ParameterRRfields not maually change SQL statement.______thanks____John
=> RE: Stored procedure User inerface
Posted: Fri Jan 27, 2006 7:39 pm
by kfleming
What you would need to do is to surround the parts of the procedure you wish to modify in double brackets and then use a runtime control table to pass the value via an RI_REPLACE.____Kathleen__R&R Support
==> RE: Stored procedure User inerface
Posted: Mon Jan 30, 2006 10:29 am
by SP_(Guest)
Hi, ____When user develop application program with the Control Tables, Does R&R__report desinger can use control table itself without application program? That means I can only modify the control table instead of modification of the double brackets of stored procedure sql statements. ______Thanks____