Page 1 of 1
Riparam
Posted: Fri Aug 29, 2008 10:21 am
by Duncan_(Guest)
Hi____I have a report which uses 2 riparam fields in its filter. I launch the report using an rss file, and this also contains the prompts for the riparams. This report takes 45mins to return data. However if I open the report and hard code the filters it returns in less than a minute. ____Why the huge difference?____any help welcome____Thanks ____Duncan
=> RE: Riparam
Posted: Tue Sep 02, 2008 10:27 am
by kfleming
Any filter condition that uses RIPARAM will be evaluated locally rather than being sent as part of the SELECT statement.____What version of R&R are you using? Later versions support parameterr fields which will be sent as part of the SELECT when used in a filter.____Kathleen__R&R Support
==> RE: Riparam
Posted: Wed Sep 03, 2008 4:47 pm
by Duncan_(Guest)
I am using version 10. I^ll take a look at paramters. Thanks