//ReportID: 745
//TipeID: 11
//LastChanged: 17.01.2020 11:31:27
//Description: Stampa dokumenta: Isporuka robe
//LinkRepID: 274
//BrojKolona: 0
//BrojRedova: 0
QRIsporukaRobe(TQuickRep)=qryStav&poPortrait@Default[2100x2970,90x90,100x100]Arial»8@14[]1#1{0}Isporuka robe!|<>\?/^0000/0&1@psSolid«
qryStav(TpFIBDataSet)=758[IBMastData.FIBDataBase]{110}
{
SELECT S.*,  
               case when (s.uplaceno is null) then 0 else s.uplaceno end as uplaceno,
               case when (s.uplaceno is null) then S.VREDNOST else S.VREDNOST - S.UPLACENO end AS ZA_UPLATU,
               PP.NAZIV as PPNAZIV, PP.ADRESA as PPADRESA,
               ME.NAZIV as MESTONAZIV,  
               M.NAZIV as MAGNAZIV, M.ADRESA as MAGADRESA, V.NAZIVDOK
FROM ISP_STAV S 
   left join PARTNER PP on S.PPID = PP.PPID 
   left join MAGACIN M on S.PPID = M.MAGACINID
   left join MESTA ME on S.MESTOID = ME.MESTOID 
   left join VRSTADOK V on S.VRDOK = V.VRDOK
WHERE S.ISPID = :ISPID and S.VVDOKID = :VVDOKID and S.PAKOVANJE <> 4
ORDER BY S.VRDOK, S.BRDOK
}
DetailBand1(TQRBand)=rbDetail[17]$16777215{00001}!^0000/0&1@psSolid«
PageFooterBand1(TQRBand)=rbPageFooter[24]$16777215{00001}!^0000/0&1@psSolid«
ColumnHeaderBand1(TQRBand)=rbColumnHeader[35]$16777215{00001}!^0000/0&1@psSolid«
PageHeaderBand1(TQRBand)=rbPageHeader[140]$16777215{000011}!^0000/0&1@psSolid«
SummaryBand1(TQRBand)=rbSummary[250]$16777215{000011}!frmIsporuka.SummaryBeforePrint^0000/0&1@psSolid«
QRGrFooter(TQRBand)=rbGroupFooter[30]$16777215{000011}!^0000/0&1@psSolid«
QRGRFooter2(TQRBand)=rbGroupFooter[27]${000001}!^0000/0&1@psSolid«
QRGroup1(TQRGroup)=QRGrFooter[20]#VRDOK$16777215{0000011}!^0000/0&1@psSolid«
QRGroup2(TQRGroup)=QRGRFooter2[20]#PPID${0000001}!^0000/0&1@psSolid«
dbtKupac(TQRDBText)=DetailBand1@32,1[211x15]Arial»8@7[fsBold]238#taLeftJustify${01101}qryStav%VRDOK!frmIsporuka.dbtPrint^0000/0&1@psSolid«
dbtNazivDok(TQRDBText)=DetailBand1@308,1[85x15]Arial»8@7[]1#taLeftJustify${00101}qryStav%NAZIVDOK!^0000/0&1@psSolid«
dbtBrojDok(TQRDBText)=DetailBand1@395,1[50x15]Arial»8@7[]1#taCenter${00101}qryStav%BRDOK!^0000/0&1@psSolid«
dbtBrStavki(TQRDBText)=DetailBand1@520,1[35x15]Arial»8@7[]1#taRightJustify${00101}qryStav%BRSTAVKI!^0000/0&1@psSolid«
expRBR(TQRExpr)=DetailBand1&@3,1[23x15]Arial»8@7[]1#taRightJustify$####{001001}COUNT!^0000/0&1@psSolid«
sysPage(TQRSysData)=PageFooterBand1@8,4[709x17]Arial»-2147483640@10[]1#taCenter$Strana {00001}qrsPageNumber!^0000/0&1@psSolid«
LinijaHeader(TQRShape)=ColumnHeaderBand1@6,30[715x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
lblKupac(TQRLabel)=ColumnHeaderBand1@32,13[150x17]Arial»8@8[]1#taLeftJustify${00101}Kupac / magacin!^0000/0&1@psSolid«
lblBrDok(TQRLabel)=ColumnHeaderBand1@395,13[50x17]Arial»8@8[]1#taCenter${00101}Broj dok.!^0000/0&1@psSolid«
lblUtovar(TQRLabel)=ColumnHeaderBand1@597,13[36x17]Arial»8@7[]1#taCenter${00101}Utovar!^0000/0&1@psSolid«
lblBrStavki(TQRLabel)=ColumnHeaderBand1@518,0[38x30]Arial»8@8[]1#taRightJustify${00101}Broj stavki!^0000/0&1@psSolid«
lblNazivDok(TQRLabel)=ColumnHeaderBand1@308,13[85x17]Arial»8@8[]1#taLeftJustify${00101}Vrsta dokumenta!^0000/0&1@psSolid«
lblNaslov(TQRLabel)=PageHeaderBand1@5,37[270x18]Arial Black»8@10[fsBold]1#taLeftJustify${00001}Specifikacija isporuke robe br.!^0000/0&1@psSolid«
dbtFirma(TQRDBText)=PageHeaderBand1@6,6[389x23]Arial»8@13[fsBold]238#taLeftJustify${00101}IBMastData.Firma%NAZIV!^0000/0&1@psSolid«
lblLinija(TQRLabel)=PageHeaderBand1@8,70[70x18]Arial»0@10[]0#taLeftJustify${00101}Linija:!^0000/0&1@psSolid«
dbtLinija(TQRDBText)=PageHeaderBand1@80,70[315x17]Arial»0@10[]238#taLeftJustify${00101}frmIsporuka.qryDokument%BRDOKIN!frmIsporuka.dbtPrint^0000/0&1@psSolid«
LinijaSummary(TQRShape)=SummaryBand1@8,1[715x5]&1@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
lblUkupno(TQRLabel)=SummaryBand1@118,8[100x17]Arial»8@10[fsBold]1#taRightJustify${00101}Ukupno:!^0000/0&1@psSolid«
dbtGrupaVrstaDok(TQRDBText)=QRGroup1@120,1[328x16]Arial»0@9[fsBold]0#taLeftJustify${00101}qryStav%NAZIVDOK!^0000/0&1@psSolid«
lblVrstaDok(TQRLabel)=QRGroup1@8,1[112x16]Arial»0@9[]0#taLeftJustify${00101}Vrsta dokumenta:!^0000/0&1@psSolid«
LinijaFooter(TQRShape)=QRGrFooter@59,1[533x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
dbtBrDok(TQRDBText)=PageHeaderBand1@280,39[75x16]Arial»@10[fsBold]1#taLeftJustify${00011}frmIsporuka.qryDokument%BRDOK!^0000/0&1@psSolid«
dbtIntBroj(TQRDBText)=PageHeaderBand1@360,39[90x16]Arial»@10[fsItalic]1#taLeftJustify${00010}frmIsporuka.qryDokument%INTBROJ!^0000/0&1@psSolid«
lblDatum(TQRLabel)=PageHeaderBand1@455,39[45x16]Arial»@10[]1#taLeftJustify${00011}Datum:!^0000/0&1@psSolid«
dbtDatum(TQRDBText)=PageHeaderBand1@505,39[70x16]Arial»@10[]#taLeftJustify${00011}frmIsporuka.qryDokument%DATUM!^0000/0&1@psSolid«
lblVozilo(TQRLabel)=PageHeaderBand1@8,88[70x18]Arial»0@10[]0#taLeftJustify${00101}Vozilo:!^0000/0&1@psSolid«
dbtVozilo(TQRDBText)=PageHeaderBand1@80,88[120x17]Arial»0@10[fsBold]0#taLeftJustify${00101}frmIsporuka.qryVV%REGISTRACIJA!^0000/0&1@psSolid«
lblVozaci(TQRLabel)=PageHeaderBand1@220,88[70x18]Arial»0@10[]0#taLeftJustify${00101}Vozac:!^0000/0&1@psSolid«
dbtVozac(TQRDBText)=PageHeaderBand1@292,88[250x17]Arial»0@10[fsBold]238#taLeftJustify${00101}frmIsporuka.qryVV%VOZACID!frmIsporuka.dbtPrint^0000/0&1@psSolid«
expBrojStavki(TQRExpr)=SummaryBand1&QRIsporukaRobe@520,8[35x16]Arial»@10[fsBold]#taRightJustify${000111}SUM(qryStav.BRSTAVKI)!^0000/0&1@psSolid«
dbtVrednost(TQRDBText)=DetailBand1@448,1[70x15]Arial»8@7[]1#taRightJustify$###,###,##0.00{00101}qryStav%SPAKOVANA_VREDNOST!^0000/0&1@psSolid«
lblVrednost(TQRLabel)=ColumnHeaderBand1@448,13[70x17]Arial»8@8[]1#taRightJustify${00101}Vrednost!^0000/0&1@psSolid«
expVrednost(TQRExpr)=SummaryBand1&QRIsporukaRobe@435,8[84x16]Arial»@10[fsBold]#taRightJustify$###,###,##0.00{000110}SUM(qryStav.SPAKOVANA_VREDNOST)!^0000/0&1@psSolid«
lblPocetakUtovara(TQRLabel)=SummaryBand1@16,69[120x16]Arial»8@10[]238#taRightJustify${00101}Početak utovara:!^0000/0&1@psSolid«
lblZavrsetakUtovara(TQRLabel)=SummaryBand1@16,94[120x16]Arial»8@10[]238#taRightJustify${00101}Završetak utovara:!^0000/0&1@psSolid«
lblPolazakVozila(TQRLabel)=SummaryBand1@16,119[120x16]Arial»8@10[]1#taRightJustify${00101}Polazak vozila:!^0000/0&1@psSolid«
lblPovratakVozila(TQRLabel)=SummaryBand1@16,144[120x16]Arial»8@10[]1#taRightJustify${00101}Povratak vozila:!^0000/0&1@psSolid«
lblStatusDatum(TQRLabel)=SummaryBand1@155,44[80x16]Arial»8@10[]1#taCenter${00101}Datum!^0000/0&1@psSolid«
lblStatusVreme(TQRLabel)=SummaryBand1@250,44[80x16]Arial»8@10[]1#taCenter${00101}Vreme!^0000/0&1@psSolid«
lblPocetnaKM(TQRLabel)=SummaryBand1@400,115[140x16]Arial»8@10[]238#taRightJustify${00101}Početna kilometraža:!^0000/0&1@psSolid«
lblZavrsnaKM(TQRLabel)=SummaryBand1@400,140[140x16]Arial»8@10[]238#taRightJustify${00101}Završna kilometraža:!^0000/0&1@psSolid«
dbtKM_Pocetak(TQRDBText)=SummaryBand1@555,115[70x16]Arial»@10[]1#taCenter$########{00011}frmIsporuka.qryDokument%POPUST1DANA!^0000/0&1@psSolid«
dbtKM_Kraj(TQRDBText)=SummaryBand1@555,140[70x16]Arial»@10[]1#taCenter$########{00011}frmIsporuka.qryDokument%POPUST2DANA!^0000/0&1@psSolid«
shpStatus(TQRShape)=SummaryBand1@145,62[200x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
shpStatus1(TQRShape)=SummaryBand1@145,88[200x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
shpStatus2(TQRShape)=SummaryBand1@145,112[200x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
shpStatus3(TQRShape)=SummaryBand1@145,138[200x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
shpStatus4(TQRShape)=SummaryBand1@145,162[200x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
shpStatus5(TQRShape)=SummaryBand1@143,64[4x100]&@#&$qrsVertLine{00011}!^0000/0&1@psSolid«
shpStatus51(TQRShape)=SummaryBand1@242,64[4x100]&@#&$qrsVertLine{00011}!^0000/0&1@psSolid«
shpStatus52(TQRShape)=SummaryBand1@343,64[4x100]&@#&$qrsVertLine{00011}!^0000/0&1@psSolid«
shpStatus6(TQRShape)=SummaryBand1@545,108[90x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
shpStatus61(TQRShape)=SummaryBand1@545,134[90x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
shpStatus62(TQRShape)=SummaryBand1@545,158[90x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
shpStatus521(TQRShape)=SummaryBand1@543,110[4x50]&@#&$qrsVertLine{00011}!^0000/0&1@psSolid«
shpStatus5211(TQRShape)=SummaryBand1@633,110[4x50]&@#&$qrsVertLine{00011}!^0000/0&1@psSolid«
lblPocUtoDatum(TQRLabel)=SummaryBand1@155,69[80x16]Arial»8@10[]1#taCenter${00100}!^0000/0&1@psSolid«
lblPocUtoVreme(TQRLabel)=SummaryBand1@250,69[80x16]Arial»8@10[]1#taCenter${00100}!^0000/0&1@psSolid«
lblKrajUtoDatum(TQRLabel)=SummaryBand1@155,94[80x16]Arial»8@10[]1#taCenter${00100}!^0000/0&1@psSolid«
lblPolazakDatum(TQRLabel)=SummaryBand1@155,119[80x16]Arial»8@10[]1#taCenter${00101}!^0000/0&1@psSolid«
lblPovratakDatum(TQRLabel)=SummaryBand1@155,144[80x16]Arial»8@10[]1#taCenter${00101}!^0000/0&1@psSolid«
lblKrajUtoVreme(TQRLabel)=SummaryBand1@250,94[80x16]Arial»8@10[]1#taCenter${00100}!^0000/0&1@psSolid«
lblPolazakVreme(TQRLabel)=SummaryBand1@250,119[80x16]Arial»8@10[]1#taCenter${00101}!^0000/0&1@psSolid«
lblPovratakVreme(TQRLabel)=SummaryBand1@250,144[80x16]Arial»8@10[]1#taCenter${00101}!^0000/0&1@psSolid«
lblBrPaketa(TQRLabel)=ColumnHeaderBand1@556,0[37x30]Arial»8@8[]1#taRightJustify${00101}Broj paketa!^0000/0&1@psSolid«
dbtBrPaketa(TQRDBText)=DetailBand1@556,1[35x15]Arial»8@7[]1#taRightJustify${00101}qryStav%BRPAKETA!^0000/0&1@psSolid«
expVrednost1(TQRExpr)=QRGrFooter&QRIsporukaRobe@435,5[84x16]Arial»@10[]#taRightJustify$###,###,##0.00{000111}SUM(qryStav.SPAKOVANA_VREDNOST)!^0000/0&1@psSolid«
expBrojStavki1(TQRExpr)=QRGrFooter&QRIsporukaRobe@520,5[35x16]Arial»@10[]#taRightJustify${000111}SUM(qryStav.BRSTAVKI)!^0000/0&1@psSolid«
LinijaHeader1(TQRShape)=DetailBand1@6,-3[715x3]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
expBrojPaketa(TQRExpr)=QRGrFooter&QRIsporukaRobe@556,5[35x16]Arial»@10[]#taRightJustify${000111}SUM(qryStav.BRPAKETA)!^0000/0&1@psSolid«
expBrojPaketa1(TQRExpr)=SummaryBand1&QRIsporukaRobe@556,8[35x16]Arial»@10[fsBold]#taRightJustify${000111}SUM(qryStav.BRPAKETA)!^0000/0&1@psSolid«
lblUkupno1(TQRLabel)=QRGrFooter@59,5[163x17]Arial»8@9[]1#taRightJustify${00101}Ukupno za vrstu dokumenta:!^0000/0&1@psSolid«
lblPopunjava(TQRLabel)=SummaryBand1@7,32[120x17]Arial»8@10[]1#taRightJustify${00101}Popunjava vozač!^0000/0&1@psSolid«
dbtEkspozitura(TQRDBText)=PageHeaderBand1@419,6[287x23]Arial»8@11[fsBold]238#taRightJustify${00101}IBMastData.Firma%EKSPOZITURA!^0000/0&1@psSolid«
LinijaFooter1(TQRShape)=QRGRFooter2@222,1[369x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
expVrednost2(TQRExpr)=QRGRFooter2&QRIsporukaRobe@435,5[84x16]Arial»@7[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStav.SPAKOVANA_VREDNOST)!^0000/0&1@psSolid«
expBrojStavki2(TQRExpr)=QRGRFooter2&QRIsporukaRobe@520,5[35x16]Arial»@7[]#taRightJustify${000111}SUM(qryStav.BRSTAVKI)!^0000/0&1@psSolid«
expBrojPaketa2(TQRExpr)=QRGRFooter2&QRIsporukaRobe@556,5[35x16]Arial»@7[]#taRightJustify${000111}SUM(qryStav.BRPAKETA)!^0000/0&1@psSolid«
shpStatus7(TQRShape)=SummaryBand1@264,216[200x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
lblVozac(TQRLabel)=SummaryBand1@266,222[198x16]Arial»8@10[]238#taCenter${00101}Vozač!^0000/0&1@psSolid«
shpStatus71(TQRShape)=SummaryBand1@34,216[200x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
lblRobuIzdao(TQRLabel)=SummaryBand1@34,222[198x16]Arial»8@10[]238#taCenter${00101}Robu izdao!^0000/0&1@psSolid«
dbtAdresa(TQRDBText)=QRGRFooter2@31,14[331x12]Arial»8@7[]238#taLeftJustify${01101}qryStav%VRDOK!frmIsporuka.dbtPrint^0000/0&1@psSolid«
dbtMesto(TQRDBText)=QRGRFooter2@31,1[90x12]Arial»8@7[]238#taLeftJustify${01101}qryStav%MESTONAZIV!^0000/0&1@psSolid«
lblDokument(TQRLabel)=ColumnHeaderBand1@635,13[44x17]Arial»8@7[]1#taCenter${00101}Dokument!^0000/0&1@psSolid«
lblIstovar(TQRLabel)=ColumnHeaderBand1@682,13[36x17]Arial»8@7[]1#taCenter${00101}Istovar!^0000/0&1@psSolid«
shpUtovar(TQRShape)=DetailBand1@606,0[19x16]&@#16777215&$qrsRectangle{00011}!^0000/16777215&1@psSolid«
shpDokument(TQRShape)=DetailBand1@649,0[19x16]&@#16777215&$qrsRectangle{00011}!^0000/16777215&1@psSolid«
shpIstovar(TQRShape)=DetailBand1@690,0[19x16]&@#16777215&$qrsRectangle{00011}!^0000/16777215&1@psSolid«
shpStatus72(TQRShape)=SummaryBand1@492,216[200x4]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
lblRobuPrimio(TQRLabel)=SummaryBand1@493,222[198x16]Arial»8@10[]238#taCenter${00101}Robu primio!^0000/0&1@psSolid«
lblNapomena(TQRLabel)=PageHeaderBand1@8,106[70x18]Arial»0@10[]0#taLeftJustify${00101}Napomena:!^0000/0&1@psSolid«
dbtNapomena(TQRDBText)=PageHeaderBand1@80,107[600x17]Arial»0@10[]0#taLeftJustify${00101}frmIsporuka.qryDokument%KUPAC!frmIsporuka.dbtPrint^0000/0&1@psSolid«
lblZaUplatu(TQRLabel)=ColumnHeaderBand1@244,13[63x17]Arial»8@8[]1#taRightJustify${00101}Za uplatu!^0000/0&1@psSolid«
dbtZaUplatu(TQRDBText)=DetailBand1@243,1[60x15]Arial»8@7[]1#taRightJustify${00101}qryStav%ZA_UPLATU!^0000/0&1@psSolid«
expZaUplatu2(TQRExpr)=QRGRFooter2&QRIsporukaRobe@223,5[80x12]Arial»@7[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStav.ZA_UPLATU)!^0000/0&1@psSolid«
expZaUplatu1(TQRExpr)=QRGrFooter&QRIsporukaRobe@223,5[80x16]Arial»@10[]#taRightJustify$###,###,##0.00{000111}SUM(qryStav.ZA_UPLATU)!^0000/0&1@psSolid«
expZaUplatu(TQRExpr)=SummaryBand1&QRIsporukaRobe@223,8[80x16]Arial»@10[fsBold]#taRightJustify$###,###,##0.00{000111}SUM(qryStav.ZA_UPLATU)!^0000/0&1@psSolid«