Page 1 of 1

using paramaters in Rattle

Posted: Wed Oct 29, 2003 7:07 pm
by cni_richard
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

Posted: Wed Nov 12, 2003 9:26 am
by kfleming
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