Finding null or no values in active reports

- I
- Ivan Brebner
  
  Contact options for registered users
posted
18 years ago

Mon, Nov 21, 2005 4:34 AM

Hi there,

I am trying to generate a report to disply all item lookup codes where alias is NULL. Can I do this in RMS Active reports?

Ivan

Loading thread data ...

- G
- Glenn Adams [MVP - Retail Mgmt]
  
  Contact options for registered users
Vote on answer
posted
18 years ago

Mon, Nov 21, 2005 4:45 PM

Yes. You'll need a LEFT JOIN to the Alias table, and you can put "( Alias.ItemID is null )" in the Selection Criteria section....

XML Sitemap
Terms of Service
Privacy Policy
Contact

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.