remove line item record from report if the field value is N

[former_member197302]

I have Order Crystal report. Where I need to show information about Sales Order and items and I want to exclude lineitem where the field value is N . If I do select expert it is removing all line item. I just want to remove the lines where xyz field value is N

[former_member197302]

I tried to use select Expert option with below formula.

{ORDR.DocEntry} = {?DocKey@} and {RDR1.U_CommercialInv} <> "N"

But it did not work

[former_member197302]

in RDR1 Table we have user define field called Commercial Invoice Print. If that field has value N then do not print that line in Commercial Invoice. This field is going to entered in while creating Sales Order.

Here is the screenshot of SAP Crystal Report

[DellSC]

How are the tables linked in the report and which table contains the field that you want to filter on? What does the formula in the Select Expert look like when it's filtering out all of the data? Is N a dynamic value or is it always the same? Can it be null?

-Dell