<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Name="" Version="3.21" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="2047" PreviewOptions.Zoom="1" PrintOptions.Printer="Pedvolen?ReportOptions.CreateDate=" ReportOptions.CreateDate="38760,4079629514" ReportOptions.Description.Text="" ReportOptions.LastChange="43112,4554778704" ScriptLanguage="PascalScript" ScriptText.Text="var&#13;&#10;  celkem : real;&#13;&#10;  celkemBezDPH, celkemDPH, celkemPocet : real;&#13;&#10;  opravky : real;&#13;&#10;  sqlstr, tfp : string;&#13;&#10;&#13;&#10;function Date2DBStr(d : TDateTime) : string;&#13;&#10;var&#13;&#10;  delimitend : string;&#13;&#10;  day, mon, year, hour, minutes, seconds : word;&#13;&#10;begin&#13;&#10;  delimitend := '.';&#13;&#10;  DecodeDate(d,year,mon,day);&#13;&#10;  if d&#62;0 then&#13;&#10;    result:=IntToStr(day)+delimitend+IntToStr(mon)+delimitend+IntToStr(year)&#13;&#10;  else&#13;&#10;    result:='NULL';&#13;&#10;end;&#13;&#10;&#13;&#10;function Date2DBStrUvozovky(d : TDateTime) : string;&#13;&#10;begin&#13;&#10;  if d&#62;0 then&#13;&#10;    result:=''''+Date2DBStr(d)+''''&#13;&#10;  else&#13;&#10;    result:=Date2DBStr(d);&#13;&#10;end;&#13;&#10;&#13;&#10;&#13;&#10;procedure MasterData1OnAfterPrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;end;&#13;&#10;&#13;&#10;&#13;&#10;procedure GroupHeader1OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  celkem := 0;&#13;&#10;  opravky := 0;&#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;  tfp := &#60;frxDBDatasetInits.&#34;fps_tfp&#34;&#62;;&#13;&#10;&#13;&#10;  sqlstr := 'select k.*, a.nazev from ATIS.DejZobrazeniKontrolySplatnosti(' + tfp + ') k LEFT JOIN aasezsub a ON k.idaasezsub=a.idaasezsub';&#13;&#10;&#13;&#10;  AdoQuery1.CommandTimeout := 500;&#13;&#10;  AdoQuery1.SQL.Text := sqlstr;&#13;&#10;  AdoQuery1.Open;&#13;&#10;&#13;&#10;  celkem := 0;&#13;&#10;  opravky := 0;&#13;&#10;&#13;&#10;end." PropData="044C65667403C00003546F70021008446174617365747301010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3C00000020446174615365743D22667278444244617461536574496E6974732220446174615365744E616D653D22667278444244617461536574496E6974732200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C2C00000020446174615365743D2241444F5175657279312220446174615365744E616D653D2241444F5175657279312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D22667278444244617461736574312200010C3400000020446174615365743D22667278444244617461736574312220446174615365744E616D653D2266727844424461746173657431220000095661726961626C657301010C0A000000204E616D653D2220682200010C21000000204E616D653D2274697374656D222056616C75653D2233312E31322E323030352200010C22000000204E616D653D22706F63617465636E6973746176222056616C75653D22353730302200010C25000000204E616D653D22646174706F6373746176222056616C75653D2233312E31322E32303033220000055374796C650100">
  <TfrxReportPage Name="Page1" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="95" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxReportTitle Name="ReportTitle1" Height="120,94496" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="Memo32" Left="215,43321" Top="37,7953" Width="291,02381" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" HAlign="haCenter" ParentFont="False" VAlign="vaBottom" Text="Příjem: [frxDBDataSetInits.&#34;fps_tfp&#34;]"/>
      <TfrxMemoView Name="Memo13" Align="baCenter" Left="209,763915" Top="0" Width="298,58287" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" HAlign="haCenter" ParentFont="False" VAlign="vaBottom" Text="FPDF - Kontrola opravných předpisů"/>
      <TfrxMemoView Name="Memo15" Left="3,77953" Top="0" Width="207,87415" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" ParentFont="False" VAlign="vaBottom" Text="IS TIS - TOPSPIN Solutions s.r.o."/>
      <TfrxSysMemoView Name="SysMemo1" Left="631,18151" Top="71,81107" Width="83,14966" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" VAlign="vaBottom" Text="[DATE]"/>
      <TfrxLineView Name="Line1" Left="3,77953" Top="94,48825" Width="710,55164" Height="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo16" Left="548,03185" Top="0" Width="60,47248" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" ParentFont="False" VAlign="vaBottom" Text="Stránka:"/>
      <TfrxMemoView Name="Memo17" Left="548,03185" Top="41,57483" Width="79,37013" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" ParentFont="False" VAlign="vaBottom" Text="Identifikace:"/>
      <TfrxMemoView Name="Memo33" Left="548,03185" Top="56,69295" Width="79,37013" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" ParentFont="False" VAlign="vaBottom" Text="Verze:"/>
      <TfrxMemoView Name="Memo34" Left="548,03185" Top="71,81107" Width="79,37013" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" ParentFont="False" VAlign="vaBottom" Text="Datum:"/>
      <TfrxMemoView Name="Memo35" Left="631,18151" Top="56,69295" Width="83,14966" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" VAlign="vaBottom" Text="28012014"/>
      <TfrxMemoView Name="Memo36" Left="631,18151" Top="41,57483" Width="83,14966" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" VAlign="vaBottom" Text="aaopr014"/>
      <TfrxMemoView Name="Memo37" Left="631,18151" Top="0" Width="83,14966" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" VAlign="vaBottom" Text="[Page]"/>
      <TfrxMemoView Name="Memo38" Left="3,77953" Top="26,45671" Width="207,87415" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" ParentFont="False" VAlign="vaBottom" Text="[frxDBDataSetInits.&#34;org_nazev&#34;]"/>
      <TfrxMemoView Name="Memo39" Left="3,77953" Top="41,57483" Width="207,87415" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" ParentFont="False" VAlign="vaBottom" Text="[frxDBDataSetInits.&#34;org_ulicecpopcor&#34;]"/>
      <TfrxMemoView Name="Memo40" Left="3,77953" Top="56,69295" Width="207,87415" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" ParentFont="False" VAlign="vaBottom" Text="[frxDBDataSetInits.&#34;org_pscmisto&#34;]"/>
      <TfrxMemoView Name="Memo41" Left="3,77953" Top="71,81107" Width="207,87415" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" ParentFont="False" VAlign="vaBottom" Text="IČ: [frxDBDataSetInits.&#34;uct_ic&#34;]"/>
      <TfrxMemoView Name="Memo42" Left="215,43321" Top="56,69295" Width="291,02381" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="tahoma" Font.Style="0" HAlign="haCenter" ParentFont="False" VAlign="vaBottom" Text="Výpočet: [frxDBDataSetInits.&#34;fps_od&#34;]-[frxDBDataSetInits.&#34;fps_do&#34;]"/>
      <TfrxMemoView Name="Memo22" Align="baCenter" Left="209,763915" Top="15,11812" Width="298,58287" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="tahoma" Font.Style="0" HAlign="haCenter" ParentFont="False" VAlign="vaBottom" Text="..."/>
      <TfrxMemoView Name="Memo1" Left="3,77953" Top="102,04731" Width="706,77186591" Height="15,11812" DataSet="frxDBDataset1" DataSetName="frxDBDataset1" Font.Charset="1" Font.Color="-2147483640" Font.Height="-12" Font.Name="tahoma" Font.Style="0" HAlign="haCenter" ParentFont="False" Text="Sestava zobrazuje poplatníky, kteří mají pravděpodobně v daném dni nastaven špatný datum splatnosti opravného předpisu."/>
    </TfrxReportTitle>
    <TfrxPageHeader Name="PageHeader1" Height="26,45671" Left="0" Top="162,51979" Width="718,1107">
      <TfrxShapeView Name="Shape2" Left="3,77953" Top="22,67718" Width="710,55164" Height="0"/>
      <TfrxMemoView Name="Memo9" Left="3,77953" Top="3,77953" Width="200,31484591" Height="15,11812" DataSet="frxDBDataset1" DataSetName="frxDBDataset1" Font.Charset="1" Font.Color="-2147483640" Font.Height="-12" Font.Name="tahoma" Font.Style="0" ParentFont="False" Text="Název poplatníka"/>
      <TfrxMemoView Name="Memo18" Left="302,3624" Top="3,77953" Width="71,81107" Height="15,11812" DataSet="frxDBDataset1" DataSetName="frxDBDataset1" Font.Charset="1" Font.Color="-2147483640" Font.Height="-12" Font.Name="tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Datum spl."/>
      <TfrxMemoView Name="Memo4" Left="207,87415" Top="3,77953" Width="83,14966" Height="15,11812" DataSet="frxDBDataset1" DataSetName="frxDBDataset1" Font.Charset="1" Font.Color="-2147483640" Font.Height="-12" Font.Name="tahoma" Font.Style="0" ParentFont="False" Text="VS"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MasterData1" Height="15,11812" Left="0" Top="249,44898" Width="718,1107" OnAfterPrint="MasterData1OnAfterPrint" OnBeforePrint="MasterData1OnBeforePrint" ColumnWidth="0" ColumnGap="0" DataSet="ADOQuery1" DataSetName="ADOQuery1" RowCount="0" OnMasterDetail="MasterData1OnMasterDetail">
      <TfrxMemoView Name="Memo2" Left="3,77953" Top="0" Width="188,97625591" Height="15,11812" DataSet="frxDBDataset1" DataSetName="frxDBDataset1" Font.Charset="1" Font.Color="-2147483640" Font.Height="-12" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[AdoQuery1.&#34;nazev&#34;]"/>
      <TfrxMemoView Name="Memo19" Left="306,14193" Top="0" Width="68,03154" Height="15,11812" DataSet="frxDBDataset1" DataSetName="frxDBDataset1" Font.Charset="1" Font.Color="-2147483640" Font.Height="-12" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[AdoQuery1.&#34;datspl&#34;]"/>
      <TfrxMemoView Name="Memo7" Left="207,87415" Top="0" Width="86,92919" Height="15,11812" DataSet="frxDBDataset1" DataSetName="frxDBDataset1" Font.Charset="1" Font.Color="-2147483640" Font.Height="-12" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[AdoQuery1.&#34;vs&#34;]"/>
    </TfrxMasterData>
    <TfrxADOQuery Name="ADOQuery1" UserName="ADOQuery1" CloseDataSource="True" FieldAliases.Text="" SQL.Text="SELECT * FROM aasezfps f LEFT JOIN aasezsub s ON f.idaasezsub=s.idaasezsub LEFT JOIN ATIS.DejZobrazeniUcetnichOpravek(GetDate(),1337) o ON f.idaasezfps=o.idaasezfps WHERE StariDluhu &#62; 0 AND 1=2" CommandTimeout="30" PropData="0A506172616D65746572730100"/>
    <TfrxMemoView Name="Memo5" Left="7,55906" Top="691,65399" Width="309,92146" Height="170,07885" Visible="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="$infoses='aaopr014';&#13;&#10;$infotem='uct';&#13;&#10;$infotyp='fr3';&#13;&#10;$infovstup='fps001';&#13;&#10;$infovystup='aaopr014.pdf';&#13;&#10;$infonazev='FPDF - Kontrola splatnosti předpisů';&#13;&#10;$infodatum='20140128';&#13;&#10;$infoautor='TOPSPIN Solutions - Martin Matoušek';&#13;&#10;$infopopis='TIS - Kontrola splatnosti předpisů';"/>
  </TfrxReportPage>
</TfrxReport>
