Riparam

[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

[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

[Duncan_(Guest)]

I am using version 10. I^ll take a look at paramters. Thanks