Intranet Report -- 3
Budget: $30 – $250 USD
Create 7 web pages.
1st page is used to import 1-4 excel files into existing table (already created) in SQL.
2nd web page have 6 text boxes for searching, 2 dropdownlist, 1 searching button, 1 Calculation based on 2 existing table to display Raw Material Status (On-Hand, In Quality Control, On-Order, and Short reference with an existing C# code) and assign expected delivery date, Purchase Number, and Confirm Date to any On-Order Status. The result will display in gridview and export to excel.
3rd page will concatenate row On-Order and Short Status from 2nd page if it is a same Sale Order, then display in Gridview and export to excel.
4th Page is associated with the 3 rd page to display in gridview and export to excel or xml
5th Page obtain data from joining tables and display in gridview that is able to move rows up or down
6th page is used to input some data (insert, delete, and edit data)
If reasonable rate is offered, there is a chance for a long term project
1st page is used to import 1-4 excel files into existing table (already created) in SQL.
2nd web page have 6 text boxes for searching, 2 dropdownlist, 1 searching button, 1 Calculation based on 2 existing table to display Raw Material Status (On-Hand, In Quality Control, On-Order, and Short reference with an existing C# code) and assign expected delivery date, Purchase Number, and Confirm Date to any On-Order Status. The result will display in gridview and export to excel.
3rd page will concatenate row On-Order and Short Status from 2nd page if it is a same Sale Order, then display in Gridview and export to excel.
4th Page is associated with the 3 rd page to display in gridview and export to excel or xml
5th Page obtain data from joining tables and display in gridview that is able to move rows up or down
6th page is used to input some data (insert, delete, and edit data)
If reasonable rate is offered, there is a chance for a long term project