Suppress deleted data 1

[brecat77]

here is the formula i am using

IF ISNULL ({p21_view_inv_xref.delete_flag}) OR
{p21_view_inv_xref.delete_flag} = 'N' THEN {invoice_line.extended_price}

ELSE 0

this works great as a sum total, but in my details section it shows them with a Y or a N. I need for it to not show those with a delete flag of Y. the line has about 7 fields across. suggestions?

example

1 1234 test N 1.01
2 1234 test Y 1.01
3 5432 test N 2.25
4 5432 test Y 2.25

I do not want the ones with a del flag of Y to show up.

 

[lbass]

Use a record selection formula (report->selection formula->record) like this:

ISNULL ({p21_view_inv_xref.delete_flag}) OR
{p21_view_inv_xref.delete_flag} = 'N'

-LB

 

[brecat77]

Worked like a charm....Thanks again, this place is great.