2.625in
true
0.25in
1.5in
US Sales Report
3.125in
1
DataSet2
true
0.25in
true
TextBox1
Customer
true
TextBox2
Sale Amount
true
TextBox3
Total Amount
0.25in
true
TextBox4
=Fields!Customer.Value
true
TextBox5
=Fields!SalesAmount.Value
true
TextBox6
=Fields!TotalAmount.Value
1.75in
0.125in
2.25in
2.125in
2in
0.25in
true
TextBox10
Employee Number:
true
=Fields!Employee.Value
true
=Fields!Employee.Value
0.25in
true
TextBox16
=Fields!Year.Value
true
TextBox17
true
TextBox18
=Fields!Year.Value
0.75in
6.375in
1in
1in
11in
8.5in
1in
1in
6.5in
initial catalog=Reels;integrated security=SSPI;data source=localhost;persist security info=False;
SQL
true
SaleDate
TotalAmount
Description
MediaID
SalesID
Store
StoreName
SELECT Sale.SaleDate, Sale.TotalAmount, MediaType.Description, MediaType.MediaID, Sale.SalesID,
Sale.Store, Store.StoreName FROM Store INNER JOIN
(Sale INNER JOIN (MediaType INNER JOIN (MovieProduct INNER JOIN SaleDetails
ON MovieProduct.ProductID = SaleDetails.ProductID) ON MediaType.MediaID =
MovieProduct.MediaType) ON Sale.SalesID = SaleDetails.SaleID)
ON Store.StoreID = Sale.Store;
DataSource1
SalesID
Customer
Store
Employee
Year
TaxPercent
SalesAmount
TotalAmount
SELECT [SalesID]
,[Customer]
,[Store]
,[Employee]
,YEAR([SaleDate]) as Year
,[TaxPercent]
,[SalesAmount]
,[TotalAmount]
FROM [Reels].[dbo].[Sale]
DataSource1