using paramaters in Rattle

Over the years we've worked with or supplied a variety of utilities. As questions about RattleRR, RapidRunner, PDFeXPLODE, pdfEburst, converter, librarian, data dictionary, Amyuni, etc.
Post Reply
cni_richard
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

using paramaters in Rattle

Post by cni_richard » 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

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

=> RE: using paramaters in Rattle

Post by kfleming » Wed Nov 12, 2003 9:26 am

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

Post Reply