ParameteRR field in Report filters

[Neeraj_Kamat_(Guest)]

Hi!____I am using a ParameteRR field to accept input from the user. I use this field in the Filter via a calculated field RR(ParameteRR_field). The Report Writer doesn^t use this field while executing the query on the database, but applies the filter once the ENTIRE data has been returned to the report. This is killing the report execution time. Does anybody know how to force R&R to use the ParameteRR field while executing the query on the database?____If not, does anybody know how to request user input in a "User SQL Report" without tampering with the database itself?____Please advise.... __Regards,__NK

[MarvinBoorm]

Neeraj,____If you can launch the runtime module with parameters [ie "DOS" parameters] then you should be able to use a control [text] file or a control table. I use a control table [SQL table within the database] which has one line per report and will accept up to 15 runtime parameters [could go higher if needed]. I launch a form and it asks users if they want to change any of the defaults [date range, details to print etc] which it writes back into the table. The form also launches the R&R Runtime module. The data is retrieved via RIPARAM().____For a simpler [but less flexible?] method, have a look at this really excellent explanation from the Hammerman site:__http://www.hammerapps.com/techtips/techtipsasp/techtipsdynamic.asp?TTID=50__There is plenty of extra info in the Runtime help file on the R&R CD.____Also you could look at Topic #1133 in this forum.____BTW thanks heaps for posting the tip about using the RR() function to make filters work with ParameteRRs in Topic #1056 - ironically that is the very thing that causes your problem - but at least changing the ParameteRR(s) now works for me!