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!

Sage 50 Report designer - IF THEN ELSE expression syntax

Report design issues and solutions.
Post Reply
Posts: 8
Joined: 10 Aug 2011, 18:13
Sage Version: v2009 15 UK/Europe/Africa

Sage 50 Report designer - IF THEN ELSE expression syntax

Post by decomplexity » 05 Jan 2012, 20:11

I am trying to print a detail line where an entry in a particular column is printed or left blank not by whether it is (e.g.) Debit or Credit but by the evaluation of an expression.


One column in the detail line is for sales invoice values (SI) or sales credit values (SC).

In the variable specification for the invoices and credits column, I would like to put something like:


but this is an invalid expression.

Assuming that what I am trying to do is possible, any advice on how pls?

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

Re: Report designer - expression syntax

Post by brucedenney » 06 Jan 2012, 09:20

There is a different if statement which does work, this is just a quirck of the report designer.


So your code should be

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 4 guests