Suman - ad-hoc view and report run fine without the fields I created in the view used as filters. These created fields aren't part of the domain, correct? What would be the corruption in the domain that might cause this, then? And, why does it work in the view, but not the report?
In meantime, I've come up with a solution, by simplifying my ad-hoc filtering, which must simplify the resulting query.
Rather than converting Impact and Probability to numbers using two fields, multiplying the two fields in a third field and using this third field as a filter, I just do it all in one field:
New Risk Score = CASE("Risk Probability", 'High', 3, "Risk Probability", 2, 3) * Case("Risk Impact", 'High', 3, "Risk Probability", 2, 3)
Then filter on >=6.
Must be simpler. Works both in ad-hoc view and in report. Happy-happy!
In final version of report, would like to convert numeric "New Risk Score" back to text so that users can pick from simpler "High, Medium, Low" value list rather than remembering the numeric thresholds corresponding to each text value. Will try wrapping above formula in another CASE statement in order to keep it all in one field.
But this is good enough for now.
Thanks for the feedback - helps get ideas flowing.
Dale