<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Version="6.2.1" DotMatrixReport="False" EngineOptions.SilentMode="True" EngineOptions.NewSilentMode="simSilent" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="41546.6611873611" ReportOptions.Description.Text="" ReportOptions.LastChange="43550.9398230787" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;procedure DialogPage1OnActivate(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  date1.date:=now-30 ;&#13;&#10;  date2.date:=now ;&#13;&#10;&#13;&#10;  qry_stock.close ;&#13;&#10;  qry_stock.open ;&#13;&#10;&#13;&#10;  cbb_stock.keyvalue:=&#60;MY_STOCK_CODE&#62; ;&#13;&#10;&#13;&#10;end;&#13;&#10;&#13;&#10;procedure DialogPage1OnShow(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;&#13;&#10;end;&#13;&#10;&#13;&#10;&#13;&#10;&#13;&#10;procedure OnClick(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;&#13;&#10;end;&#13;&#10;&#13;&#10;procedure cbb_stockOnClick(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;&#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="qry_stock" DataSetName="stock"/>
    <item DataSet="qry_rp" DataSetName="rp"/>
  </Datasets>
  <Variables>
    <item Name="MY_STOCK_CODE"/>
    <item Name="MY_STOCK_NAME"/>
  </Variables>
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxUniDACQuery Name="qry_stock" UserName="stock" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="select * from DEPT_ID where (HIDE='' or HIDE is null or HIDE='N')&#13;&#10;and DEPT_TYPE=1                                   " SpecificOptions.Text="" PropData="05704C65667402620470546F7003A4000A506172616D65746572730100"/>
    <TfrxUniDACQuery Name="qry_rp" UserName="rp" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="{IF SQLSERVER}    &#13;&#10;&#13;&#10;select  rp.BUY_METHOD ,d.BUYMET_DES , count(distinct isnull(rp.POX,'1')) as POX ,&#13;&#10;count( rp.item_ED) as item_ED ,count( rp.item_NED) as item_NED , sum( rp.amt_ED ) as amt_ED ,&#13;&#10;sum( rp.amt_NED ) as amt_NED,&#13;&#10;sum( rp.amt_All ) as amt_All           &#13;&#10;from                          &#13;&#10;(&#13;&#10;select  c.PO_NO as POX,&#13;&#10;c.BUY_METHOD,                &#13;&#10;case when  c.NLEM = 'ED'  then c.TRADE_CODE  else NULL end  as 'item_ED',&#13;&#10;case when c.NLEM = 'NED' then c.TRADE_CODE  else NULL end  as 'item_NED',&#13;&#10;case when c.NLEM = 'ED'  then c.COST else 0 end as 'amt_ED',&#13;&#10;case when c.NLEM = 'NED' then c.COST else 0 end as 'amt_NED',&#13;&#10;c.COST as amt_All                                   &#13;&#10;from &#13;&#10;(&#13;&#10;select m.REF_NO as PO_NO,dbo.IS_ED(g.IS_ED) as NLEM,c.TRADE_CODE,m.BUY_METHOD,c.COST&#13;&#10;from MS_PO m (NOLOCK)&#13;&#10;left join MS_PO_C c (NOLOCK) on (c.PO_NO=m.PO_NO and c.REV_FLAG='N')                                                                                                            &#13;&#10;left join COMPANY v (NOLOCK) on (v.COMPANY_CODE=m.VENDOR_CODE)   &#13;&#10;left JOIN PACK_RATIO p on (p.PACK_CODE=c.PACK_CODE)&#13;&#10;left join SALE_UNIT s1 (NOLOCK) on (s1.SU_ID=p.SUBPACK_UNIT)     &#13;&#10;left join SALE_UNIT s2 (NOLOCK) on (s2.SU_ID=p.PACK_UNIT)     &#13;&#10;left join DRUG_GN g (NOLOCK) on (c.WORKING_CODE = g.WORKING_CODE)                                                                                                                              &#13;&#10;where m.REQ_APP_DATE between :date1  and  :date2 and m.DEPT_ID=:stock&#13;&#10;and c.REV_FLAG='N'&#13;&#10;          &#13;&#10;) as  c&#13;&#10;where  c.NLEM in ('ED', 'NED')                     &#13;&#10;) as rp&#13;&#10;left join BUYMETHOD d (nolock) on d.BUYMET_CODE = rp.BUY_METHOD    &#13;&#10;group by  rp.BUY_METHOD , d.BUYMET_DES    &#13;&#10;order by  convert(int,rp.BUY_METHOD)&#13;&#10;&#13;&#10;{ELSE}&#13;&#10;&#13;&#10;select  rp.BUY_METHOD ,d.BUYMET_DES , count(distinct ifnull(rp.POX,'1')) as POX ,&#13;&#10;count( rp.item_ED) as item_ED ,count( rp.item_NED) as item_NED , sum( rp.amt_ED ) as amt_ED ,&#13;&#10;sum( rp.amt_NED ) as amt_NED,&#13;&#10;sum( rp.amt_All ) as amt_All           &#13;&#10;from                          &#13;&#10;(&#13;&#10;select  c.PO_NO as POX,&#13;&#10;c.BUY_METHOD,                &#13;&#10;case when  c.NLEM = 'ED'  then c.TRADE_CODE  else NULL end  as 'item_ED',&#13;&#10;case when c.NLEM = 'NED' then c.TRADE_CODE  else NULL end  as 'item_NED',&#13;&#10;case when c.NLEM = 'ED'  then c.COST else 0 end as 'amt_ED',&#13;&#10;case when c.NLEM = 'NED' then c.COST else 0 end as 'amt_NED',&#13;&#10;c.COST as amt_All                                   &#13;&#10;from &#13;&#10;(&#13;&#10;select m.REF_NO as PO_NO,IS_ED(g.IS_ED) as NLEM,c.TRADE_CODE,m.BUY_METHOD,c.COST&#13;&#10;from MS_PO m&#13;&#10;left join MS_PO_C c on (c.PO_NO=m.PO_NO and c.REV_FLAG='N')                                                                                                            &#13;&#10;left join COMPANY v on (v.COMPANY_CODE=m.VENDOR_CODE)   &#13;&#10;left JOIN PACK_RATIO p on (p.PACK_CODE=c.PACK_CODE)&#13;&#10;left join SALE_UNIT s1 on (s1.SU_ID=p.SUBPACK_UNIT)     &#13;&#10;left join SALE_UNIT s2 on (s2.SU_ID=p.PACK_UNIT)     &#13;&#10;left join DRUG_GN g on (c.WORKING_CODE = g.WORKING_CODE)                                                                                                                              &#13;&#10;where m.REQ_APP_DATE between :date1  and  :date2 and m.DEPT_ID=:stock&#13;&#10;and c.REV_FLAG='N'&#13;&#10;          &#13;&#10;) as  c&#13;&#10;where  c.NLEM in ('ED', 'NED')                     &#13;&#10;) as rp&#13;&#10;left join BUYMETHOD d on d.BUYMET_CODE = rp.BUY_METHOD    &#13;&#10;group by  rp.BUY_METHOD , d.BUYMET_DES    &#13;&#10;order by  convert(int,rp.BUY_METHOD)        &#13;&#10;&#13;&#10;&#13;&#10;{ENDIF}      &#13;&#10;          &#13;&#10;  " SpecificOptions.Text="" PropData="05704C656674025E0470546F70024C0A506172616D657465727301010C54000000204E616D653D226461746531222044617461547970653D226674537472696E67222045787072657373696F6E3D22466F726D61744461746554696D652827595959596D6D6464272C64617465312E64617465292200010C54000000204E616D653D226461746532222044617461547970653D226674537472696E67222045787072657373696F6E3D22466F726D61744461746554696D652827595959596D6D6464272C64617465322E64617465292200010C41000000204E616D653D2273746F636B222044617461547970653D226674537472696E67222045787072657373696F6E3D226362625F73746F636B2E6B657976616C75652200010C54000000204E616D653D226461746531222044617461547970653D226674537472696E67222045787072657373696F6E3D22466F726D61744461746554696D652827595959596D6D6464272C64617465312E64617465292200010C54000000204E616D653D226461746532222044617461547970653D226674537472696E67222045787072657373696F6E3D22466F726D61744461746554696D652827595959596D6D6464272C64617465322E64617465292200010C41000000204E616D653D2273746F636B222044617461547970653D226674537472696E67222045787072657373696F6E3D226362625F73746F636B2E6B657976616C7565220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" Frame.Typ="0" HGuides.Text="" VGuides.Text="">
    <TfrxReportTitle Name="ReportTitle1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="146.56782111" Left="0" Top="18.89765" Width="718.1107">
      <TfrxMemoView Name="Memo2" AllowVectorExport="True" Left="-16.89765" Top="3.77953" Width="714.33117" Height="34.01577" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="สรุปรายงานขอซื้อแยกตามประเภท ED/NED"/>
      <TfrxLineView Name="Line1" AllowVectorExport="True" Left="2.77953" Top="96.25201" Width="714.33117" Height="0" Color="0" Frame.Color="12632256" Frame.Typ="0" Frame.Width="0.5" Diagonal="True"/>
      <TfrxLineView Name="Line2" AllowVectorExport="True" Left="1.77953" Top="145.92919" Width="714.33117" Height="0" Color="0" Frame.Color="12632256" Frame.Typ="0" Frame.Width="0.5" Diagonal="True"/>
      <TfrxMemoView Name="Memo4" AllowVectorExport="True" Left="49.81107" Top="108.47248" Width="56.69295" Height="22.67718" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="วิธีจัดซื้อ"/>
      <TfrxMemoView Name="Memo6" AllowVectorExport="True" Left="323.01608" Top="96.25201" Width="79.37013" Height="22.67718" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="จำนวนรายการ"/>
      <TfrxMemoView Name="Memo7" AllowVectorExport="True" Left="547.5201" Top="96.47248" Width="79.37013" Height="26.45671" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="มูลค่า"/>
      <TfrxMemoView Name="Memo8" AllowVectorExport="True" Left="231.46475" Top="107.47248" Width="68.03154" Height="22.67718" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="จน.ใบซื้อ"/>
      <TfrxMemoView Name="Memo3" AllowVectorExport="True" Left="1.77953" Top="63.45671" Width="714.33117" Height="26.45671" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="ตั้งแต่วันที่ [formatdatetime('dd/mm/YYYY',date1.date)] ถึงวันที่  [formatdatetime('dd/mm/YYYY',date2.date)] "/>
      <TfrxMemoView Name="Memo19" AllowVectorExport="True" Left="311.66666667" Top="119.32457222" Width="37.14790778" Height="22.67718" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="ED"/>
      <TfrxMemoView Name="Memo20" AllowVectorExport="True" Left="453.66666667" Top="120.21346111" Width="37.14790778" Height="22.67718" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="ED"/>
      <TfrxMemoView Name="Memo21" AllowVectorExport="True" Left="377.22222222" Top="119.10235" Width="37.14790778" Height="22.67718" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="NED"/>
      <TfrxMemoView Name="Memo22" AllowVectorExport="True" Left="547.44444444" Top="120.21346111" Width="44.70696778" Height="22.67718" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="NED"/>
      <TfrxLineView Name="Line4" AllowVectorExport="True" Left="303.7483" Top="122.04731" Width="124.72449" Height="0" Color="0" Frame.Color="12632256" Frame.Typ="0" Frame.Width="0.5" Diagonal="True"/>
      <TfrxLineView Name="Line5" AllowVectorExport="True" Left="448.59091" Top="122.26778" Width="268.34663" Height="0" Color="0" Frame.Color="12632256" Frame.Typ="0" Frame.Width="0.5" Diagonal="True"/>
      <TfrxMemoView Name="Memo25" AllowVectorExport="True" Left="646.54545455" Top="122.10235" Width="40.92743778" Height="22.67718" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="รวม"/>
      <TfrxMemoView Name="Memo5" AllowVectorExport="True" Left="1" Top="30.7953" Width="714.33117" Height="26.45671" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[cbb_stock.text]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
    </TfrxReportTitle>
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="30.23624" Left="0" Top="226.7718" Width="718.1107" ColumnWidth="0" ColumnGap="0" DataSet="qry_rp" DataSetName="rp" RowCount="0">
      <TfrxMemoView Name="inv_md_cQTY_ON_HAND" AllowVectorExport="True" Left="198.5671" Top="0.77953" Width="79.37013" Height="26.45671" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[rp.&#34;POX&#34;]"/>
      <TfrxMemoView Name="inv_md_cTRADE_NAME" AllowVectorExport="True" Left="2.77953" Top="0.77953" Width="188.9765" Height="26.45671" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Line#]. [rp.&#34;BUYMET_DES&#34;]"/>
      <TfrxMemoView Name="Memo9" AllowVectorExport="True" Left="300.20501" Top="2" Width="52.91342" Height="26.45671" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[rp.&#34;item_ED&#34;]"/>
      <TfrxMemoView Name="Memo17" AllowVectorExport="True" Left="365.01051333" Top="2.35858556" Width="56.69295" Height="26.45671" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[rp.&#34;item_NED&#34;]"/>
      <TfrxMemoView Name="Memo10" AllowVectorExport="True" Left="437.05287667" Top="1.33333333" Width="86.92919" Height="26.45671" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[rp.&#34;amt_ED&#34;]"/>
      <TfrxMemoView Name="Memo23" AllowVectorExport="True" Left="522.23232323" Top="1.26592424" Width="94.34508364" Height="26.45671" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[rp.&#34;amt_NED&#34;]"/>
      <TfrxMemoView Name="Memo26" AllowVectorExport="True" Left="620" Top="1.12585" Width="98.12461364" Height="26.45671" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[rp.&#34;amt_All&#34;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="PageFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22.67718" Left="0" Top="498.89796" Width="718.1107">
      <TfrxMemoView Name="Memo1" AllowVectorExport="True" Left="642.5201" Top="0" Width="75.5906" Height="18.89765" Frame.Typ="0" HAlign="haRight" Text="[Page#]"/>
    </TfrxPageFooter>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="158.74026" Left="0" Top="317.48052" Width="718.1107">
      <TfrxMemoView Name="Memo12" AllowVectorExport="True" Left="425.71779111" Top="10.22222222" Width="90.70872" Height="30.23624" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;rp.&#34;amt_ED&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo13" AllowVectorExport="True" Left="296.08689" Top="10" Width="56.69295" Height="26.45671" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[SUM(&#60;rp.&#34;item_ED&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo15" AllowVectorExport="True" Left="180.54916545" Top="8.90909091" Width="94.48825" Height="26.45671" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;rp.&#34;POX&#34;&#62;,MasterData1)]"/>
      <TfrxLineView Name="Line3" AllowVectorExport="True" Left="3.77953" Top="5.77953" Width="710.55164" Height="0" Color="0" Frame.Color="12632256" Frame.Typ="0" Frame.Width="0.5" Diagonal="True"/>
      <TfrxMemoView Name="Memo16" AllowVectorExport="True" Left="73.72449" Top="11.55906" Width="56.69295" Height="22.67718" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="รวม"/>
      <TfrxMemoView Name="Memo18" AllowVectorExport="True" Left="360.01051333" Top="10.42764333" Width="60.47248" Height="26.45671" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[SUM(&#60;rp.&#34;item_NED&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo24" AllowVectorExport="True" Left="515.77777778" Top="10.40486444" Width="105.82684" Height="30.23624" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;rp.&#34;amt_NED&#34;&#62;,MasterData1)]"/>
      <TfrxLineView Name="Line6" AllowVectorExport="True" Left="3.77953" Top="42.57483" Width="710.55164" Height="0" Color="0" Frame.Color="12632256" Frame.Typ="0" Frame.Width="0.5" Diagonal="True"/>
      <TfrxMemoView Name="Memo27" AllowVectorExport="True" Left="620.54545455" Top="10.2647902" Width="98.26778" Height="30.23624" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;rp.&#34;amt_All&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo11" AllowVectorExport="True" Left="598.16574" Top="116.16543" Width="102.04731" Height="30.23624" Visible="False" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;rp.&#34;amt_NED&#34;&#62;,MasterData1) + SUM(&#60;rp.&#34;amt_ED&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo28" AllowVectorExport="True" Left="457.32313" Top="47.37013" Width="257.00804" Height="26.45671" Font.Charset="1" Font.Color="16711680" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text=" ED : NED  = [formatfloat('#.00',SUM(&#60;rp.&#34;amt_ED&#34;&#62;,MasterData1)*100/SUM(&#60;rp.&#34;amt_All&#34;&#62;,MasterData1))] : [formatfloat('#.00',SUM(&#60;rp.&#34;amt_NED&#34;&#62;,MasterData1)*100/SUM(&#60;rp.&#34;amt_All&#34;&#62;,MasterData1))]">
        <Formats>
          <item FormatStr="%2.2n" Kind="fkNumeric"/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo29" AllowVectorExport="True" Left="7.55906" Top="79.37013" Width="695.43352" Height="30.23624" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="หมายเหตุ  เฉพาะเวชภัณฑ์ยา ไม่รวมวัสดุทางการแพทย์"/>
    </TfrxReportSummary>
  </TfrxReportPage>
  <TfrxDialogPage Name="DialogPage1" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Arial" Font.Style="0" Caption="§ҹͫ¡ ED/NED" DoubleBuffered="False" Height="318" ClientHeight="280" Left="371" Top="208" Width="533" Scaled="True" ClientWidth="517" OnActivate="DialogPage1OnActivate">
    <TfrxDateEditControl Name="date1" Left="168" Top="70" Width="97" Height="25" ShowHint="True" Color="-16777211" Date="41559.6971358681" Time="41559.6971358681" WeekNumbers="False"/>
    <TfrxDateEditControl Name="date2" Left="336" Top="70" Width="101" Height="25" ShowHint="True" Color="-16777211" Date="41559.6971358681" Time="41559.6971358681" WeekNumbers="False"/>
    <TfrxBitBtnControl Name="" Left="220" Top="200" Width="87" Height="33" Font.Charset="0" Font.Color="-16777208" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" ShowHint="True" Glyph.PropData="04446174610AE2010000DE010000424DDE01000000000000760000002800000024000000120000000100040000000000680100000000000000000000100000000000000000000000000080000080000000808000800000008000800080800000C0C0C000808080000000FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF003333333333333333333333333333333333330000333333333333333333333333F3333333333300003333344333333333333333388F3333333333000033334224333333333333338338F3333333330000333422224333333333333833338F3333333300003342222224333333333383333338F3333333000034222A22224333333338F338F3338F33333300003222A3A2224333333338F3838F338F33333300003A2A333A222433333338F83338F338F33333000033A33333A222433333338333338F338F33330000333333333A222433333333333338F338F33300003333333333A222433333333333338F338F33000033333333333A222433333333333338F338F30000333333333333A222433333333333338F338F00003333333333333A224333333333333338F38F000033333333333333A223333333333333338F830000333333333333333A3333333333333333383300003333333333333333333333333333333333330000" Kind="bkOK" Caption="OK" ModalResult="1" NumGlyphs="2" OnClick="OnClick"/>
    <TfrxLabelControl Name="Label1" Left="32" Top="32" Width="102" Height="29" Font.Charset="0" Font.Color="-16777208" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" ShowHint="True" Caption="ѹ§ҹͫ" Color="16768462"/>
    <TfrxLabelControl Name="Label2" Left="284" Top="68" Width="41" Height="29" Font.Charset="0" Font.Color="-16777208" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" ShowHint="True" Caption="֧ѹ" Color="16768462"/>
    <TfrxDBLookupComboBox Name="cbb_stock" Left="168" Top="120" Width="269" Height="33" Font.Charset="0" Font.Color="-16777208" Font.Height="-20" Font.Name="EucrosiaUPC" Font.Style="0" ParentFont="False" ShowHint="True" DataSet="qry_stock" DataSetName="stock" ListField="DEPT_NAME" KeyField="DEPT_ID" DropDownWidth="0" DropDownRows="7" OnClick="cbb_stockOnClick"/>
    <TfrxLabelControl Name="Label3" Left="86" Top="120" Width="66" Height="29" Font.Charset="0" Font.Color="-16777208" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" ShowHint="True" Caption="˹¨Ѵ" Color="16768462"/>
    <TfrxLabelControl Name="Label4" Left="108" Top="68" Width="57" Height="29" Font.Charset="0" Font.Color="-16777208" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" ShowHint="True" Caption="ѹ" Color="16768462"/>
  </TfrxDialogPage>
</TfrxReport>
