- ASP網頁顯示數據庫明細,我想在最後一行後面添加一行匯總行,如何實現?
-
ASP網頁顯示數據庫明細,我想在最後一行後面添加一行匯總行,如何實現?我用的DW做的。
最佳回答:
<% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %>
<%=(Recordset1.Fields.Item("Dpt").Value)%>
<%=(Recordset1.Fields.Item("SalesTarget").Value)%><%=(Recordset1.Fields.Item("CurYearShipAmt").Value)%><%=(Recordset1.Fields.Item("CurYearRecAmt").Value)%><%=(Recordset1.Fields.Item("CurYearNewArs").Value)%><%=(Recordset1.Fields.Item("ToTalArs").Value)%><%=(Recordset1.Fields.Item("CurMonthShip").Value)%><%=FormatPercent((Recordset1.Fields.Item("RecRate").Value))%>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>