Is it possible to use the SQL commands in Print Layout Designer (PLD)?

baobao

'If', 'Then', 'Else' are SQL functionalities and are not recognized by the PLD template.  To obtain similar results as that of SQL, binary logic must be used in PLD. To obtain the same logic, follow these steps:

• Create a field with the information containing the required condition (e.g. Field_A).
• Create a 'Formula' field where 'Field_A' will be equal to specific data in the table.
• Link 'Field_ A' with the 'Formula' field.  The 'Link To' field is used to link the two fields together.

Let us take this example. The condition is to suppress the header of a Sales BOM from displaying in the Sales Order print out; only the component items of a Sales BOM should be displayed.



1. Create a 'Data' field called 'TreeType' (Field_793 in screenshot).  This displays the item's Bill of Material (BOM) type. When 'TreeType' = 'S', this indicates a Sales BOM. When 'TreeType' = 'I', this indicates a component of a BOM.  'TreeType' = 'N', this indicates that the Item is not a BOM.



2. Create a 'Formula' field where the 'Data' field from Step 1 is not equal to 'S' (Field_795 in screenshot).



3. In the Sales Order print out, the 'Data' field is empty when the 'TreeType' is 'S'. Once all Fields in that row have been linked to the 'Formula' field, the line disappears from the Sales Order print out. If one of these fields is currently linked to a different field, it should be left as is. The 'Data' and 'Formula' fields do not need to be visible unless required.