Stock
Stock - Option Items on Layout files
Prints incorrect on Layout files
Added Dataset and Subreport 2 (Options) to Document layout files.
select op1.SDescription Desc1,
op2.SDescription Desc2,
op3.SDescription Desc3,
op4.SDescription Desc4,
op5.SDescription Desc5,
b.fqty,b.fextraprice,
d.sDescription linedesc
from doclineoptions b
left join itemoptionsvalues op1 on op1.WItemoptionid = b.witemoptionvalue1id
left join itemoptionsvalues op2 on op2.WItemoptionid = b.witemoptionvalue2id
left join itemoptionsvalues op3 on op3.WItemoptionid = b.witemoptionvalue3id
left join itemoptionsvalues op4 on op4.WItemoptionid = b.witemoptionvalue4id
left join itemoptionsvalues op5 on op5.WItemoptionid = b.witemoptionvalue5id
left join messages d on b.wdescriptionid = d.wmessageid
where b.wdocid =:wdocid and b.wlineid = :wdoclineid