Sage 50 Report Designer Help
Posted: 16 Feb 2018, 22:15
Hi All,
Wondering if someone can help. I have finished of most of my Sage report but I'm struggling with 2 statements (Any help would be amazing)
1st Statement Issue:
So far I have INVOICE.DEL_NAME LIKE "" ? INVOICE.ADDRESS_1: INVOICE.DEL_ADDRESS_1 which is working fine but I also need to add in IF INVOICE.ADDRESS_1: INVOICE.DEL_ADDRESS_1 are blank as well then it needs to use INVOICE.NAME (Im just not 100% sure how to add in the rest of the statement)
2nd Statement Issue:
Again I have INVOICE.ANALYSIS_1 = "" ? INVOICE.CUST_TEL_NUMBER : INVOICE.ANALYSIS_1 which is working but I need to add in IF INVOICE.ANALYSIS_1 is alphabetical text and not numerical to pull from INVOICE.CUST_TEL_NUMBER and ignore what is in INVOICE.ANALYSIS_1
Also with this one im not sure if this is possible but if someone could clarify that would be great if there is a space within the number for it to ignore the space and just pull the number minus the spaces. So for example 0200 000 1234 pulls through to the report as 02000001234
If anyone can help that would be fantastic.
Wondering if someone can help. I have finished of most of my Sage report but I'm struggling with 2 statements (Any help would be amazing)
1st Statement Issue:
So far I have INVOICE.DEL_NAME LIKE "" ? INVOICE.ADDRESS_1: INVOICE.DEL_ADDRESS_1 which is working fine but I also need to add in IF INVOICE.ADDRESS_1: INVOICE.DEL_ADDRESS_1 are blank as well then it needs to use INVOICE.NAME (Im just not 100% sure how to add in the rest of the statement)
2nd Statement Issue:
Again I have INVOICE.ANALYSIS_1 = "" ? INVOICE.CUST_TEL_NUMBER : INVOICE.ANALYSIS_1 which is working but I need to add in IF INVOICE.ANALYSIS_1 is alphabetical text and not numerical to pull from INVOICE.CUST_TEL_NUMBER and ignore what is in INVOICE.ANALYSIS_1
Also with this one im not sure if this is possible but if someone could clarify that would be great if there is a space within the number for it to ignore the space and just pull the number minus the spaces. So for example 0200 000 1234 pulls through to the report as 02000001234
If anyone can help that would be fantastic.