By using SHW schema
Create one Report Builder (dl) for each of the following, providing ALL the fields in each form. a. A report that can show orders placed by customers that live in different, provinces and cities. The report must be an expandable table that can show the totals by province, by city and by customer, as well as individual orders placed by the customer. The report will contain the following information: Province, City, Custoner Name, Order No., Order Date, Part No., Quantity Ordered, Order Price and the Subtotal (quantity * price). Province City Order No. Order Date Part No. Quantity Price $14.99 Customer Name 5 E AB O CA O HL IL - NL O NY BON Total Total Total Total Total Total Ajax Alendale Aurora Brampton 19 1 5 12 5 4 Total Total Total Amandeep Paul Andrew Winterburn 98 1 41 Total 00329 Subtotal $59.96 $1,720.00 $75.81 $279.99 $449.95 $157.56 $43.98 $127.96 $7.448.62 $2,000.99 $1,229.59 $1,049.85 $3.179.44 $1,319.56 $1,229.59 $ $95.68 $2,644.83 $5,824.27 $1,180.00 $3.99 $ $279.99 $89.99 $13.13 $18.99 $31.99 $1.962.94 $2,000.99 529.99 $129.99 $159.98 $29.00 $29.99 $2.99 $62.97 $222.95 8/26/2010 8/26/2010 T23660 BS3217 15 56 44 F 00364 9/21/2011 9/21/2011 9/21/2011 T23660 526170 C35207 41 32 117 173 Total b. An invoice form report that shows the invoices based on an invoice number selection. For each invoice number selected in a drop down list, the invoice must show the customer information (name and address), invoice number, invoice date, part numbers, the order price, the quantity shipped as well as the subtotals for each part and the final total. Select invece No: 000001 Invoice Customer Name: CRAIG DAKIN Address: 1193 LAKEVIEW RD Guelph ON MIVSH7 Invoice Date: 2/12/2001 Invoice No. 000001 Part No. H55074 521488 Price $12.99 512.25 Quantity 1 1 1 Subtotal $12.99 512.25 $25.24 Total c. A pie chart report that can show total number of part units sold for each part class during a certain period of time. The start date and the end date must be selected values. Enter start date: 2001-02-12 11:28:18 AM Enter end date: 2003-12-31 11:28:18 AM Sales By Part Class Unit Sales by Date AP HW KI sp 67 40 247 74 d. A column chart that shows the difference in dollars amount of the orders and invoices for each part class. A start date and an end date must be selected values. Odrers and Invoices 80000 Order Amount Invoiced Amount 60000 Total Amount 40000 20000 - AP SP HW KI Part Class Additional Notes Dates/years that will be used for reports (c) and (d) must be selected from the available dates/years of the invoice dates in the database. The text fields, columns etc. must be properly aligned and formatted based on the type of data they represent. The column fields must be renamed to more meaningful names rather that the default column names from the tables in the database. Create one Report Builder (dl) for each of the following, providing ALL the fields in each form. a. A report that can show orders placed by customers that live in different, provinces and cities. The report must be an expandable table that can show the totals by province, by city and by customer, as well as individual orders placed by the customer. The report will contain the following information: Province, City, Custoner Name, Order No., Order Date, Part No., Quantity Ordered, Order Price and the Subtotal (quantity * price). Province City Order No. Order Date Part No. Quantity Price $14.99 Customer Name 5 E AB O CA O HL IL - NL O NY BON Total Total Total Total Total Total Ajax Alendale Aurora Brampton 19 1 5 12 5 4 Total Total Total Amandeep Paul Andrew Winterburn 98 1 41 Total 00329 Subtotal $59.96 $1,720.00 $75.81 $279.99 $449.95 $157.56 $43.98 $127.96 $7.448.62 $2,000.99 $1,229.59 $1,049.85 $3.179.44 $1,319.56 $1,229.59 $ $95.68 $2,644.83 $5,824.27 $1,180.00 $3.99 $ $279.99 $89.99 $13.13 $18.99 $31.99 $1.962.94 $2,000.99 529.99 $129.99 $159.98 $29.00 $29.99 $2.99 $62.97 $222.95 8/26/2010 8/26/2010 T23660 BS3217 15 56 44 F 00364 9/21/2011 9/21/2011 9/21/2011 T23660 526170 C35207 41 32 117 173 Total b. An invoice form report that shows the invoices based on an invoice number selection. For each invoice number selected in a drop down list, the invoice must show the customer information (name and address), invoice number, invoice date, part numbers, the order price, the quantity shipped as well as the subtotals for each part and the final total. Select invece No: 000001 Invoice Customer Name: CRAIG DAKIN Address: 1193 LAKEVIEW RD Guelph ON MIVSH7 Invoice Date: 2/12/2001 Invoice No. 000001 Part No. H55074 521488 Price $12.99 512.25 Quantity 1 1 1 Subtotal $12.99 512.25 $25.24 Total c. A pie chart report that can show total number of part units sold for each part class during a certain period of time. The start date and the end date must be selected values. Enter start date: 2001-02-12 11:28:18 AM Enter end date: 2003-12-31 11:28:18 AM Sales By Part Class Unit Sales by Date AP HW KI sp 67 40 247 74 d. A column chart that shows the difference in dollars amount of the orders and invoices for each part class. A start date and an end date must be selected values. Odrers and Invoices 80000 Order Amount Invoiced Amount 60000 Total Amount 40000 20000 - AP SP HW KI Part Class Additional Notes Dates/years that will be used for reports (c) and (d) must be selected from the available dates/years of the invoice dates in the database. The text fields, columns etc. must be properly aligned and formatted based on the type of data they represent. The column fields must be renamed to more meaningful names rather that the default column names from the tables in the database
