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="ENG20"OR
PROJECT_COST_CODE.REFERENCE="ENG30"OR
PROJECT_COST_CODE.REFERENCE="ENG99"OR
PROJECT_COST_CODE.REFERENCE="MAN20"OR
PROJECT_COST_CODE.REFERENCE="MAN30"OR
PROJECT_COST_CODE.REFERENCE="MAN99"
but when i send report to excel the ones i don't want come up as 0.00000 and ones i do come up as 0.00001.
I want the report to still should the text as above but only the ones above no others.
Please help.
Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!
Expression to only include information in report
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")
- brucedenney
- Site Admin
- Posts: 4457
- Joined: 28 Feb 2006, 09:56
- Sage Version: v2017 23 UK/Europe/Africa
Re: Expression to only include information in report
As you want the report in Excel, I suggest that you consider doing the report in excel and extracting data via ODBC
If you want to attach the report/layout to a reply, I can have a look and see what is going on.
If you want to attach the report/layout to a reply, I can have a look and see what is going on.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. 

Re: Expression to only include information in report
Thank you for your reply. I think i have now solved this using the expression....
Startswith(PROJECT_COST_CODE.REFERENCE,"ELEC20")
Startswith(PROJECT_COST_CODE.REFERENCE,"ELEC20")
- brucedenney
- Site Admin
- Posts: 4457
- Joined: 28 Feb 2006, 09:56
- Sage Version: v2017 23 UK/Europe/Africa
Re: Expression to only include information in report
Just remember to be careful about your project names
Startswith(PROJECT_COST_CODE.REFERENCE,"ELEC20")
Would match with lots of other values that start with ELEC20 eg ELEC200 ELEC20A ELEC2000 ....
Startswith(PROJECT_COST_CODE.REFERENCE,"ELEC20")
Would match with lots of other values that start with ELEC20 eg ELEC200 ELEC20A ELEC2000 ....
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. 

Who is online
Users browsing this forum: No registered users and 0 guests