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

Sage 50 Report designer - IF THEN ELSE expression syntax

Report design issues and solutions.
Post Reply
decomplexity
User
User
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.

Example:

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:

if AUDIT_SPLIT.TYPE= “SI” or AUDIT_SPLIT.TYPE = “SC” then AUDIT_SPLIT.GROSS_AMOUNT

but this is an invalid expression.

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

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4617
Joined: 28 Feb 2006, 09:56
Sage Version: v28 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.

<<Expression>>?<<Do_this_if_True>>:<<Else_Do_This>>

So your code should be

AUDIT_SPLIT.TYPE= “SI” or AUDIT_SPLIT.TYPE = “SC”?AUDIT_SPLIT.GROSS_AMOUNT:0
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: Ahrefs [Bot] and 14 guests