Ordercontent

Report OrderContent

• Filename: OrderContent
• Title: Order Content
• Sample: Unit191 (form191)

Synopsis

Report to show the details of an order.

SQL

SELECT
  A.*,
  DClientFirstName + ' ' + DClientLastName AS DNAME,
  IClientFirstName + ' ' + IClientLastName AS INAME,
FROM
  SPIR_ORDER A
WHERE
  (OrderNo=:OrderNo)
ORDER BY
  ID ASC

Gift wrap display must be handled in code, according to the following SQL;

(CASE
   WHEN isnull(Gift_wrap, '0') = '1' then 'Yes'
   else 'No'
 END) AS OrdGifgt,
(CASE
   WHEN isnull(Row_Gift_wrap, '0') = '1' then 'Yes'
   else 'No'
 END) AS RowGifgt

Parameters

• OrderNo Order number

Accessible in forms

1. Pick and Pack