I am currently on v2014 v5.1 MAS100 Standard ,using CR 2011 for Sage.

I am using CI_ITEM and IM_PriceCode Tables.

in IM_PriceCode we have price overrides that we use driven off of item# and Customer number.

so i want to write a report that will give me all items listed in ci_item  and then show me if we are using the Standardunitprice or if there is a discountMarkup1 value (override price)

i run the report for all items, and then have a select record as:

UpperCase({IM_PriceCode.CustomerNo}) = UpperCase({?CustNo}) and
UpperCase({CI_Item.ItemCode}) in UpperCase({?FROM ITEM}) to UpperCase({?TO ITEM}) and
{IM_PriceCode.PriceCodeRecord} = "2"

The result is it only gives me the items that have a pricecode override.

how do i make it spit everyitem in ci_item  even if there is no matching item number record in IM_Pricecode?