4.625in
Store ID
true
=Fields!StoreID.Value
=Fields!TotalSales.Value
=Fields!TotalSales.Value
Y1
=Fields!TotalProfit.Value
=Fields!TotalProfit.Value
Y1
3in
0.25in
Pastel
=Fields!SaleYear.Value
Plain
20
Orthographic
20
Real
Chart title
0.25in
Column
Axis Y
true
5.875in
Total Sales
true
Y1
DataSet1
0.25in
true
Store ID
true
Total Sales
true
Total Profit
true
Country
0.25in
=IIF(Fields!Country.Value="USA", "C:\Users\mateenf\Pictures\junk\USSalesReport.rdlx", "C:\Users\mateenf\Pictures\junk\CanadaSalesReportr.rdlx")
true
=Fields!StoreID.Value
true
=Fields!TotalSales.Value
true
=Fields!TotalProfit.Value
=IIF(Country.Value="USA", "C:\Users\mateenf\Pictures\junk\USSalesReport.rdlx", "C:\Users\mateenf\Pictures\junk\CanadaSalesReportr.rdlx")
true
=Fields!Country.Value
1.25in
0.25in
0.6666667in
1.625in
2.125in
1.5in
0.25in
true
Year:
true
TextBox10
=Fields!SaleYear.Value
true
true
=Fields!Year.Value
3.375in
5.916667in
1
1in
1in
11in
8.5in
1in
1in
6.5in
initial catalog=Reels;integrated security=SSPI;data source=localhost;persist security info=False;
SQL
true
SaleYear
RegionID
Region
DistrictID
District
StoreID
StoreName
TotalSales
TotalProfit
Country
select dbo.StoreSalesByYear.*, dbo.CustomerReceipt.Country
from dbo.StoreSalesByYear inner join dbo.CustomerReceipt on dbo.StoreSalesByYear.StoreName = dbo.CustomerReceipt.StoreName order by StoreID asc
DataSource1