AnsweredAssumed Answered

Working with text results and "set field"

Question asked by nickodm on Feb 8, 2011
Latest reply on Feb 8, 2011 by philmodjunk

Title

Working with text results and "set field"

Post

OK, here's my complete situation.

We have a report that is used to show each department their pending service request. We have the status of "Pending" or "Resolved" so the report was simply using this:

Set Field [Services::Status; "Pending"]

This would get the results with no problem. Yet someone decided to add another status: "Work in Progress" 

So now I'm in a pickle. Either I have to find a way to select "Pending" AND "Work in Progress" or I have to find a way to select all and exclude "Resolved".

Thoughts? I appreciate your help with this.

Outcomes