Stored procedure User inerface

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
SP_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

Stored procedure User inerface

Post by SP_(Guest) » Fri Jan 27, 2006 3:35 pm

__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

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Stored procedure User inerface

Post by kfleming » Fri Jan 27, 2006 7:39 pm

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

SP_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Stored procedure User inerface

Post by SP_(Guest) » Mon Jan 30, 2006 10:29 am

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____

Post Reply