<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Version="5.2.12" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="42828.6645386458" ReportOptions.Description.Text="" ReportOptions.LastChange="42828.7118326389" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="MS_PO" DataSetName="MS_PO"/>
  </Datasets>
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxUniDACQuery Name="MS_PO" UserName="MS_PO" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT TOP 10 D.WORKING_CODE,D.DRUG_NAME,P.COMPANY_NAME,SUM(M1.COST) as total&#13;&#10;FROM&#13;&#10;    MS_PO M&#13;&#10;    INNER JOIN MS_PO_C M1 ON (M.PO_NO=M1.PO_NO) &#13;&#10;    INNER JOIN DRUG_GN D ON D.WORKING_CODE = M1.WORKING_CODE    &#13;&#10;		INNER JOIN COMPANY as P ON M1.VENDOR_CODE=P.COMPANY_CODE																																	&#13;&#10;WHERE&#13;&#10;    M1.VENDOR_CODE &#60;&#62; 'GPO001'&#13;&#10;GROUP BY D.WORKING_CODE,D.DRUG_NAME,P.COMPANY_NAME&#13;&#10;ORDER BY total DESC                                                    &#13;&#10;                 " SQLSchema="eAFVj7EKwjAQhvdA3sHN5YS7BKuCEbQpWZqm2upSpFR0KIqD9f3xahGVDCF8ue+/v7LNs9k03eUoRbFNjdZqvlhEc4qkqMrmdLt0TLzxRZ0HmGgNNAWFyBdK4WkAdQwRaPwh1tjd3tUuA1IKSM++Q5V7tGeWoolDUcLbzAJPQKAA+UhBw3i29gl8RJZ5TxGkUOaQZDbs6jjY5F8xfFmuRmOXB0Qac5G0vV/7Hmj6AN6HQ3h9Mn0iVxqeL+R6PfI=" SpecificOptions.Text="" PropData="05704C6566740394000470546F7002380A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="22.67718" Left="0" Top="18.89765" Width="718.1107" ColumnWidth="0" ColumnGap="0" DataSet="MS_PO" DataSetName="MS_PO" RowCount="0">
      <TfrxMemoView Name="MS_PODRUG_NAME" Left="41.57483" Top="0" Width="283.46475" Height="18.89765" DataField="DRUG_NAME" DataSet="MS_PO" DataSetName="MS_PO" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[MS_PO.&#34;DRUG_NAME&#34;]"/>
      <TfrxMemoView Name="MS_POtotal" Left="608.50433" Top="0" Width="79.37013" Height="18.89765" DataSet="MS_PO" DataSetName="MS_PO" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="TH SarabunPSK" Font.Style="0" Frame.Width="0.5" ParentFont="False" Text="[MS_PO.&#34;total&#34;]"/>
      <TfrxMemoView Name="MS_POCOMPANY_NAME" Left="260.78757" Top="0" Width="260.78757" Height="18.89765" DataField="COMPANY_NAME" DataSet="MS_PO" DataSetName="MS_PO" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tH SarabunPSK" Font.Style="0" ParentFont="False" Text="[MS_PO.&#34;COMPANY_NAME&#34;]"/>
      <TfrxMemoView Name="Memo1" Left="0" Top="0" Width="37.7953" Height="18.89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="tH SarabunPSK" Font.Style="0" ParentFont="False" Text="[Line]"/>
    </TfrxMasterData>
  </TfrxReportPage>
</TfrxReport>
