1.用stringgrid
2.把合计结果显示到其他位置
2.把合计结果显示到其他位置
解决方案 »
- 求EXCEL导入MSSQL数据库代码,可以用的,效率比较高的!
- pos函数是从左到右查找字符串,有没有从右到左查找的函数?
- ★祝我生日快乐,祝所有快毕业的学生都能找个好工作★
- 如何在代码里设置控件TabbedNotebook某一页的页头名称?
- 请高手进入-(关于输入法切换时,程序会停止响应)
- 如何将variant类型的赋值给某个变量
- 祝愿天下的母亲都健康快乐
- 软件做好安装后出现的问题
- 怎么用socket.data属性?
- 如何把当前窗口中listview1的item.caption付给另一个窗口的caption,并且选择另一个item时,另一个窗口的caption也跟着变!谢谢!
- 操作文本文件的简单问题!赶紧来拿分!
- 控件继承问题--新手(伴水)
SELECT uu='总计',II='',kk='',mm='',ze=0,jhwje=0,
SUM(CASE WHEN (HPBH Like '200101%')OR(HPBH Like '200102%')OR(HPBH Like '200103%') THEN XJ ELSE 0 END) AS '01',
SUM(CASE WHEN (HPBH Like '200104%')OR(HPBH Like '200105%')OR(HPBH Like '200106%') THEN XJ ELSE 0 END) AS '02',
SUM(CASE WHEN (HPBH Like '200107%')OR(HPBH Like '200108%')OR(HPBH Like '200109%') THEN XJ ELSE 0 END) AS '03',
SUM(CASE WHEN (HPBH Like '200110%')OR(HPBH Like '200111%')OR(HPBH Like '200112%') THEN XJ ELSE 0 END) AS '04',HJ=(SUM(CASE WHEN (HPBH Like '200101%')OR(HPBH Like '200102%')OR(HPBH Like '200103%') THEN XJ ELSE 0 END)
+SUM(CASE WHEN (HPBH Like '200104%')OR(HPBH Like '200105%')OR(HPBH Like '200106%') THEN XJ ELSE 0 END)
+SUM(CASE WHEN (HPBH Like '200107%')OR(HPBH Like '200108%')OR(HPBH Like '200109%') THEN XJ ELSE 0 END)
+SUM(CASE WHEN (HPBH Like '200110%')OR(HPBH Like '200111%')OR(HPBH Like '200112%') THEN XJ ELSE 0 END)) FROM TABLE_BGYPLYB
Where HPBH Like '2001%'
UNION
SELECT t=(Select DeptName From Tib_DEPT where DeptID=LYDWID),
t1=(Select GSZY From TABLE_BGYPCSXXB where XH=LYDWID AND ND=2001),
t2=(Select LSG From TABLE_BGYPCSXXB where XH=LYDWID AND ND=2001),
t3=(Select ZZRY From TABLE_BGYPCSXXB where XH=LYDWID AND ND=2001),
t4=(Select FPZE From TABLE_BGYPCSXXB where XH=LYDWID AND ND=2001),
t5=(Select JHWJE From TABLE_BGYPCSXXB where XH=LYDWID AND ND=2001),
SUM(CASE WHEN (HPBH Like '200101%')OR(HPBH Like '200102%')OR(HPBH Like '200103%') THEN XJ ELSE 0 END) AS '01',
SUM(CASE WHEN (HPBH Like '200104%')OR(HPBH Like '200105%')OR(HPBH Like '200106%') THEN XJ ELSE 0 END) AS '02',
SUM(CASE WHEN (HPBH Like '200107%')OR(HPBH Like '200108%')OR(HPBH Like '200109%') THEN XJ ELSE 0 END) AS '03',
SUM(CASE WHEN (HPBH Like '200110%')OR(HPBH Like '200111%')OR(HPBH Like '200112%') THEN XJ ELSE 0 END) AS '04',HJ=(SUM(CASE WHEN (HPBH Like '200101%')OR(HPBH Like '200102%')OR(HPBH Like '200103%') THEN XJ ELSE 0 END)
+SUM(CASE WHEN (HPBH Like '200104%')OR(HPBH Like '200105%')OR(HPBH Like '200106%') THEN XJ ELSE 0 END)
+SUM(CASE WHEN (HPBH Like '200107%')OR(HPBH Like '200108%')OR(HPBH Like '200109%') THEN XJ ELSE 0 END)
+SUM(CASE WHEN (HPBH Like '200110%')OR(HPBH Like '200111%')OR(HPBH Like '200112%') THEN XJ ELSE 0 END)) FROM TABLE_BGYPLYB
Where HPBH Like '2001%'
GROUP BY LYDWID
SELECT A,B,C,D
FROM tblXXX
Union
Select '合计',sum(B),sum(C),sum(D)
from tblXXX
适用于行数不多情况。