Crystal Question Linking Tables

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?

Parents Reply
  • 0 in reply to BShockley
    I had to remove both of my selections, the price code = 2 and customer # selection, and then it displays all records for all items.

    but, is there a way to limit the price code to just =2 , as we have other price codes that show up. also we have many customers so the report has many customers that i dont want to show on report?
Children