Menu

#535 Option items prints incorrect on layout files

1._Received
open
nobody
1
2015-03-05
2015-03-05
No

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

1 Attachments

Discussion


Log in to post a comment.