//ReportID: 631
//TipeID: 11
//LastChanged: 16.05.2014 09:15:57
//Description: Evidencija isplacene i vracene komisione robe
//LinkRepID: 246
//BrojKolona: 0
//BrojRedova: 0
QROdjavaKomision(TQuickRep)=qryStav&poPortrait@Default[2100x2970,100x70,100x100]Arial»0@8[]1#1{1}!|<>\?/^0000/0&1@psSolid«
qryStav(TpFIBDataSet)=420[IBMastData.FIBDataBase]{110}
{
select S.ROBAID, S.NABAVNACENA, S.NAZIV, R.KATBR, R.KATBRPRO, R.NAZIV AS NAZIVROBE,
  SUM(ROUND2(S.NABAVNACENA * S.KOLICINA)) AS NABVREDSAPOR, SUM(S.KOLICINA) as KOLICINA 
from STAVKA S LEFT JOIN ROBA R ON S.ROBAID = R.ROBAID
where VRDOK = :VRDOK and BRDOK = :BRDOK
group by S.ROBAID, S.NABAVNACENA, S.NAZIV, R.KATBR, R.KATBRPRO, R.NAZIV
having SUM(S.KOLICINA) > 0
order by R.KATBR, R.KATBRPRO, S.NAZIV
}
qryDok(TpFIBDataSet)=419[IBMastData.FIBDataBase]{010}
{
select D.VRDOK, D.BRDOK, D.INTBROJ, D.DATUM, D.PPID, 
          D.MAGACINID, M.NAZIV AS MAGNAZIV
from DOKUMENT D left join MAGACIN M on D.MAGACINID = M.MAGACINID
where D.VRDOK = :VRDOK and D.BRDOK = :BRDOK
}
qryPP(TpFIBDataSet)=421[IBMastData.FIBDataBase]{010}
{
select P.*
from PARTNER P
where P.PPID = :PPID
}
PageFooterBand1(TQRBand)=rbPageFooter[24]$16777215{00001}!^
PageHeaderBand1(TQRBand)=rbPageHeader[160]Arial»0@8[]1$16777215{000011}!^0000/0&1@psSolid«
SummaryBand1(TQRBand)=rbSummary[144]$16777215{00001}!^0000/0&1@psSolid«
QRSubDetail(TQRSubDetail)=SummaryBand1,PageHeaderBand1&QROdjavaKomision@qryStav[20]${00000011}%!^0000/0&1@psSolid«
lblTacka(TQRLabel)=QRSubDetail@38,0[4x15]Arial»0@8[]1#taLeftJustify${00101}.!^0000/0&1@psSolid«
dbtNazivRobe(TQRDBText)=QRSubDetail@271,0[232x15]Arial»0@8[]1#taLeftJustify${01101}qryStav%NAZIV!^0000/0&1@psSolid«
dbtIsplaceno(TQRDBText)=QRSubDetail@630,0[90x15]Arial»0@8[]1#taRightJustify$###,###,##0.00{00101}qryStav%NabVredSaPor!frmKomisionEvid.dbtPrint^0000/0&1@psSolid«
QRSysData2(TQRSysData)=PageFooterBand1@6,4[74x16]#taLeftJustify$Strana {10001}qrsPageNumber!^
dbtFirma(TQRDBText)=PageHeaderBand1@4,2[325x24]Arial Black@13[fsBold]0#taLeftJustify${00101}IBMastData.Firma%NAZIV!^
OkvirZaHeader(TQRShape)=PageHeaderBand1@1,120[726x36]&@#16777215&$qrsRectangle{00011}!^0000/0&1@psSolid«
lblNaslov(TQRLabel)=PageHeaderBand1@4,33[230x20]Arial»0@13[fsBold]0#taLeftJustify${00101}Odjava komisione robe br.!^0000/0&1@psSolid«
lblIznosIsplate(TQRLabel)=PageHeaderBand1@630,138[90x15]#taRightJustify${10101}Iznos!^0000/0&1@psSolid«
lblRBr(TQRLabel)=PageHeaderBand1@2,137[39x16]#taLeftJustify${10101}Red.br.!^0000/0&1@psSolid«
lblKomisionar(TQRLabel)=SummaryBand1@500,77[185x17]Arial»0@10[]1#taLeftJustify${00101}Komisionar!^0000/0&1@psSolid«
LinijaPotpis(TQRShape)=SummaryBand1@504,126[185x7]&@#&$qrsHorLine{00011}!^0000/&@«
LinijaUkupno(TQRShape)=SummaryBand1@1,0[724x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
lblSvega(TQRLabel)=SummaryBand1@228,5[42x15]Arial»0@8[fsBold]1#taRightJustify${00101}Svega!^0000/0&1@psSolid«
lblOpis(TQRLabel)=PageHeaderBand1@272,138[170x15]#taLeftJustify${00101}Naziv robe!^0000/0&1@psSolid«
lblKomitent(TQRLabel)=SummaryBand1@30,77[185x17]Arial»0@10[]1#taLeftJustify${00101}Komitent!^0000/0&1@psSolid«
LinijaPotpis1(TQRShape)=SummaryBand1@30,126[185x7]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
dbtBrDok(TQRDBText)=PageHeaderBand1@239,35[100x17]Arial»8@10[fsBold]1#taCenter${00101}qryDok%BRDOK!QRF.QRDocBrDokPrint^0000/0&1@psSolid«
dbtIntBroj(TQRDBText)=PageHeaderBand1@342,35[108x17]Arial»8@10[fsItalic]1#taLeftJustify${00101}qryDok%INTBROJ!QRF.QRDocIntBrojPrint^0000/0&1@psSolid«
lblDatum(TQRLabel)=PageHeaderBand1@8,57[43x17]Arial»0@10[]0#taLeftJustify${00101}Datum:!^0000/0&1@psSolid«
dbtDatum(TQRDBText)=PageHeaderBand1@106,57[85x17]Arial»0@10[]0#taLeftJustify${00101}qryDok%DATUM!^0000/0&1@psSolid«
lblDobavljac(TQRLabel)=PageHeaderBand1@8,75[64x17]Arial»0@10[]0#taLeftJustify${00101}Vlasnik robe:!^0000/0&1@psSolid«
dbtPPID(TQRDBText)=PageHeaderBand1@106,75[55x17]Arial»0@10[]0#taLeftJustify${00101}qryDok%PPID!^0000/0&1@psSolid«
dbtPartner(TQRDBText)=PageHeaderBand1@168,75[421x17]Arial»8@10[fsBold]1#taLeftJustify${00101}qryPP%NAZIV!^0000/0&1@psSolid«
lblPoDokumentu(TQRLabel)=PageHeaderBand1@8,95[95x18]Arial»0@10[]0#taLeftJustify${00101}Red.br.iz KEPU!^0000/0&1@psSolid«
dbtPoDokumentu(TQRDBText)=PageHeaderBand1@107,95[155x18]Arial»0@10[]0#taLeftJustify${00101}qryDok%FAKTDOBIZV!frmDocMPKalk.dbtPrint^0000/0&1@psSolid«
lblMagacin(TQRLabel)=PageHeaderBand1@266,95[65x17]Arial»0@10[]0#taRightJustify${00101}Magacin:!^0000/0&1@psSolid«
dbtMagacin(TQRDBText)=PageHeaderBand1@336,95[275x17]Arial»0@10[]0#taLeftJustify${00101}qryDok%MAGNAZIV!^0000/0&1@psSolid«
expUkupno(TQRExpr)=SummaryBand1&QRSubDetail@620,5[100x16]Arial»@11[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStav.NabVredSaPor)!^0000/0&1@psSolid«
sysRBr(TQRExpr)=QRSubDetail&QRSubDetail@2,0[36x15]Arial»8@8[]1#taRightJustify$###{001001}COUNT!^0000/0&1@psSolid«
dbtKolicina(TQRDBText)=QRSubDetail@504,0[56x15]Arial»0@8[]1#taRightJustify$###,###,##0.###{00101}qryStav%KOLICINA!frmKomisionEvid.dbtPrint^0000/0&1@psSolid«
dbtCena(TQRDBText)=QRSubDetail@563,0[64x15]Arial»0@8[]1#taRightJustify$###,###,##0.00{00101}qryStav%NABAVNACENA!frmKomisionEvid.dbtPrint^0000/0&1@psSolid«
lblKolicina(TQRLabel)=PageHeaderBand1@504,138[56x15]#taRightJustify${10101}Kolicina!^0000/0&1@psSolid«
lblCena(TQRLabel)=PageHeaderBand1@563,138[64x15]#taRightJustify${10101}Cena bez PDV!^0000/0&1@psSolid«
dbtKatBr(TQRDBText)=QRSubDetail@44,0[110x15]Arial»0@8[]1#taLeftJustify${01101}qryStav%KATBR!^0000/0&1@psSolid«
dbtKatBrPro(TQRDBText)=QRSubDetail@157,0[112x15]Arial»0@8[]1#taLeftJustify${01101}qryStav%KATBRPRO!^0000/0&1@psSolid«
lblKatBr(TQRLabel)=PageHeaderBand1@44,138[109x15]#taLeftJustify${00101}Kataloski broj!^0000/0&1@psSolid«
lblKatBrPro(TQRLabel)=PageHeaderBand1@157,138[109x15]#taLeftJustify${00101}Kataloski broj proizv.!^0000/0&1@psSolid«