Hallo,
ich bastle schon seit einiger Zeit daran, dass ich das Merkmal
Pack in die entsprechende Zeile bekomme. Doch leider kommt
diese Angabe immer um eine halbe Zeile nachnunten versetzt.
Kann mir jemand helfen?
Besten Dank
Karlheinz
<!-- wbcprint:header1 -->
<!-- wbc:begin table="config" where="id>0" maxrows="1" -->
<!-- wbcif:begin query="data" var="logo" -->
<!-- wbcif:end -->
SetFont('Arial','',8)
SetXY(130,17)
SetXY(130,$this->GetY())
MultiCell(68,4,"{firma}\n{anschrift}",0,'R')
<!-- wbc:end -->

<!-- wbc:begin table="sales" select="uid as userid" where="sid={getnum.sid}" -->
<!-- wbc:begin table="users" where="uid={userid}" maxrows="1" -->
SetXY(130,10)
Ln()
SetLeftMargin($this->GetX()+10)
Write(4,'{firma}')
Ln()
Write(4,'{ustid}')
<!-- wbcif:begin query="data" var="name" -->
Ln()
Write(4,'{vorname} {name}')
<!-- wbcif:end -->
Ln()
Write(4,'{strasse}')
Ln()
Write(4,'{plz} {ort}')
<!-- wbc:begin table="properties" where="typ='co' and id='{land}'" -->
Ln()
SetFont('Arial','',8)
Write(4,'{kurzbez}')
SetFont('Arial','',8)
<!-- wbc:end -->

SetDrawColor(128,128,128)
SetXY(90,21)
Cell(20,4,'Kunden-Nr',0,0,'L',0)
Cell(20,4,'{knr}',0,0,'R',0)
<!-- wbc:end -->

Ln()
SetLeftMargin($this->GetX()-10)

<!-- wbc:end -->
<!-- wbc:begin table="sales" where="sid={getnum.sid}" -->
SetXY(90,32)
SetFont('Arial','',8)
<!-- wbcif:begin query="data" var="gid" value="5" operator="#" -->
Write(0,'LIEFERSCHEIN NR.: {prefix}{lfdnr}')
<!-- wbcif:end -->

Ln()
MultiCell(125,4,"{statustext}",0,'L')

SetXY(90,17)
SetFont('Arial','',8)
SetDrawColor(128,128,128)
Cell(20,4,'Datum',0,0,'L',0)
Cell(20,4,'{cdatum:datum}',0,0,'R',0)
SetXY(90,25)
Cell(20,4,'Seite',0,0,'L',0)
Cell(20,4,$this->PageNo(),0,0,'R',0)

Ln()
SetY(40)
SetDrawColor(128,128,128)
SetDrawColor(128,128,128)
SetFillColor(255,255,255)
Cell(35,5,'Gesamt-Pos',1,0,'L',1)
Cell(25,5,'{gespos:int}',1,0,'L',1)
Cell(15,5,'Menge',1,0,'C',1)
Cell(103,5,'Bezeichnung/Text',1,0,'L',1)
<!-- wbcif:begin query="data" var="gid" value="5" operator="!" -->
Cell(15,5,'{app.format_wrg}',1,0,'C',1)
<!-- wbcif:end -->
<!-- wbc:end -->
Ln()
SetY(45)


<!-- wbcprint:header2 -->
<!-- wbc:begin table="config" where="id>0" maxrows="1" -->
SetFont('Arial','',8)
Ln()
SetY(18)
<!-- wbc:end -->
<!-- wbc:begin table="sales" where="sid={getnum.sid}" -->
SetFont('Arial','',8)
<!-- wbcif:begin query="data" var="gid" value="5" operator="#" -->
Write(0,'LIEFERSCHEIN {prefix}{lfdnr}')
<!-- wbcif:end -->
SetFont('Arial','',8)
SetXY(158,15)
SetDrawColor(128,128,128)
Cell(20,4,'Datum',0,0,'L',0)
Cell(20,4,'{cdatum:datum}',0,0,'R',0)
SetXY(158,19)
Cell(20,4,'Seite',0,0,'L',0)
Cell(20,4,$this->PageNo(),0,0,'R',0)

Ln()
SetY(25)
SetDrawColor(128,128,128)
SetDrawColor(0,0,0)
SetFillColor(255,255,255)
Cell(60,5,'Artikel-Nr',1,0,'L',1)
Cell(15,5,'Menge',1,0,'C',1)
Cell(103,5,'Bezeichnung/Text',1,0,'L',1)
<!-- wbcif:begin query="data" var="gid" value="5" operator="!" -->
Cell(15,5,'{app.format_wrg}',1,0,'C',1)
Ln()
<!-- wbcif:end -->
<!-- wbc:end -->
Ln()
SetY(30)


<!-- wbcprint:footer2 -->
Ln()
SetY(255)
<!-- wbc:begin table="sales" where="sid={getnum.sid}" -->
<!-- wbcif:begin query="data" var="gid" value="5" operator="!" -->
<!-- wbcif:end -->
<!-- wbc:end -->




<!-- wbcprint:body -->
<!-- wbc:begin table="salepos as b left join sales as d on d.sid=b.sid left join items as a on a.pid=b.pid left join properties as c on c.id=b.meh" select="a.*,b.*,c.keyname as mehtext,d.gid as gid,b.id as posid,b.parentid as parentvar" where="b.sid={getnum.sid}" order="a.produktid asc" -->
<!-- wbcif:begin query="data" var="typ" value="1" -->
SetFont('Arial','',11)
SetDrawColor(128,128,128)
CellMax(60,5,'{a.produktid}',1)
SaveXY()
CellMax(15,5,'{b.menge:num} {mehtext}',1,0,'C')
CellMax(103,5,'<!-- wbcif:begin query="data" var="parentvar" value="0" operator="<" --><!-- wbc:begin table="items" where="pid={parentvar}" maxrows="1" select="bezeichnung" -->{bezeichnung} <!-- wbc:end --><!-- wbcif:end -->{a.bezeichnung}',1)
SaveVar("aktzz",$this->GetY(),0)
<!-- wbc:begin table="merkmale" where="typ='SPOS' and lid={posid} and (mtyp='sel' or mtyp='ein')" select="*,id as merkmalid,mid as mediaid" -->
Ln()
SetX($this->GetX()+33)
CellMax(113,5,"<!-- wbc:begin table="properties" where=" id={mid}" -->{kurzbez} <!-- wbc:end --><!-- wbcif:begin query="data" var="mtyp" value="sel" --> <!-- wbc:begin table="merkmale as a left join media as b on b.id=a.mid" where="a.typ=\"MKSP\" and a.lid={merkmalid&#x7d;" select="a.id as merkmalid,a.lid,a.bezeichnung,b.bezeichnung as merkmaltext" maxrows="1" -->{merkmaltext}<!-- wbc:end --><!-- wbcif:end --><!-- wbcif:begin query="data" var="mtyp" value="ein" -->{bezeichnung}<!-- wbcif:end -->",1)
SaveVar("aktzz",$this->GetY(),0)
<!-- wbc:end -->
RestoreXY(123,0)

<!-- wbc:begin select="data.bezeichnung" table="properties as a left join merkmale as data on data.mid=a.id left join items as b on b.pid=data.lid" where="a.kurzbez='Pack' and data.typ='ITEM' and data.lid={a.pid}" nocount="1" -->
Ln()
SetX($this->GetX()+40)
CellMax(70,0,"Pack: {data.bezeichnung}")
SaveVar("aktzz",$this->GetY(),0)
<!-- wbc:end -->

<!-- wbcif:begin query="data" var="gid" value="5" operator="!" -->
Cell(15,5,'{b.preis:wrg}',1,0,'R')
SaveVar("zsumme",{b.wert:num},1)
<!-- wbcif:end -->


<!-- wbcif:end -->
<!-- wbcif:begin query="data" var="typ" value="2" -->
SetX($this->GetX()+33)
MultiCell(150,4,'{b.kurzbez}',0,'L')
SaveVar("aktzz",$this->GetY(),0)
<!-- wbcif:end -->
SetY($this->GetVar("aktzz"))
Ln()
Line($this->GetX(),$this->GetY(),$this->GetX()+178,$this->GetY())
<!-- wbc:end -->

<!-- wbc:begin table="sales" select="ladr as liefadr" where="sid={getnum.sid}" -->
<!-- wbcif:begin query="data" var="liefadr" value="0" operator="<" -->
<!-- wbc:begin table="users" where="uid={liefadr:int}" maxrows="1" -->
Ln()
Write(4,'Lieferadresse:')
Ln()
Write(4,'{firma}')
Ln()
Write(4,'{vorname} {name}')
Ln()
Write(4,'{strasse}')
Ln()
Write(4,'{plz} {ort}')
<!-- wbc:begin table="properties" where="typ='co' and id='{land}'" -->
Ln()
Write(4,'{kurzbez}')
<!-- wbc:end -->
<!-- wbcif:end -->
<!-- wbc:end -->