//ReportID: 10201
//TipeID: 11
//LastChanged: 26.12.2013 15:36:10
//Description: Stampa reversa uz radni nalog
//LinkRepID: 640
//BrojKolona: 0
//BrojRedova: 0
QRRNRevers(TQuickRep)=qryDodPodaci&poPortrait@Custom[800x2970,50x5,20x5]Arial»@10[]#0{1}ID kartica!|<frmIsporuka.QuickRepBeforePrint>\?/^0000/0&1@psSolid«
qryRN(TpFIBDataSet)=504[IBMastData.FIBDatabase]{010}
{
Select D.BRDOK, D.INTBROJ, D.DATUM, D.SAT_START, V.PPID AS VLASNIK_PPID, 
      P.NAZIV AS VLASNIK, K.KOMENTAR
from DOKUMENT D
LEFT JOIN VOZILA V ON D.AKBRDOK = V.VOZILOID
LEFT JOIN PARTNER P ON D.PPID = P.PPID
LEFT JOIN KOMENTARI K ON K.VRDOK = D.VRDOK and K.BRDOK = D.BRDOK
where
  D.VRDOK = :VRDOK and
  D.BRDOK = :BRDOK
}
qryDodPodaci(TpFIBDataSet)=507[IBMastData.FIBDatabase]{010}
{
SELECT ED.VRDOK, ED.BRDOK, ED.EDID, case when ((EDS.VUID <> 2) or (ED.VREDNOST <> '1')) then ED.VREDNOST else '' end as Vrednost, ED.REDOSLED, EDS.NAZIV, EDS.VUID
FROM EXTRA_DATA ED
  LEFT JOIN EXTRA_DATA_SIF EDS ON ED.VRDOK = EDS.VRDOK AND ED.EDID = EDS.EDID
WHERE ED.VRDOK = :VRDOK AND ED.BRDOK = :BRDOK and (((EDS.VUID <> 2) and (ED.VREDNOST <> '') and (ED.VREDNOST is not null)) or (ED.VREDNOST = '1'))
ORDER BY ED.REDOSLED
}
TQRBand(TQRBand)=rbDetail[180]${000011}!^0000/0&1@psSolid«
SubDetail(TQRSubDetail)=,&QRRNRevers@qryDodPodaci[20]${00000011}%!^0000/0&1@psSolid«
lblNaslov(TQRLabel)=TQRBand@6,71[150x18]Arial»0@11[fsBold]1#taLeftJustify${00111}Radni nalog broj!^0000/12632256&1@psSolid«
dbtBrDok(TQRDBText)=TQRBand@158,71[88x18]Arial»-16777208@11[fsBold]1#taCenter${10111}frmDocRadniNalog.qryDokument%BRDOK!frmDocRadniNalog.dbtBrojPrint^0000/12632256&1@psSolid«
dbtVlasnik(TQRDBText)=TQRBand@6,108[261x15]Arial»-16777208@10[fsBold]238#taLeftJustify${00101}frmDocRadniNalog.qryDokument%VLASNIK!^0000/0&1@psSolid«
lblVlasnik(TQRLabel)=TQRBand@6,92[250x15]Arial»-16777208@10[]1#taLeftJustify${00101}Klijent:!^0000/0&1@psSolid«
lblDatumPrijema(TQRLabel)=TQRBand@6,124[110x15]Arial»-16777208@10[]1#taLeftJustify${00101}Datum ulaska:!^0000/0&1@psSolid«
dbtDatumPrijema(TQRDBText)=TQRBand@121,124[90x15]Arial»-16777208@10[fsBold]1#taLeftJustify${00101}frmDocRadniNalog.qryDokument%DATUM!^0000/0&1@psSolid«
lblVremePrijema(TQRLabel)=TQRBand@6,140[110x15]Arial»-16777208@10[]1#taLeftJustify${00101}Vreme ulaska:!^0000/0&1@psSolid«
dbtVremePrijema1(TQRDBText)=TQRBand@118,140[90x15]Arial»-16777208@10[fsBold]1#taLeftJustify${00101}frmDocRadniNalog.qryDokument%SAT_START!^0000/0&1@psSolid«
dbtFirma(TQRDBText)=TQRBand@6,19[200x19]Arial Black»0@10[fsBold]0#taLeftJustify${00101}IBMastData.Firma%NAZIV!^0000/0&1@psSolid«
New_TQRLabel(TQRLabel)=TQRBand@6,160[70x16]#taLeftJustify${00011}DONETO:!^0000/0&1@psSolid«
New_TQRShape(TQRShape)=TQRBand@3,176[258x3]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
dbtNaziv(TQRDBText)=SubDetail@6,0[157x16]#taLeftJustify${00011}qryDodPodaci%NAZIV!^0000/0&1@psSolid«
dbtVrednost(TQRDBText)=SubDetail@170,0[88x16]#taCenter${00011}qryDodPodaci%VREDNOST!^0000/0&1@psSolid«
New_TQRShape1(TQRShape)=SubDetail@3,16[258x3]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
dbtTelefon(TQRDBText)=TQRBand@6,38[200x17]Arial»0@9[fsBold]0#taLeftJustify${01101}IBMastData.Firma%TELEFON!^0000/0&1@psSolid«