Homework answers / question archive / For this assignment you are going to use SHW schema Create one Report Builder (

For this assignment you are going to use SHW schema Create one Report Builder (

Project Management

Share With

---

For this assignment you are going to use SHW schema

Create one Report Builder (.rdl) for each of the following, providing ALL the fields in each form.

 

a. Areport 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 Customer Name Order No. Order Date Part No. Quantity Price Subtotal

cary

va -¥

a HL

 

ca

 

oan |

o NY

 

cael Ae Total s STR) .o ERY

 

@ Allendale ar oe |) ey Psa] Pea

 

@ Awore areca) oe Cova coe ard

 

@ Brampton © Amandeep Paul Total 1 2.00020 862,000.90

 

© Andrew Winterburn © 00328 8/26/2010 = T23660 41 $29.99 $1,229.59

 

8/26/2010 653217 15 $129.99 $1,949.65

 

$6 $159.98 $3,179.44

 

& 00364 9/21/2011 123660 a4 $29.99 $1,319.56

 

9/21/2011 $26170 a $29.99 $1,229.59

 

9/21/2091 €35207 32 $2.99 $95.68

 

wW7 $62.97 $2,644.83

 

Total 173 tm 6

 

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 Invoce No: 000001 v

Invoice

Customers Mame: CRAIG DAKIN

Address: 1193 LAKEVIEW RD

Guelph ON

MIVSH7

Invoice Date: 2/12/2001

 

Invoice No. Part No. Price Quantity Subtotal

000001 HS6074 $1299 1 $1299

821488 $12 25 1 $12 25

Total $25.24
Submit all the views scripts (if you use views) and all RDLs (including one screenshot of a selection for each RDL) in one zipped (not rar) file to the dropbox using

the filename: YourNameAssignment3.zip

Your submission will be evaluated based on the following criteria:

eC lar) Deductions Mark

eee eC MOA CRO Olu ls t}

-Reportcsplays the corectinformation |S

[The information presentedis expandable to show undebing data ___—| 2 |

rTherepor shows sublolalsforeachgrouning | «dC

Aleks arefornatedanddoplyed Ti |

b. Sales Invoice with selectable invoice no. t]

-Reportcsplays the corectinfomation TS |

[Parameterispresentanditissetupprpety dT SC«dt C2

Datasetiteriseppied SS SSCdTSCSCSC*dC 2

FCustomerinfornationisdeplyes——SSSC*SCSC‘“‘“d(C C&S

-Alinvoie fields are fomnated and displayed |_| 4 |

c. Pie chart for sales units by part class ft]

-Reportispays the corectinfomaton |S |

-Parametersarepresent —SSSCSC~C~—‘isSC‘“‘‘*

[Dataset ttre areapnied ————SSSCSC~“~*~*~*~‘“‘—~*~sSC“‘*‘‘‘C*

Datalablesarestown |_|

d. Column or bar chart comparing ordering amount and invoice amount bE)

Report displays the corectinfommaton | S|

- Char tiles and axes areramed propery |_|

Assignment 5 Total: KU
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 property 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.