Thank you for your reply. I think i have now solved this using the expression....
Startswith(PROJECT_COST_CODE.REFERENCE,"ELEC20")
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Search found 3 matches
- 21 Jan 2022, 12:07
- Forum: Sage 50 UK version General Help
- Topic: Expression to only include information in report
- Replies: 4
- Views: 5337
- 20 Jan 2022, 15:47
- Forum: Sage 50 UK version General Help
- Topic: Expression to only include information in report
- Replies: 4
- Views: 5337
Re: Expression to only include information in report
I have now tried the below. Which still doesn't remove the lines without this text but does show the text now not a number.
PROJECT_COST_CODE.REFERENCE LIKE ("ENG20")
PROJECT_COST_CODE.REFERENCE LIKE ("ENG20")
- 20 Jan 2022, 15:05
- Forum: Sage 50 UK version General Help
- Topic: Expression to only include information in report
- Replies: 4
- Views: 5337
Expression to only include information in report
Hi, I have designed a report and want to write an expression to only include certain cost codes. I have just used.... PROJECT_COST_CODE.REFERENCE="ELEC20"OR PROJECT_COST_CODE.REFERENCE="ELEC30"OR PROJECT_COST_CODE.REFERENCE="ELEC99"OR PROJECT_COST_CODE.REFERENCE="E...