Page 1 of 1
Report Designer / Prevent Sage from printing statements for customers with an email address
Posted: 05 Nov 2015, 12:29
by andygeorge80
Please help,
I have two statement designs saved, one which I have formatted to only send to customers with an email address. However the other one is for printing statements and I can't find a way of preventing it printing statements to customers who have an email address. I'm sure this is something simple to do but I don't know how to, can anyone help me please. Thanks in advance Andy.
Re: Report Designer / Prevent Sage from printing statements for customers with an email address
Posted: 05 Nov 2015, 13:31
by andygeorge80
Version 20.04.09.364
Re: Report Designer / Prevent Sage from printing statements for customers with an email address
Posted: 05 Nov 2015, 13:31
by brucedenney
It is the antithesis of filtering to print only if there is an email address.
Typically the filter expression would be
SALES_LEDGER.E_MAIL = ""
Re: Report Designer / Prevent Sage from printing statements for customers with an email address
Posted: 05 Nov 2015, 13:55
by andygeorge80
Thanks, but I want to print if there isn't an email address
Re: Report Designer / Prevent Sage from printing statements for customers with an email address
Posted: 05 Nov 2015, 14:39
by Rufus1983
The filter expression given by Bruce looks for any record which does not have a value in the SALES_LEDGER.EMAIL field on the customer record, so should pick out any customers which do not have an email address recorded.
You can also use the following filter expression, which I use for my statements:
SALES_LEDGER.E_MAIL NOT LIKE "%@%"
Re: Report Designer / Prevent Sage from printing statements for customers with an email address
Posted: 05 Nov 2015, 14:44
by andygeorge80
YOU ARE AMAZING!!! Thank you so much for your time.