Using Or in searching
Using Or in searching
I have a table with a field called Fruit. I want to filter the report to show just records that contain Apples or Oranges.
I am using a stateless form for the user to select the fruits from a list. Then an openurl statement is used to open the report. I know openurl does not support different values for the same field. Does anyone have suggestion on how to achieve this?
I've thought about adding a special field to indicate the records that match the criteria and then displaying the records with a true value. There are several problems with this approach so I'm hoping someone has a better solution.