Skip to Content
Former Member
Mar 24, 2006 at 04:35 AM

How to restrict the output of 0VENDOR by excluding the # value in rows?


We generated a query whose InfoProvider is 0Vendor. Run the query, find the last row shows # as Vendor number and the description of it is "Not Assigned". Then we go to this query design screen, pick 0Vendor in the rows frame, right click and select Restrict, there are two tabs, one is "Fixed Values", the other one is "Variables". Click "Fixed Values" tab, can see that 1st value is "#", but from this window, we can't see any place to exclude this "#" value.

We are very appreciated anyone's input on how to get rid of the "#" value when run query.