using paramaters in Rattle
-
- Posts: 1
- Joined: Tue Oct 10, 2017 12:44 pm
using paramaters in Rattle
I can get report writer (v 10 ) to pass variable information to a stored procedure in MS-SQL using the following user-sql sql statement____declare @rgt int exec @rgt = rg_test_01 @owner = ^CRM^, @bdate = ^03/01/2001^, @edate = ^10/27/2003^____My problem is that this is only a test. For the finished reports I will need to allow the user to specify the @owner, @bdate, and @edate.____Is there a method in Rattle that would allow user provided values to be inserted into the sql statement?____Thanks____Richard
=> RE: using paramaters in Rattle
The RI_REPLACE that is available in the core product and is what you would need here has not yet been implemented in the RattleRR product.____Kathleen__R&R Support