📄 统计_库存分类统计表.fr3
字号:
<TfrxMemoView Name="Memo46" Left="514.01608" Top="185.19697" Width="79.37013" Height="18.89765" DataField="资物探" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."资物探"]"/>
<TfrxMemoView Name="Memo47" Left="514.01608" Top="166.29932" Width="79.37013" Height="18.89765" Memo.Text="资物探"/>
<TfrxMemoView Name="Memo48" Left="604.7248" Top="185.19697" Width="79.37013" Height="18.89765" DataField="资地质" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."资地质"]"/>
<TfrxMemoView Name="Memo49" Left="604.7248" Top="166.29932" Width="79.37013" Height="18.89765" Memo.Text="资地质"/>
<TfrxMemoView Name="Memo50" Left="45.35436" Top="260.78757" Width="79.37013" Height="18.89765" DataField="01" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."01"]"/>
<TfrxMemoView Name="Memo51" Left="45.35436" Top="241.88992" Width="79.37013" Height="18.89765" Memo.Text="01"/>
<TfrxMemoView Name="Memo52" Left="143.62214" Top="260.78757" Width="79.37013" Height="18.89765" DataField="02" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."02"]"/>
<TfrxMemoView Name="Memo53" Left="143.62214" Top="241.88992" Width="79.37013" Height="18.89765" Memo.Text="02"/>
<TfrxMemoView Name="Memo54" Left="245.66945" Top="260.78757" Width="79.37013" Height="18.89765" DataField="03" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."03"]"/>
<TfrxMemoView Name="Memo55" Left="245.66945" Top="241.88992" Width="79.37013" Height="18.89765" Memo.Text="03"/>
<TfrxMemoView Name="Memo56" Left="347.71676" Top="260.78757" Width="79.37013" Height="18.89765" DataField="04" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."04"]"/>
<TfrxMemoView Name="Memo57" Left="347.71676" Top="241.88992" Width="79.37013" Height="18.89765" Memo.Text="04"/>
<TfrxMemoView Name="Memo58" Left="449.76407" Top="260.78757" Width="79.37013" Height="18.89765" DataField="05" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."05"]"/>
<TfrxMemoView Name="Memo59" Left="449.76407" Top="241.88992" Width="79.37013" Height="18.89765" Memo.Text="05"/>
<TfrxMemoView Name="Memo60" Left="548.03185" Top="260.78757" Width="79.37013" Height="18.89765" DataField="06" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."06"]"/>
<TfrxMemoView Name="Memo61" Left="548.03185" Top="241.88992" Width="79.37013" Height="18.89765" Memo.Text="06"/>
<TfrxMemoView Name="Memo62" Left="650.07916" Top="264.5671" Width="79.37013" Height="18.89765" DataField="07" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."07"]"/>
<TfrxMemoView Name="Memo63" Left="650.07916" Top="245.66945" Width="79.37013" Height="18.89765" Memo.Text="07"/>
<TfrxMemoView Name="Memo64" Left="45.35436" Top="321.26005" Width="79.37013" Height="18.89765" DataField="08" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."08"]"/>
<TfrxMemoView Name="Memo65" Left="45.35436" Top="302.3624" Width="79.37013" Height="18.89765" Memo.Text="08"/>
<TfrxMemoView Name="Memo66" Left="143.62214" Top="321.26005" Width="79.37013" Height="18.89765" DataField="09" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."09"]"/>
<TfrxMemoView Name="Memo67" Left="143.62214" Top="302.3624" Width="79.37013" Height="18.89765" Memo.Text="09"/>
<TfrxMemoView Name="Memo68" Left="238.11039" Top="325.03958" Width="79.37013" Height="18.89765" DataField="10" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."10"]"/>
<TfrxMemoView Name="Memo69" Left="238.11039" Top="306.14193" Width="79.37013" Height="18.89765" Memo.Text="10"/>
<TfrxMemoView Name="Memo70" Left="336.37817" Top="325.03958" Width="79.37013" Height="18.89765" DataField="11" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."11"]"/>
<TfrxMemoView Name="Memo71" Left="336.37817" Top="306.14193" Width="79.37013" Height="18.89765" Memo.Text="11"/>
<TfrxMemoView Name="Memo72" Left="430.86642" Top="325.03958" Width="79.37013" Height="18.89765" DataField="12" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."12"]"/>
<TfrxMemoView Name="Memo73" Left="430.86642" Top="306.14193" Width="79.37013" Height="18.89765" Memo.Text="12"/>
<TfrxMemoView Name="Memo74" Left="529.1342" Top="328.81911" Width="79.37013" Height="18.89765" DataField="13" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."13"]"/>
<TfrxMemoView Name="Memo75" Left="529.1342" Top="309.92146" Width="79.37013" Height="18.89765" Memo.Text="13"/>
<TfrxMemoView Name="Memo76" Left="627.40198" Top="328.81911" Width="79.37013" Height="18.89765" DataField="14" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."14"]"/>
<TfrxMemoView Name="Memo77" Left="627.40198" Top="309.92146" Width="79.37013" Height="18.89765" Memo.Text="14"/>
<TfrxMemoView Name="Memo78" Left="49.13389" Top="377.953" Width="79.37013" Height="18.89765" DataField="15" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."15"]"/>
<TfrxMemoView Name="Memo79" Left="49.13389" Top="359.05535" Width="79.37013" Height="18.89765" Memo.Text="15"/>
<TfrxMemoView Name="Memo80" Left="151.1812" Top="377.953" Width="79.37013" Height="18.89765" DataField="16" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."16"]"/>
<TfrxMemoView Name="Memo81" Left="151.1812" Top="359.05535" Width="79.37013" Height="18.89765" Memo.Text="16"/>
<TfrxMemoView Name="Memo82" Left="249.44898" Top="377.953" Width="79.37013" Height="18.89765" DataField="17" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."17"]"/>
<TfrxMemoView Name="Memo83" Left="249.44898" Top="359.05535" Width="79.37013" Height="18.89765" Memo.Text="17"/>
<TfrxMemoView Name="Memo84" Left="347.71676" Top="374.17347" Width="79.37013" Height="18.89765" DataField="18" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."18"]"/>
<TfrxMemoView Name="Memo85" Left="347.71676" Top="355.27582" Width="79.37013" Height="18.89765" Memo.Text="18"/>
<TfrxMemoView Name="Memo86" Left="442.20501" Top="374.17347" Width="79.37013" Height="18.89765" DataField="19" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."19"]"/>
<TfrxMemoView Name="Memo87" Left="442.20501" Top="355.27582" Width="79.37013" Height="18.89765" Memo.Text="19"/>
<TfrxMemoView Name="Memo88" Left="540.47279" Top="377.953" Width="79.37013" Height="18.89765" DataField="20" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."20"]"/>
<TfrxMemoView Name="Memo89" Left="540.47279" Top="359.05535" Width="79.37013" Height="18.89765" Memo.Text="20"/>
<TfrxMemoView Name="Memo90" Left="634.96104" Top="377.953" Width="79.37013" Height="18.89765" DataField="21" DataSetName="qry_tj_kcfltjb" Memo.Text="[qry_tj_kcfltjb."21"]"/>
<TfrxMemoView Name="Memo91" Left="634.96104" Top="359.05535" Width="79.37013" Height="18.89765" Memo.Text="21"/>
</TfrxMasterData>
</TfrxReportPage>
<TfrxDialogPage Name="DialogPage1" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" Height="200" Left="265" Top="150" Width="300">
<TfrxADODatabase Name="ADODatabase1" DatabaseName="Provider=SQLOLEDB.1;Password=gauser;Persist Security Info=True;User ID=gauser;Initial Catalog=GA4;Data Source=dsvr;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=gauser;Use Encryption for Data=False;Tag with column collation when possible=False" LoginPrompt="False" Connected="True" PropData="05704C65667403EC000470546F700204"/>
<TfrxADOQuery Name="qry_tj_kcfltjb" UserName="qry_tj_kcfltjb" FieldAliases.Text="SJDZ=井地透 SJFX=井分析 SJCJ=井测井 SJZJ=井钻井 SJSY=井试油 SJYS=井原始 SJCY=井采油 SJXJ=井修井 SJZH=井综合 SDDT=档单图 SDDN=档地年 SDDZ=档地质 SDKF=档开发 SDKY=档开月 SDSC=档试采 SDZH=档综合 SDWT=档物探 SDZY=档钻月 SDZJ=档钻综 SZDT=资单图 SZKF=资开发 SZNB=资年报 SZWT=资物探 SZDZ=资地质 S01=01 S02=02 S03=03 S04=04 S05=05 S06=06 S07=07 S08=08 S09=09 S10=10 S11=11 S12=12 S13=13 S14=14 S15=15 S16=16 S17=17 S18=18 S19=19 S20=20 S21=21" SQL.Text="SELECT (SELECT COUNT(*) FROM djda WHERE LB='JDZ') AS SJDZ, (SELECT COUNT(*) FROM djda WHERE LB='JFX') AS SJFX, (SELECT COUNT(*) FROM djda WHERE LB='JCJ') AS SJCJ, (SELECT COUNT(*) FROM djda WHERE LB='JZJ') AS SJZJ, (SELECT COUNT(*) FROM djda WHERE LB='JSY') AS SJSY, (SELECT COUNT(*) FROM djda WHERE LB='JYS') AS SJYS, (SELECT COUNT(*) FROM djda WHERE LB='JCY') AS SJCY, (SELECT COUNT(*) FROM djda WHERE LB='JXJ') AS SJXJ, (SELECT COUNT(*) FROM djda WHERE LB='JZH') AS SJZH, (SELECT COUNT(*) FROM zhcg WHERE LB='DDT') AS SDDT, (SELECT COUNT(*) FROM zhcg WHERE LB='DDN') AS SDDN, (SELECT COUNT(*) FROM zhcg WHERE LB='DDZ') AS SDDZ, (SELECT COUNT(*) FROM zhcg WHERE LB='DKF') AS SDKF, (SELECT COUNT(*) FROM zhcg WHERE LB='DKY') AS SDKY, (SELECT COUNT(*) FROM zhcg WHERE LB='DSC') AS SDSC, (SELECT COUNT(*) FROM zhcg WHERE LB='DZH') AS SDZH, (SELECT COUNT(*) FROM zhcg WHERE LB='DWT') AS SDWT, (SELECT COUNT(*) FROM zhcg WHERE LB='DZY') AS SDZY, (SELECT COUNT(*) FROM zhcg WHERE LB='DZJ') AS SDZJ, (SELECT COUNT(*) FROM zhcg WHERE LB='ZDT') AS SZDT, (SELECT COUNT(*) FROM zhcg WHERE LB='ZKF') AS SZKF, (SELECT COUNT(*) FROM zhcg WHERE LB='ZNB') AS SZNB, (SELECT COUNT(*) FROM zhcg WHERE LB='ZWT') AS SZWT, (SELECT COUNT(*) FROM zhcg WHERE LB='ZDZ') AS SZDZ, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='01') AS S01, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='02') AS S02, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='03') AS S03, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='04') AS S04, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='05') AS S05, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='06') AS S06, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='07') AS S07, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='08') AS S08, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='09') AS S09, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='10') AS S10, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='11') AS S11, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='12') AS S12, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='13') AS S13, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='14') AS S14, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='15') AS S15, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='16') AS S16, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='17') AS S17, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='18') AS S18, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='19') AS S19, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='20') AS S20, (SELECT COUNT(*) FROM djcsda_a WHERE LEFT(XH,2)='21') AS S21" Database="ADODatabase1" PropData="05704C65667403EC000470546F7002380A506172616D65746572730100"/>
</TfrxDialogPage>
</TfrxReport>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -