用水晶报表制作张坤需要的报表格式
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
一步一步的来写吧!
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
1.使用VS2005新建一个水晶报表项目
[图1]
2.选择空白报表
[图2]
3.字符资源管理器中右键数据库字段,选择"数据库专家"
[图3]
4.展开"创建新连接","OLE DB (ADO)",双击"建立新连接"
[图4]
5.选择"Microsoft OLE DB Provider for SQL Server"。
[图5]
注:如果使用别的数据库,则相应选择对应的驱动。如Access用"Microsoft Jet 4.0 OLE DB Provider",或Access 2007用"Microsoft Office 12.0 Access Database Engine Ole DB Provider",或SQL Server 2005用"SQL Native Client"等等
6.选择对应的表,并点击">"按钮。
[图6]
7."字段资源管理器"中,"组名字段"上右键。选"插入组"。
[图7]
8.分组依据字段选择OrderId,再点击"选项",选中"将组放在同一页上"。
[图8]
[图8-2]
9.按上面的方法,在"运行总计字段"上右键新键。找到amount字段,点">"按钮,并在"重置"选项组中选择"组更改时",如图所示。然后"确定"。
![](/images/cnblogs_com/zxsoft/114035/o_9.jpg)
[图9]
10.需要创建的字段已经都创建好了,按下图的方法拖到报表设计器中。其中,"记录号"字段在"字段资源管理器"的"特殊字段"里。"productid"和"amount"都在"数据库字段"里。"组 #1名"在"组名字段"里,不过这个字段会在创建组的时候自动添加,所以不需要自己拖放。"#RTotal0"字段在刚建好的"运行总计字段"里。"订购单号"和"合计"都是"工具箱"中的"文本对象"。
[图10]
11.因为格式要求,将[图10]中自动生成的Section2 (页眉)中的三个字段都删掉。
12.根据需要,添上页眉。在字段上右键设置一下文本格式,如,根据格式要求,合计后应是18,不是18.00。则可在#RTotal0上右键,把"系统默认数据格式"改成"-1123"。
[最终设计图]
13.运行看看效果
[效果图]
14.成功!
张旋(zxsoft)
如对本文有什么疑问,请在下面写下留言,谢谢!