报表主要是统计的吗?有没有好的报表列子,谢谢啊愁了好几天了一直没找到好的
大家帮个忙吧
------解决方案--------------------看你用什么报表工具了。
------解决方案--------------------报表打印控件wsReport4.6
http://www.wave12.com/web/home.asp
------解决方案--------------------用水晶报表。
或者用zedgraph
------解决方案--------------------xslt
------解决方案--------------------利用SQL 语句吧。
OleDbConnection cn = new OleDbConnection(Tsql);
cn.Open();
string sum_sql = "select * from "
+ " ( "
+ " select name + convert(varchar(30),id) as name,address,status from test t1 "
+ " union "
+ " select name,'小计' as address,sum(status) as status from test t2 group by name "
+ " ) a "
+ " order by name";
OleDbDataAdapter da = new OleDbDataAdapter(sum_sql, cn);