SYMPTOM:
In Strategy 9.x, when the Administrator views a freeform SQL report in design view, the view filter definition appears correctly.
However, when logging in as a different user and editing the report, the "ID" field in the filter is cleared out and defaulted to "Field". The user will not be able to run the report unless the "Field" is changed back to "ID".
CAUSE:
This is a known issue in Strategy 9.x.
ACTION
Contact Strategy Technical Support for an update on this issue.
One workaround is to manually fill in the field prior to report execution. Alternatively, run the report without going into edit mode and alter the filter within grid view.
