Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Dont filter out Null value in Selection Criteria

Hi

I created a crystal report that prompt user enter a salesrep's customer list that show last day the customer brought something;

Problem:

on my selection criteria i have:

1)salesrep number

2)order delete flag = N (i want to filter out any order that is been deleted

3)order cancel flag = N

above selection criteria filters out all my customer with delete flag = N but also customer with Null value, which i dont want my NULL to be filter out; i want to show all customer either brought not brought;

please help

Former Member
replied

Please try this and let me know the result

{p21_view_customer.salesrep_id} = {?PLEASE ENTER SAELSREP NUMBER} and

({p21_view_oe_hdr.delete_flag} = "N" or

isnull({p21_view_oe_hdr.delete_flag})=true or

trim({p21_view_oe_hdr.delete_flag})="")

Regards,

Raghavendra

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question