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!

Daft question - how do I edit an expression?

Report design issues and solutions.
Post Reply
Posts: 1
Joined: 30 Jul 2020, 15:06
Sage Version: v2014 20 UK/Europe/Africa

Daft question - how do I edit an expression?

Post by Dazzathedrummer » 30 Jul 2020, 15:15

I wrote a report about a year ago - it's an aged debtor report that splits the ageing into 30,60,90,120,150,180+ days rather than the usual standard ageing.

I wrote expressions to do the ageing and after not using the report for a while I've noticed that it's not calculating correctly when trying to run the report for a date that's in the past.

As it's been a while since I used Report Designer I can't find a way to edit the expressions - If I double-click an expression I get the 'Expression Editor' box but instead of showing the expression, it just displays the name of the expression.

It's driving me a bit crazy - I'm used to using SQL/Crystal but I can't figure this out.
You do not have the required permissions to view the files attached to this post.

User avatar
Site Admin
Site Admin
Posts: 4331
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Daft question - how do I edit an expression?

Post by brucedenney » 30 Jul 2020, 15:27

It appears that the expression is self referencing.

What is is supposed to be?

Delete the text in the expression then on the right hand side double click on the function or field you want in the expression and it will appear in the expression box.

Assuming this is a statement, the field should be the sum of AUDIT_SPLIT.FOREIGN_AGED_CURRENT so the expression is not needed, you can just put the field in the report and set it to be the sum, in its properties.
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. Image

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests