.Net simple form and report

Sales Rep Reporting page covering three simple reports + login basd on databse

Requirements
• “User” table for Authentication (username and password) should contain a field for “RepCode” varchar(8) that will be passed as a parameter to stored procedures. This will ensure that Reps only see data for the
• Report #1 – Sales by Account
o Format: Data Grid; Exportable to Excel
o Stored Procedure: spr_sel_RepSalesByCust
o Parameters:
 @pRepCode varchar(8) (From logged in user)
o Returned Fields:
 CustId (Customer ID)
 Name (Customer Name)
 SalesPYR (Prev Year $)
 SalesYTD (YTD $)
 SalesJan (Jan$), SalesFeb (Feb$), …, SalesDec (Dec$)
• Report #2 – Sales by SKU
o Format: Data Grid; Exportable to Excel
o Stored Procedure: spr_sel_RepSalesBySKU
o Parameters:
 @pRepCode varchar(8) (From logged in user)
o Returned Fields:
 PartNum (SKU #)
 PartDescription (Item Desc)
 QtyPYR (Prev Year Qty)
 SalesPYR (Prev Year $)
 QtyYTD (YTD Qty)
 SalesYTD (YTD $)
 QtyJan (JanQty), SalesFeb (FebQty), …, SalesDec (DecQty)
 SalesJan (Jan$), SalesFeb (Feb$), …, SalesDec (Dec$)
o
• Report #3 – Sales by Account by SKU
o Format: Data Grid; Exportable to Excel
o Stored Procedure: spr_sel_RepSalesByCustSKU
o Parameters:
 @pRepCode varchar(8) (From logged in user)
o Returned Fields:
 CustId (Customer ID)
 Name (Customer Name)
 PartNum (SKU #)
 PartDescription (Item Desc)
 QtyPYR (Prev Year Qty)
 SalesPYR (Prev Year $)
 QtyYTD (YTD Qty)
 SalesYTD (YTD $)
 QtyJan (JanQty), SalesFeb (FebQty), …, SalesDec (DecQty)
 SalesJan (Jan$), SalesFeb (Feb$), …, SalesDec (Dec$)

• Report #4 – Open Orders by Account
o Format: Data Grid; Exportable to Excel
o Stored Procedure: spr_sel_RepOpenOrders
o Parameters:
 @pRepCode varchar(8) (From logged in user)
o Returned Fields:
 OrderNum (Order #)
 OrderDate (Order Date)
 CustId (Customer ID)
 Name (Customer Name)
 PartNum (SKU #)
 PartDescription (Item Desc)
 OrderQty (Qty Ordered)
 SalesDollars (Prev Year $)

ll fields to be sortable,