How to include a conditional statement into a report using Macros

How to include a conditional statement into a report using Macros

The following guide explains how to include a conditional statement in a report using Macros

This feature is available in the Lite, Professional, Premium and Managed subscriptions of One Stop Order Processing.


Html templates contain many macros to determine the data used on the report.

You can create more complex macros to calculate or to only use fields if certain attributes are true.

The following guide shows you all of the possible macros that can be used in One Stop Order Processing.

http://www.1stoporders.co.uk/download/IL_OSOPMacros.pdf

Towards the bottom of the macros guide it shows you how to create advanced macros.

Note: When creating calculations using macros in reports you need to put "#!#" either side of the calculation.

e.g #!#[%ORD_SUB_TOTAL%][+][%ORD_PNP%][*][1.2]#!#



    • Related Articles

    • Report Overview for One Stop Order Processing

      The following guide provides information on the different types of reports within One Stop Order Processing and how to create them. This feature is available in the Lite, Professional, Premium and Managed subscriptions of One Stop Order Processing. ...

    • How to include an SKU on your packing list

      The following guide explains how to include a SKU on the packing list in One Stop Order Processing. This feature is available in the Lite, Professional, Premium and Managed subscriptions of One Stop Order Processing. The packing list that you print ...

    • How to search for different values using macros

      You may want to have a macro (in a view, email or invoice) that tests for more than one value before generating an outcome. For example, if you want to provide a specific courier for all postcodes except certain specified area codes. This may be ...

    • What macros can I use in an email?

      Macros within emails You can use macros within emails by putting a #!# around the macro. All the data field macros can be used as well. A full list of these is available at the link below: List of macros These can be used to display different values ...

    • How to show custom order values in my Picking List or Sales Report?

      Introduced in version 2.0.0.32 You can now show the custom entered order values on the Picking List or Sales Report by using the following macros: [%CUSTOM_ENTERED1%] [%CUSTOM_ENTERED2%] [%CUSTOM_ENTERED3%] [%CUSTOM_ENTERED4%] [%CUSTOM_ENTERED5%] ...