Using One Crystal Report Layout for A/R DP Request and A/R DP Invoice

In SAP Business One, standard marketing documents such as A/R Down Payment Request and A/R Down Payment Invoice are using the same table (ODPI and DPI1). When you create a custom layout using Crystal Report Designer for those marketing documents, you can use only one layout with the additional query below to determine layout title in preview mode: SELECT      T0."DocNum",        T0."DocDate",      T0."CardCode",      T0."CardName",      T0."Comments",      T0."DocTotal",      T1."ItemCode",      T1."Dscription",      T1."Quantity",      T1."Price",      T1."DiscPrcnt",      T1."LineTotal",      CASE T0."CreateTran"