Avoid records with status 'XYZ'

peraka

Hi, We have 100+ reports. I would like to exclude data coming from external interface with the status='xyz'. Now I cannot modify 100+ reports to add this condition.

Is there anyway to place this condition in any of the configuration files. All reports belong to same folder i.e.workorder. Folder level will I be able give this condition & exlude these unwanted records. Please let me know.

Thanks,
Suresh.

johnw

Not unless you used the same data set and stored it in a library, or wanted to replace the schema alias for the table with a view that filtered based on that condition.

Its not hard to write an external program to go through the report designs, modify the data set queries to add a filter condition or modify the where clause.