水晶报表的问题!求助

超凡 2010-12-09 02:24:10

OleDbConnection co = new OleDbConnection("Provider=sqloledb;Data Source=" + server + ";Initial Catalog=" + database + ";uid="+Uid+";pwd="+Pwd+";");
adp = new OleDbDataAdapter("SELECT '1.结账汇总' AS flag,C_SSNo,C_SSName, N_DCFlag,( SELECT SUM(b.N_Money)FROM hi_account b WHERE (b.C_SSNo = a.C_SSNo)"+
" AND (b.C_State = 'C')"+
" AND (b.D_DTime > '2010-08-03')"+
" AND (b.D_DTime <= '2010-08-06')"+
" AND C_DGrade='中班'"+
" AND C_DOper='9435') AS Expr1 FROM HI_StatSub a WHERE (N_DCFLag <> 0) AND (C_IfDelete <> 'Y') "+
"union SELECT '2.收退定金(押金)合计' AS flag,C_SubNo, C_SubName, N_DCFlag,(SELECT SUM(b.N_Money) FROM hi_account b WHERE (b.C_DSNo = a.C_SubNo) AND (b.D_CTime > "+
"'2010-08-03') AND (b.D_CTime <='2010-08-06') AND C_CGrade='中班' AND C_DOper='9435') AS Expr1 FROM HI_Subject a WHERE (C_SSNo = 'AAA') or (C_SSNo = 'BBB') and (C_IfDelete<>'Y') "+
"union SELECT '2.收退定金(押金)合计' AS flag,C_SSNo, '退' + C_SSName, N_DCFlag,(SELECT SUM(0-b.N_Money) FROM hi_account b WHERE (b.C_sSNo = a.C_sSNo) AND (b.C_State = 'C') AND (b.D_DTime >"+
"'2010-08-03') AND (b.D_DTime <='2010-08-06') AND C_DGrade='中班' AND C_DOper='9435') AS Expr1 FROM HI_StatSub a where (C_SSNo = 'AAA') and (C_IfDelete<>'Y') ", co);

adp.Fill(dataset, "HI_Account");//请问我这里应该是填写datatable中的表名还是填写数据库中的,如果填写数据库中的那我这样不是行不通,请问有什么更好的办法吗?


AccountReport repors = new AccountReport();


repors.SetDataSource(dataset);
crystalReportViewer1.ReportSource = repors;
...全文
95 3 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
阿双2009 2010-12-09
  • 打赏
  • 举报
回复
[Quote=引用楼主 hncelfhv 的回复:]
adp.Fill(dataset, "HI_Account");//请问我这里应该是填写datatable中的表名还是填写数据库中的[/Quote]
datatable中的表名
超凡 2010-12-09
  • 打赏
  • 举报
回复
在线求解!

4,819

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术 图表区
社区管理员
  • 图表区社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧