Finding null or no values in active reports

Nov 21, 2005 1 Replies

Rate this thread:

Ivan Brebner 20 years ago

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

Vote

Glenn Adams [MVP - Retail Mgmt] 20 years ago

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

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Ask the community — no account required