home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
DOS/V Power Report 1997 March
/
VPR9703A.ISO
/
MS_DEV
/
VID
/
SERVER
/
ASF
/
DATA.Z
/
Sales_by_Product.asp
< prev
next >
Wrap
Text File
|
1996-10-28
|
4KB
|
164 lines
<!--#include virtual="/AdvWorks/Num2Dolr.inc"-->
<HTML>
<HEAD>
<TITLE>Adventure Works Sales by Product</TITLE>
</HEAD>
<BODY BACKGROUND="/AdvWorks/multimedia/images/back_sub.gif" LINK="#800000" VLINK="#008040">
<FONT FACE="MS SANS SERIF" SIZE=2>
<BGSOUND SRC="/AdvWorks/multimedia/sounds/windfin4.wav">
<TABLE WIDTH=600 BORDER=0>
<TR>
<TD>
<IMG SRC="/AdvWorks/multimedia/images/spacer.GIF" ALIGN=RIGHT WIDTH=110 ALT="Spacer">
</TD>
<TD COLSPAN=3>
<FONT SIZE=4 FACE="ARIAL NARROW" COLOR="#800000">Sales by Product</FONT>
<HR SIZE=4>
</TD>
</TR>
<TR>
<TD ROWSPAN=7 VALIGN=TOP ALIGN=LEFT>
<A HREF="/AdvWorks/equipment/default.asp">
<IMG SRC="/AdvWorks/multimedia/images/icon_sub_equipment.GIF" width="85" height="45" ALIGN=CENTER BORDER=0 ALT="Equipment"></A><BR>
<A HREF="/AdvWorks/excursions/default.asp">
<IMG SRC="/AdvWorks/multimedia/images/icon_sub_excursions.GIF" width="85" height="45" ALIGN=CENTER BORDER=0 ALT="Membership and Excursions"></A><BR>
<A HREF="/AdvWorks/resources/default.asp">
<IMG SRC="/AdvWorks/multimedia/images/icon_sub_resources.GIF" width="85" height="45" ALIGN=CENTER BORDER=0 ALT="Resources"></A><BR>
<A HREF="/AdvWorks/internal/default.asp">
<IMG SRC="/AdvWorks/multimedia/images/icon_sub_internal.GIF" width="85" height="45" ALIGN=CENTER BORDER=0 ALT="Internal"></A><BR>
<A HREF="/AdvWorks/default.asp">
<IMG SRC="/AdvWorks/multimedia/images/icon_sub_home.GIF" width="85" height="45" ALIGN=CENTER BORDER=0 ALT="Home"></A><BR>
<%If Not IsEmpty(Session("ItemCount")) Then
iCount = Session("ItemCount")
Else
iCount = 0
End If
If iCount > 0 Then%>
<A HREF="/AdvWorks/equipment/check_out.asp">
<IMG SRC="/AdvWorks/multimedia/images/checkout.gif" width="85" height="45" ALT="Check Out" BORDER=O></A>
<%End If%>
</TD>
<TD VALIGN=TOP ALIGN=LEFT COLSPAN=3><FONT SIZE=2>
<FORM ACTION="/AdvWorks/ ........ " METHOD=POST>
<%
Set RS = Conn.Execute("{Call SalesByProduct}")
TotalUnits = 0
TotalSales = 0
%>
<TABLE COLSPAN=8 CELLPADDING=5 BORDER=0>
<!-- BEGIN column header row -->
<TR>
<TD ALIGN=CENTER BGCOLOR="#800000">
<FONT STYLE="ARIAL NARROW" COLOR="#ffffff" SIZE=1>Product Name</FONT>
</TD>
<TD ALIGN=CENTER BGCOLOR="#800000">
<FONT STYLE="ARIAL NARROW" COLOR="#ffffff" SIZE=1>Total Units</FONT>
</TD>
<TD ALIGN=CENTER BGCOLOR="#800000">
<FONT STYLE="ARIAL NARROW" COLOR="#ffffff" SIZE=1>Total Sales</FONT>
</TD>
</TR>
<!-- BEGIN first row of inserted product data -->
<% Do While Not RS.EOF %>
<TR>
<TD BGCOLOR="f7efde" ALIGN=CENTER>
<FONT STYLE="ARIAL NARROW" SIZE=1><%=RS("ProductName")%></FONT></TD>
<TD BGCOLOR="f7efde" ALIGN=CENTER>
<FONT STYLE="ARIAL NARROW" SIZE=1><%=RS("Total Units")%></FONT></TD>
<TD BGCOLOR="f7efde" ALIGN=CENTER>
<FONT STYLE="ARIAL NARROW" SIZE=1><%=Num2Dollars(RS("Total Sales"))%></FONT></TD>
</TR>
<%
TotalUnits = TotalUnits + RS("Total Units")
TotalSales = TotalSales + RS("Total Sales")
RS.MoveNext
Loop
%>
<TR>
<TD ALIGN=CENTER BGCOLOR="#800000">
<FONT STYLE="ARIAL NARROW" COLOR="#ffffff" SIZE=1>Grand Total</FONT>
</TD>
<TD ALIGN=CENTER BGCOLOR="#800000">
<FONT STYLE="ARIAL NARROW" COLOR="#ffffff" SIZE=1><%=TotalUnits%></FONT>
</TD>
<TD ALIGN=CENTER BGCOLOR="#800000">
<FONT STYLE="ARIAL NARROW" COLOR="#ffffff" SIZE=1><%=Num2Dollars(TotalSales)%></FONT>
</TD>
</TR>
</TABLE>
<BR>
<OBJECT
classid="clsid:FC25B780-75BE-11CF-8B01-444553540000"
CODEBASE="/AdvWorks/Controls/iechart.ocx"
id=chart1
width=500
height=200
align=center
hspace=0
vspace=0
>
<param name="hgridStyle" value="3">
<param name="vgridStyle" value="0">
<param name="colorscheme" value="0">
<param name="DisplayLegend" value="1">
<param name="BackStyle" value="1">
<param name="BackColor" value="#800000">
<param name="ForeColor" value="#ffffff">
<param name="Scale" value="100">
<param name="url" value="/AdvWorks/internal/sales_by_product_graph.asp">
</OBJECT>
</TD>
</TR>
</FONT>
<% REM Column Span Value %>
<% HTML_CS = 3 %>
<% HTML_INDENT = FALSE %>
<!--#include virtual="/AdvWorks/Disclaim.inc"-->
</TABLE>
<!--#include virtual="/AdvWorks/srcform.inc"-->
</BODY>
</HTML>