Stored procedure User inerface
-
- Posts: 2
- Joined: Tue Oct 10, 2017 12:44 pm
Stored procedure User inerface
__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
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
-
- Posts: 2
- Joined: Tue Oct 10, 2017 12:44 pm
==> RE: Stored procedure User inerface
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____