两天没好好睡了!求高人解决datareport的问题
sergy 2005-07-19 04:01:04 我打印的医院门诊发票中有一部分如下图所示,表里的数据都存在数据库,要求根据这些数据
统计这一天每个医生,以及医院的营业总额。
每张发票只对应某个医生一次所开药的情况(如:费用名称,费用金额,如下表)
并且,下表费用名称中所填向并不固定(如:手术费,治疗费,X光费.....)
我用的是datareport,不知用分组怎么实现
------------------------------------------
费用名称 | 费用金额 |费用名称 | 费用金额 |
------------------------------------------
| | | |
------------------------------------------
| | | |
------------------------------------------
-------------------------------------------------------------------------------------
统计表大致是这样的:
医生名 |手术费 |治疗费|.................|合计|
----------------------------------------------
.
.
.
合计 | | |.................| |
-----------------------------------------------
目前只写了一点程序,然后就不知道该怎么办了!请高手指点,分不够再加!
Private Sub DataReport_Initialize()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim Sql, strSql As String
'连接数据库(Access)
Set cn = New ADODB.Connection
With cn
.Provider = "MSDataShape.1"
.Open "Data Provider=Microsoft.Jet.OLEDB.4.0 ;" & _
"Data Source=" & App.Path & "\门诊.mdb;" & _
"Persist Security Info=False"
End With
RptGroup.Sections("Section6").Controls("text1").DataField = "序号a"
RptGroup.Sections("Section1").Controls("text2").DataField = "费用金额b1"
RptGroup.Sections("Section1").Controls("text2").DataMember = "mi"
Sql = "SELECT 费用金额b1,序号a FROM `成员` where Format(日期, 'yy/m/d')=Format(now, 'yy/m/d') "
strSql = "SHAPE {" & Sql & " } " & _
"AS mi COMPUTE mi,sum(mi.费用金额b1) as Total by 序号a "
Set rs = New ADODB.Recordset
rs.Open strSql, cn, adOpenStatic, adLockReadOnly
Set Me.DataSource = rs
End Sub