Question

asp 循环中的值存入数组的问题

想得到这样一个表格:
http://p15.freep.cn/p.aspx?u=v20_p15_p_0804301319068044_0.jpg
其他都已经做好了,现在缺的是最下面一行的后面12个月的汇总数据,全年的汇总数据我已经用total求得了,但是后面12个月的汇总(有了12个月的,Q1等季度的就好求了)涉及到一个横的和竖的两个循环,,,,就是这个不会写了,不知道怎么定义一个数组,先接受横的循环的数据,再加总竖的循环的数据...和大家一起等高手.
<%
'1.选出这一年里的 型号 ， 及 总和
year1=cstr(trim(Request.QueryString("pgdate")))
supl=Request.QueryString("supl")
xingzhi=Request.QueryString("xingzhi")
'sql 主体 ----------------
sql = " Select mpin,year(pgdate) as pgyear ,Sum(qty) From pms where 1 = 1 "
'sql 条件 ----------------
if len(year1) > 0 then
sql = sql & " and year(pgdate) = " & year1
end if
if len(supl) > 0 then
sql = sql & " and supl = '" & supl & "' "
end if
if len(xingzhi) > 0 then
sql = sql & "and xingzhi = '" & xingzhi & "' "
end if
'sql group by , order by----------------
sql = sql & " Group By mpin , year(pgdate) "
sql = sql & " order by mpin , year(pgdate) "
Set Rs=COnn.Execute( sql )
total=rs(2)
'call LogErr( "Rs.sql=", sql)
If rs.Eof Then
Response.Write "<tr><td colspan=14 align=center>暂时没有记录。请重新选择条件</td></tr></table>"
Else
Do While Not Rs.Eof
'2.输出每一行的 型号 ,年份，总和
%>
<tr><td><%=Rs(0)%> </td><td align="right"><%=rs(2)%> </td>
<%
'3.选出month
sql = "Select month(pgdate) as mth_idx , Sum(qty) From pms "
sql = sql & " Where (mpin='" & Rs(0)&"') "
sql = sql & " And ( year(pgdate)= " & rs(1) & " ) "
if len(year1) > 0 then
sql = sql & " and year(pgdate) = " & year1
end if
if len(supl) > 0 then
sql = sql & " and supl = '" & supl & "' "
end if
if len(xingzhi) > 0 then
sql = sql & "and xingzhi = '" & xingzhi & "' "
end if
sql = sql & " Group By month(pgdate) "
sql = sql & " order by month(pgdate) "
'call LogErr( "Rsc.sql=",sql)
Set RsC=Conn.Execute(sql)
If Not RsC.Eof Then
'输出每个月的数据
for i = 1 to 12
if RsC(0) = i then
'找到当月的纪录，输出，记录后移
%>
<td align="right"><%=RsC(1)%> </td>
<%
rsc.MoveNext
else
'没找到当月的纪录，输出0
%>
<td> </td>
<%
end if
next
End If
%>
</tr>
<%
Rs.MoveNext
total=total+rs(2)
Loop
RsC.Close
Set RsC=Nothing
Rs.Close
Set Rs=Nothing
%>

看不到图片可以参考 CSDN帖子:
http://topic.csdn.net/u/20080430/13/1c3fcc14-7727-4a7b-b407-5f354e878575.html
图里的最下面那行的170511正确值应该是每一列的型号的加总.图上170511的是我的错误值.
对代码或者表格有什么疑问,可以加QQ:46822118讨论.
希望baidu高手比csdn多一点.呵呵.今天晚上10点前回答,而且代码有用者,再加100分.

若以下回答无法解决问题，邀请你更新回答

Answer 1

改好鸟。。。发给你了