W11MGT475PA2_FirstReport

W11MGT475PA2_FirstReport - MGT475 H. Klein Assignment 02...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
MGT475 H. Klein Assignment 02 – Chapters 3 and 4 Use what you have learned about using database tables and writing report programs against a database table to print out the following reports. 1. The first should look like this: Sales Order Detail Information Ord Ord Unit Calcd Act # Item # Mat. # Description Qty Price Total* Tot 1 000010 HLMT5000 Helmet 100 $27.00 $270.00 $270.00 1 000020 FAID6000 First Aid Kit 999 ETC. 2 000010 SHRT4000 T-Shirt 999 ETC. 1 000020 HLMT5000 Helmet 999 ETC. GRAND TOTAL VALUE: $999999.99 GRAND TOTAL QUANTITY 9999 *What you calculate the total for this item to be. 2. The second should look like this: Sales Order Basic Information Order# Customer Creator Total Value % of Grand Total 1 1 KLEINH 18,800.00 58% 2 4 KOCHE 4,500.00 13.9% 3 6 HERREMAD 9,035.00 28% GRAND TOTAL: $32,235.00 3. The third report should be about Materials, be formatted appropriately and contain Material Number, the person who created it, the material type and the material group. Can you find a way to put in the material description?? EXTRA POINTS FOR THIS.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/05/2011 for the course MGT 475 taught by Professor Klein during the Winter '11 term at Grand Valley State.

Page1 / 2

W11MGT475PA2_FirstReport - MGT475 H. Klein Assignment 02...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online