forked from hechenqingyuan/gitwms
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path16958bb428874794aed01df1979d81c9.frx
139 lines (139 loc) · 11 KB
/
16958bb428874794aed01df1979d81c9.frx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
<?xml version="1.0" encoding="utf-8"?>
<Report TextQuality="Regular" ReportInfo.Description="Demonstrates how to use expressions in the matrix. To do this: - create a matrix by dragging data from the Data Dictionary window; - doubleclick the item that you want to edit, and change the expression." ReportInfo.Created="05/15/2008 00:47:48" ReportInfo.Modified="10/04/2008 00:50:25" ReportInfo.CreatorVersion="1.0.0.0">
<Dictionary>
<TableDataSource Name="Categories" ReferenceName="NorthWind.Categories">
<Column Name="CategoryID" DataType="System.Int32"/>
<Column Name="CategoryName" DataType="System.String"/>
<Column Name="Description" DataType="System.String"/>
<Column Name="Picture" DataType="System.Byte[]" BindableControl="Picture"/>
</TableDataSource>
<TableDataSource Name="Customers" ReferenceName="NorthWind.Customers">
<Column Name="CustomerID" DataType="System.String"/>
<Column Name="CompanyName" DataType="System.String"/>
<Column Name="ContactName" DataType="System.String"/>
<Column Name="ContactTitle" DataType="System.String"/>
<Column Name="Address" DataType="System.String"/>
<Column Name="City" DataType="System.String"/>
<Column Name="Region" DataType="System.String"/>
<Column Name="PostalCode" DataType="System.String"/>
<Column Name="Country" DataType="System.String"/>
<Column Name="Phone" DataType="System.String"/>
<Column Name="Fax" DataType="System.String"/>
</TableDataSource>
<TableDataSource Name="Employees" ReferenceName="NorthWind.Employees">
<Column Name="EmployeeID" DataType="System.Int32"/>
<Column Name="LastName" DataType="System.String"/>
<Column Name="FirstName" DataType="System.String"/>
<Column Name="Title" DataType="System.String"/>
<Column Name="TitleOfCourtesy" DataType="System.String"/>
<Column Name="BirthDate" DataType="System.DateTime"/>
<Column Name="HireDate" DataType="System.DateTime"/>
<Column Name="Address" DataType="System.String"/>
<Column Name="City" DataType="System.String"/>
<Column Name="Region" DataType="System.String"/>
<Column Name="PostalCode" DataType="System.String"/>
<Column Name="Country" DataType="System.String"/>
<Column Name="HomePhone" DataType="System.String"/>
<Column Name="Extension" DataType="System.String"/>
<Column Name="Photo" DataType="System.Byte[]" BindableControl="Picture"/>
<Column Name="Notes" DataType="System.String"/>
<Column Name="ReportsTo" DataType="System.Int32"/>
</TableDataSource>
<TableDataSource Name="Order Details" ReferenceName="NorthWind.Order Details">
<Column Name="OrderID" DataType="System.Int32"/>
<Column Name="ProductID" DataType="System.Int32"/>
<Column Name="UnitPrice" DataType="System.Decimal"/>
<Column Name="Quantity" DataType="System.Int16"/>
<Column Name="Discount" DataType="System.Single"/>
</TableDataSource>
<TableDataSource Name="Orders" ReferenceName="NorthWind.Orders">
<Column Name="OrderID" DataType="System.Int32"/>
<Column Name="CustomerID" DataType="System.String"/>
<Column Name="EmployeeID" DataType="System.Int32"/>
<Column Name="OrderDate" DataType="System.DateTime"/>
<Column Name="RequiredDate" DataType="System.DateTime"/>
<Column Name="ShippedDate" DataType="System.DateTime"/>
<Column Name="ShipVia" DataType="System.Int32"/>
<Column Name="Freight" DataType="System.Decimal"/>
<Column Name="ShipName" DataType="System.String"/>
<Column Name="ShipAddress" DataType="System.String"/>
<Column Name="ShipCity" DataType="System.String"/>
<Column Name="ShipRegion" DataType="System.String"/>
<Column Name="ShipPostalCode" DataType="System.String"/>
<Column Name="ShipCountry" DataType="System.String"/>
</TableDataSource>
<TableDataSource Name="Products" ReferenceName="NorthWind.Products">
<Column Name="ProductID" DataType="System.Int32"/>
<Column Name="ProductName" DataType="System.String"/>
<Column Name="SupplierID" DataType="System.Int32"/>
<Column Name="CategoryID" DataType="System.Int32"/>
<Column Name="QuantityPerUnit" DataType="System.String"/>
<Column Name="UnitPrice" DataType="System.Decimal"/>
<Column Name="UnitsInStock" DataType="System.Int16"/>
<Column Name="UnitsOnOrder" DataType="System.Int16"/>
<Column Name="ReorderLevel" DataType="System.Int16"/>
<Column Name="Discontinued" DataType="System.Boolean" BindableControl="CheckBox"/>
<Column Name="EAN13" DataType="System.String"/>
</TableDataSource>
<TableDataSource Name="Shippers" ReferenceName="NorthWind.Shippers">
<Column Name="ShipperID" DataType="System.Int32"/>
<Column Name="CompanyName" DataType="System.String"/>
<Column Name="Phone" DataType="System.String"/>
</TableDataSource>
<TableDataSource Name="Suppliers" ReferenceName="NorthWind.Suppliers">
<Column Name="SupplierID" DataType="System.Int32"/>
<Column Name="CompanyName" DataType="System.String"/>
<Column Name="ContactName" DataType="System.String"/>
<Column Name="ContactTitle" DataType="System.String"/>
<Column Name="Address" DataType="System.String"/>
<Column Name="City" DataType="System.String"/>
<Column Name="Region" DataType="System.String"/>
<Column Name="PostalCode" DataType="System.String"/>
<Column Name="Country" DataType="System.String"/>
<Column Name="Phone" DataType="System.String"/>
<Column Name="Fax" DataType="System.String"/>
<Column Name="HomePage" DataType="System.String"/>
</TableDataSource>
<Relation Name="SuppliersProducts" ReferenceName="NorthWind.SuppliersProducts" ParentDataSource="Suppliers" ChildDataSource="Products" ParentColumns="SupplierID" ChildColumns="SupplierID"/>
<Relation Name="CategoriesProducts" ReferenceName="NorthWind.CategoriesProducts" ParentDataSource="Categories" ChildDataSource="Products" ParentColumns="CategoryID" ChildColumns="CategoryID"/>
<Relation Name="EmployeesOrders" ReferenceName="NorthWind.EmployeesOrders" ParentDataSource="Employees" ChildDataSource="Orders" ParentColumns="EmployeeID" ChildColumns="EmployeeID"/>
<Relation Name="ShippersOrders" ReferenceName="NorthWind.ShippersOrders" ParentDataSource="Shippers" ChildDataSource="Orders" ParentColumns="ShipperID" ChildColumns="ShipVia"/>
<Relation Name="CustomersOrders" ReferenceName="NorthWind.CustomersOrders" ParentDataSource="Customers" ChildDataSource="Orders" ParentColumns="CustomerID" ChildColumns="CustomerID"/>
<Relation Name="OrdersOrderDetails" ReferenceName="NorthWind.OrdersOrderDetails" ParentDataSource="Orders" ChildDataSource="Order Details" ParentColumns="OrderID" ChildColumns="OrderID"/>
<Relation Name="ProductsOrderDetails" ReferenceName="NorthWind.ProductsOrderDetails" ParentDataSource="Products" ChildDataSource="Order Details" ParentColumns="ProductID" ChildColumns="ProductID"/>
</Dictionary>
<ReportPage Name="Page1">
<ReportTitleBand Name="ReportTitle1" Width="718.2" Height="207.9">
<MatrixObject Name="Matrix1" Top="47.25" Width="319.18" Height="128.88" FixedRows="1" FixedColumns="1" DataSource="Order Details" Style="Green">
<MatrixColumns>
<Header Expression="[Order Details.Orders.Employees.FirstName] + " " + [Order Details.Orders.Employees.LastName]"/>
</MatrixColumns>
<MatrixRows>
<Header Expression="[Order Details.Products.ProductName]"/>
</MatrixRows>
<MatrixCells>
<Cell Expression="[Order Details.UnitPrice] * [Order Details.Quantity] * (decimal)(1 - [Order Details.Discount])"/>
</MatrixCells>
<TableColumn Name="Column1" Width="93.65" MaxWidth="151.2" AutoSize="true"/>
<TableColumn Name="Column2" Width="189" MaxWidth="189" AutoSize="true"/>
<TableColumn Name="Column3" Width="36.53" AutoSize="true"/>
<TableRow Name="Row1" Height="68.71" AutoSize="true">
<TableCell Name="Cell1" Border.Lines="All" Border.Color="White" Fill.Color="123, 164, 0" Text="Product" HorzAlign="Center" VertAlign="Center" Font="Tahoma, 8pt, style=Bold" TextFill.Color="White"/>
<TableCell Name="Cell2" Border.Lines="All" Border.Color="White" Fill.Color="123, 164, 0" Text="[Order Details.Orders.Employees.FirstName] + " " + [Order Details.Orders.Employees.LastName]" HorzAlign="Center" VertAlign="Center" Font="Tahoma, 8pt, style=Bold" TextFill.Color="White"/>
<TableCell Name="Cell7" Border.Lines="All" Border.Color="White" Fill.Color="123, 164, 0" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Tahoma, 8pt, style=Bold" TextFill.Color="White"/>
</TableRow>
<TableRow Name="Row2" Height="42.96" AutoSize="true">
<TableCell Name="Cell3" Border.Lines="All" Border.Color="White" Fill.Color="123, 164, 0" Text="[ProductName]" HorzAlign="Center" VertAlign="Center" Font="Tahoma, 8pt, style=Bold" TextFill.Color="White"/>
<TableCell Name="Cell4" Border.Lines="All" Border.Color="White" Fill.Color="158, 210, 0" Text="[[Order Details.UnitPrice] * [Order Details.Quantity] * (decimal)(1 - [Order Details.Discount])]" HorzAlign="Right" VertAlign="Center" Font="Tahoma, 8pt" Format="Currency" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator="," Format.CurrencySymbol="$" Format.PositivePattern="0" Format.NegativePattern="5"/>
<TableCell Name="Cell8" Border.Lines="All" Border.Color="White" Fill.Color="158, 210, 0" HorzAlign="Right" VertAlign="Center" Font="Tahoma, 8pt, style=Bold" Format="Currency" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.CurrencySymbol="$" Format.PositivePattern="0" Format.NegativePattern="5"/>
</TableRow>
<TableRow Name="Row3" Height="17.21" AutoSize="true">
<TableCell Name="Cell5" Border.Lines="All" Border.Color="White" Fill.Color="123, 164, 0" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Tahoma, 8pt, style=Bold" TextFill.Color="White"/>
<TableCell Name="Cell6" Border.Lines="All" Border.Color="White" Fill.Color="158, 210, 0" HorzAlign="Right" VertAlign="Center" Font="Tahoma, 8pt, style=Bold" Format="Currency" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.CurrencySymbol="$" Format.PositivePattern="0" Format.NegativePattern="5"/>
<TableCell Name="Cell9" Border.Lines="All" Border.Color="White" Fill.Color="158, 210, 0" HorzAlign="Right" VertAlign="Center" Font="Tahoma, 8pt, style=Bold" Format="Currency" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.CurrencySymbol="$" Format.PositivePattern="0" Format.NegativePattern="5"/>
</TableRow>
</MatrixObject>
<TextObject Name="Text1" Left="9.45" Top="9.45" Width="415.8" Height="18.9" Text="Products by Employees" Font="Tahoma, 10pt, style=Bold"/>
</ReportTitleBand>
</ReportPage>
</Report>