using paramaters in Rattle
Posted: Wed Oct 29, 2003 7:07 pm
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