Hi,
We have a requirement where filter condition in the report needs to be enabled only when a particular set of fields are selected in the report.
for example:
if I select fields COUNTRY and MODEL(other fields can be selected) from car then a filter say "WHERE COUNTRY EQ 'ENGLAND'" is enabled else no filter condition in the report.

Any ideas,please suggest.
Thanks

This message has been edited. Last edited by: <Kathryn Henning>,

Hello,

A possible solution here may be to use SET command - ONFIELD=ALL (the default) or IGNORE (only applied if sortfield is used in report). You can find more information here: Ignoring ON Phrases for Absent Fields

You can also use Database Administration (DBA) to restrict a fields value (using IF or WHERE).

If you need help with any of these suggestions, please contact customer support at 1-800-736-6130.

Thanks VLozovsky,
I will look into your suggestion and open the case with IBI if required.