//ReportID: 10207 //TipeID: 1 //LastChanged: 06.12.2013 12:40:46 //Description: Stampa naloga za pakovanje //LinkRepID: 142 //BrojKolona: 0 //BrojRedova: 0 QROdsecnica(TQuickRep)=QRFFaktura.RxNalogPak&poPortrait@Default[2100x2970,100x60,100x100]Arial»8@10[]204#1{0}!QRF.QRNalogZaPakovanjeAfterPrint|\?/^0000/0&1@psSolid« qryStavka(TpFIBDataSet)=507[IBMastData.FIBDatabase]{010} { SELECT S.VRDOK, S.BRDOK, S.VRSTA, S.ROBAID, S.MAGACINID, R.KATBR, R.KATBRPRO, R.PROID, R.JM, R.TRPAK, R.TRKOL, R.TRDECPAK, R.ALTJM, R.ALTKOL, R.ALTNEDELJIVA, SUM(S.KOLICINA) AS KOLICINA, S.NAZIV, AVG(S.PRODAJNACENA) AS PRODAJNACENA, AVG(S.POREZ) AS POREZ, AVG(S.RABAT) AS RABAT, S.ZVEZDICA FROM STAVKA S left join ROBA R on S.ROBAID = R.ROBAID WHERE S.VRDOK = :VRDOK AND S.BRDOK = :BRDOK AND S.VRSTA IN (1, 3) GROUP BY S.VRDOK, S.BRDOK, S.VRSTA, S.ROBAID, S.MAGACINID, R.KATBR, R.KATBRPRO, R.PROID, R.JM, R.TRPAK, R.TRKOL, R.TRDECPAK, R.ALTJM, R.ALTKOL, R.ALTNEDELJIVA, S.NAZIV, S.ZVEZDICA ORDER BY S.NAZIV } qryStavRok(TpFIBDataSet)=508[IBMastData.FIBDatabase]{011} { SELECT DATUM, SERIJA, ROUNDDEC(SUM(KOLICINA), 3) AS STANJE FROM STAVROK WHERE ROBAID = :ROBAID AND VRDOK = :VRDOK AND BRDOK = :BRDOK GROUP BY DATUM, SERIJA ORDER BY DATUM, SERIJA } qryDokument(TpFIBDataSet)=509[IBMastData.FIBDatabase]{010} { SELECT D.*, V.NAZIVDOK, M.NAZIV as MAGNAZIV FROM DOKUMENT D LEFT JOIN VRSTADOK V ON D.VRDOK = V.VRDOK LEFT JOIN MAGACIN M ON D.MAGACINID = M.MAGACINID WHERE D.VRDOK = :VRDOK AND D.BRDOK = :BRDOK } qryPP(TpFIBDataSet)=510[IBMastData.FIBDatabase]{010} { select PP.NAZIV, PP.ADRESA, PP.POSTA, M.NAZIV as MESTONAZIV from PARTNER PP left join MESTA M on PP.MESTOID = M.MESTOID where PP.PPID = :PPID } qryDodatni(TpFIBDataSet)=511[IBMastData.FIBDatabase]{010} { SELECT RR.ROBAID, R.KATBR, R.KATBRPRO, R.NAZIV, R.JM, R.PROID, R.TRPAK, R.TRKOL, R.TRDECPAK, R.ALTJM, R.ALTKOL, R.ALTNEDELJIVA, RR.KOLICINA FROM ROBA_ROBA RR LEFT JOIN ROBA R ON RR.ROBAID = R.ROBAID WHERE RR.LROBAID = :LROBAID ORDER BY R.NAZIV } qryPozicije(TpFIBDataSet)=512[IBMastData.FIBDatabase]{010} { SELECT G.*, P.NAZIV as POZICIJANAZIV FROM GDEUMAGACINU G left join POZICIJA P on G.MAGACINID = P.MAGACINID and G.POZICIJA = P.POZICIJAID WHERE G.ROBAID = :ROBAID AND G.MAGACINID = :MAGACINID ORDER BY G.MAGACINID, G.POZICIJA } DetailBand1(TQRBand)=rbDetail[18]204$16777215{000011}!QRFFaktura.OdsecnicaDetailBand1BeforePrint^0000/0&1@psSolid« GroupFooterBand1(TQRBand)=rbSummary[40]»0@[]204$16777215{000011}!^0000/0&1@psSolid« PageHeaderBand1(TQRBand)=rbPageHeader[167]»0@[]204$16777215{000011}!^0000/0&1@psSolid« QRPageFooter(TQRBand)=rbPageFooter[60]${000011}!^0000/0&1@psSolid« QRSubDetail1(TQRSubDetail)=,&QROdsecnica@qryStavRok[16]204$16777215{0000001}%!QRFFaktura.OdsecnicaQRSubDetail1BeforePrint^0000/0&1@psSolid« ChildBand(TQRChildBand)=DetailBand1[16]204${000001}!QRFFaktura.OdsecnicaChildBandBeforePrint^0000/0&1@psSolid« LinijaRokVert(TQRShape)=QRSubDetail1@458,2[4x9]204#$qrsVertLine{00011}!^0000/0&1@psSolid« LinijaRokHor(TQRShape)=QRSubDetail1@459,8[10x4]204#$qrsHorLine{00011}!^0000/0&1@psSolid« dbtStanje(TQRDBText)=QRSubDetail1@474,1[62x14]Arial»8@8[]204#taRightJustify$###,###,##0.####{00101}qryStavRok%STANJE!^0000/0&1@psSolid« dbtDatumRoka(TQRDBText)=QRSubDetail1@545,1[62x14]Arial»8@8[]204#taLeftJustify$dd.mm.yyyy{00101}qryStavRok%DATUM!^0000/0&1@psSolid« dbtNaziv(TQRDBText)=DetailBand1@226,2[272x14]Arial»8@8[]204#taLeftJustify${00101}QRFFaktura.RxNalogPak%NAZIV!^0000/0&1@psSolid« dbtKolicina(TQRDBText)=DetailBand1@649,2[63x14]Arial»8@8[]204#taRightJustify$###,###,##0.####{00101}QRFFaktura.RxNalogPak%KOLICINA!^0000/0&1@psSolid« dbtJM(TQRDBText)=DetailBand1@610,2[32x14]Arial»8@8[]204#taLeftJustify${00101}QRFFaktura.RxNalogPak%JM!^0000/0&1@psSolid« sysRBr(TQRSysData)=DetailBand1@9,0[27x17]»0@[]204#taRightJustify${00001}qrsDetailNo!^0000/0&1@psSolid« dbtKatBroj(TQRDBText)=DetailBand1@44,2[73x14]Arial»8@8[]204#taLeftJustify${00101}QRFFaktura.RxNalogPak%KATBR!^0000/0&1@psSolid« LinijaUkupno(TQRShape)=GroupFooterBand1@2,2[728x4]&2@#&$qrsHorLine{00011}!^0000/0&1@psSolid« lblUkupno(TQRLabel)=GroupFooterBand1@554,9[68x17]Arial»0@10[fsBold]204#taLeftJustify${00101}ÂÊÓÏÍÎ : !^0000/0&1@psSolid« lblPripremio(TQRLabel)=QRPageFooter@19,2[88x16]Arial»8@8[]204#taLeftJustify${00101}Êîíòðîëèðàë:!^0000/0&1@psSolid« lblKontrolisao(TQRLabel)=QRPageFooter@259,2[88x16]Arial»8@8[]204#taLeftJustify${00101}Ïðåäàë:!^0000/0&1@psSolid« lblKatBroj(TQRLabel)=PageHeaderBand1@44,144[71x17]Arial»8@8[]204#taLeftJustify${00101}Àðòèêàë!^0000/0&1@psSolid« lblNaziv(TQRLabel)=PageHeaderBand1@226,144[272x17]Arial»8@8[]204#taLeftJustify${00101}Îïèñ!^0000/0&1@psSolid« lblKolicina(TQRLabel)=PageHeaderBand1@649,144[63x17]Arial»8@8[]204#taRightJustify${00101}Êîë.!^0000/0&1@psSolid« lblJM(TQRLabel)=PageHeaderBand1@610,144[25x17]Arial»8@8[]204#taLeftJustify${10101}ÅÌ!^0000/0&1@psSolid« lblRBr(TQRLabel)=PageHeaderBand1@9,144[27x17]Arial»8@8[]204#taRightJustify${00101}áð.!^0000/0&1@psSolid« dbtReferent(TQRDBText)=PageHeaderBand1@115,111[139x16]Arial»8@10[]204#taLeftJustify${10101}qryDokument%REFID!QRFFaktura.OdsecnicadbtReferentPrint^0000/0&1@psSolid« lblReferent(TQRLabel)=PageHeaderBand1@5,110[63x17]Arial»8@10[]204#taLeftJustify${10101}Ðåôåðåíò:!^0000/0&1@psSolid« dbtRefID(TQRDBText)=PageHeaderBand1@73,111[39x16]Arial»8@10[]204#taLeftJustify${10101}qryDokument%REFID!^0000/0&1@psSolid« lblDatum(TQRLabel)=PageHeaderBand1@5,71[46x18]Arial»0@10[]204#taLeftJustify${00101}Äàòóì:!^0000/0&1@psSolid« dbtDatum(TQRDBText)=PageHeaderBand1@73,71[86x18]Arial»0@10[]204#taLeftJustify${00101}qryDokument%DATUM!^0000/0&1@psSolid« lblNaslov(TQRLabel)=PageHeaderBand1@2,35[229x24]Arial»0@12[fsBold]204#taRightJustify${00101}Íàëîã çà ïðîôàêòóðà áð.!^0000/0&1@psSolid« dbtBrDok(TQRDBText)=PageHeaderBand1@233,37[72x21]Arial»0@12[]204#taLeftJustify${00101}qryDokument%BRDOK!^0000/0&1@psSolid« dbtKupac(TQRDBText)=PageHeaderBand1@443,50[271x18]Arial»0@10[]204#taLeftJustify${00101}Caller.qryPP%NAZIV!^0000/0&1@psSolid« dbtAdresa(TQRDBText)=PageHeaderBand1@443,70[271x18]Arial»0@10[]204#taLeftJustify${00101}qryPP%ADRESA!^0000/0&1@psSolid« dbtPosta(TQRDBText)=PageHeaderBand1@443,89[60x18]Arial»0@10[]204#taLeftJustify${00101}qryPP%POSTA!^0000/0&1@psSolid« dbtMestoKupca(TQRDBText)=PageHeaderBand1@508,89[207x18]Arial»0@10[]204#taLeftJustify${00101}qryPP%MESTONAZIV!^0000/0&1@psSolid« lblMagacin(TQRLabel)=PageHeaderBand1@5,91[63x18]Arial»0@10[]204#taLeftJustify${00101}Ìàãàöèí:!^0000/0&1@psSolid« dbtMagacin(TQRDBText)=PageHeaderBand1@73,91[339x18]Arial»0@10[]204#taLeftJustify${00101}qryDokument%MAGNAZIV!^0000/0&1@psSolid« lblIsporuka(TQRLabel)=GroupFooterBand1@4,10[70x15]Arial»8@8[]204#taLeftJustify${10101}Èñïîðóêà : !^0000/0&1@psSolid« dbtIsporuka(TQRDBText)=GroupFooterBand1@85,9[200x17]Arial»0@10[]204#taLeftJustify${00101}qryDokument%PREVOZROBE!QRFFaktura.OdsecnicadbtIsporukaPrint^0000/0&1@psSolid« dbtVerifikovan(TQRDBText)=PageHeaderBand1@500,10[150x16]Arial»@10[]204#taLeftJustify${00011}qryDokument%FLAG!QRFFaktura.OdsecnicadbtVerifikovanPrint^0000/0&1@psSolid« dbtVrstaDok(TQRDBText)=PageHeaderBand1@194,58[200x18]Arial»0@10[]204#taLeftJustify${00100}qryDokument%NAZIVDOK!^0000/0&1@psSolid« dbtSerija(TQRDBText)=QRSubDetail1@620,1[100x14]Arial»8@8[]204#taLeftJustify${00101}qryStavRok%SERIJA!^0000/0&1@psSolid« lblPozicijeNaslov(TQRLabel)=ChildBand@31,0[75x16]Arial»@8[]204#taRightJustify${00011}Pozicije:!^0000/0&1@psSolid« lblPozicije(TQRLabel)=ChildBand@113,0[350x16]Arial»@8[]204#taLeftJustify${00011}Pozicije:!^0000/0&1@psSolid« dbtIntBroj(TQRDBText)=PageHeaderBand1@322,37[72x21]Arial»0@13[]204#taLeftJustify${00101}qryDokument%INTBROJ!^0000/0&1@psSolid« dbtFirma(TQRDBText)=PageHeaderBand1@3,2[325x24]Arial Black»0@13[fsBold]204#taLeftJustify${00101}IBMastData.Firma%NAZIV!^0000/0&1@psSolid« dbtKatBroj1(TQRDBText)=DetailBand1@122,2[93x14]Arial»8@8[]204#taLeftJustify${00101}QRFFaktura.RxNalogPak%KATBRPRO!^0000/0&1@psSolid« expUkKol(TQRExpr)=GroupFooterBand1&@649,9[63x16]#taRightJustify$###,###,##0.####{000111}SUM(RxNalogPak.KOLICINA)!^0000/0&1@psSolid« linPripremio(TQRShape)=QRPageFooter@10,40[150x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid« linKontrolisao(TQRShape)=QRPageFooter@256,40[150x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid« LinijaUkupno1(TQRShape)=PageHeaderBand1@2,140[728x3]&1@#&$qrsHorLine{00011}!^0000/0&1@psSolid« LinijaUkupno11(TQRShape)=PageHeaderBand1@2,162[728x3]&1@#&$qrsHorLine{00011}!^0000/0&1@psSolid« linVert(TQRShape)=PageHeaderBand1@1,141[3x22]&@#&$qrsVertLine{00011}!^0000/0&1@psSolid« linVert1(TQRShape)=PageHeaderBand1@38,141[3x22]&@#&$qrsVertLine{00011}!^0000/0&1@psSolid« linVert2(TQRShape)=PageHeaderBand1@220,141[3x22]&@#&$qrsVertLine{00011}!^0000/0&1@psSolid« linVert3(TQRShape)=PageHeaderBand1@597,141[3x22]&@#&$qrsVertLine{00011}!^0000/0&1@psSolid« linVert31(TQRShape)=PageHeaderBand1@643,141[3x22]&@#&$qrsVertLine{00011}!^0000/0&1@psSolid« linVert32(TQRShape)=PageHeaderBand1@728,141[3x22]&@#&$qrsVertLine{00011}!^0000/0&1@psSolid«