Code: Select all
Connection1
Connection1
C:\wamp\www\reports\Data2.xml
C:\wamp\www\reports\Data2.xsd
NonLabor
id,System.String
project_id,System.String
DateUsed,System.String
Shift,System.String
Category,System.String
UnitQty,System.String
UnitCost,System.String
UnitMeasure,System.String
UnitCharge,System.String
EmployeeName,System.String
DI,System.String
Scope,System.String
OOP,System.String
TeamWO,System.String
CustomerWO,System.String
Description,System.String
Contract,System.String
Markup,System.String
CustomerPO,System.String
Total,System.String
NonLabor
Connection1.row
,FromDate,Date,System.DateTime,_x0031_1_x002F_06_x002F_2011_x0020_09_x003A_53_x003A_25_x0020_AM,False,False
,CPO,Customer_x0020_PO,System.String,CPO_x002D_1,False,False
,CWO,Customer_x0020_WO,,System.String,CWO_x002D_1,False,False,False,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1_x002E_0_x0022__x0020_encoding_x003D__x0022_utf_x002D_8_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_type_x003D__x0022_Flex_x0022__x0020_version_x003D__x0022_1_x002E_02_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x002F__x003E__x003C_KeysColumn_x003E_Labor_x002E_TeamWO_x003C__x002F_KeysColumn_x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x002F__x003E__x003C_ValuesColumn_x003E_Labor_x002E_TeamWO_x003C__x002F_ValuesColumn_x003E__x003C__x002F_StiSerializer_x003E_
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
All;Black;1;None;False;4;Black
Transparent
0,0.2,10.2,0.15
All;Black;1;Solid;False;4;Black
Transparent
0,0,2.3,0.15
Arial,6,Bold
0,0,0,0
Text50
Equipment
Black
Bottom
All;Black;1;Solid;False;4;Black
Transparent
4.4,0,0.7,0.15
Arial,6
Center
0,0,0,0
Text55
Subtotal
Black
Bottom
All;Black;1;Solid;False;4;Black
Transparent
2.3,0,0.5,0.15
Arial,6
Center
0,0,0,0
Text51
Each
Black
Bottom
All;Black;1;Solid;False;4;Black
Transparent
2.8,0,0.5,0.15
Arial,6
Center
0,0,0,0
Text52
Qty
Black
Bottom
All;Black;1;Solid;False;4;Black
Transparent
3.3,0,0.5,0.15
Arial,6
Center
0,0,0,0
Text53
UOM
Black
Bottom
All;Black;1;Solid;False;4;Black
Transparent
3.8,0,0.6,0.15
Arial,6
Center
0,0,0,0
Text54
Cost
Black
Bottom
ColumnHeaderBand1
True
Transparent
0,0.75,10.2,0.15
DownThenAcross
2
All;Black;1;Solid;False;4;Black
Transparent
0,0,2.3,0.15
Arial,6
0,0,0,0
Text56
{NonLabor.Description}
Black
All;Black;1;Solid;False;4;Black
Transparent
3.8,0,0.6,0.15
Arial,6
Right
0,0,0,0
Text59
{NonLabor.UnitCharge}
Black
1
1
False
All;Black;1;Solid;False;4;Black
Transparent
2.8,0,0.5,0.15
Arial,6
Center
0,0,0,0
Text57
{NonLabor.UnitQty}
Black
1
False
All;Black;1;Solid;False;4;Black
Transparent
3.3,0,0.5,0.15
Arial,6
Center
0,0,0,0
Text58
{NonLabor.UnitMeasure}
Black
All;Black;1;Solid;False;4;Black
Transparent
4.4,0,0.7,0.15
Arial,6
Right
0,0,0,0
Text60
{NonLabor.Total}
Black
1
1
False
All;Black;1;Solid;False;4;Black
Transparent
2.3,0,0.5,0.15
Arial,6
Center
0,0,0,0
Text76
Black
Bottom
NonLabor
Category,EqualTo,Equipment,,String
DataBand2
Top;Black;1;Solid;False;4;Black
Transparent
0,1.3,10.2,0.2
All;Black;1;Solid;False;4;Black
Transparent
9.5,0,0.7,0.15
Arial,6,Bold
Right
0,0,0,0
Text61
{Sum(DataBand2,NonLabor.Total)}
Black
1
1
False
Bottom
Transparent
8.4,0,1.1,0.15
Arial,6
Right
0,0,0,0
Text62
Equipment Total
Black
Bottom
FooterBand2
True
Transparent
0,1.9,10.2,0.15
All;Black;1;Solid;False;4;Black
Transparent
0,0,2.3,0.15
Arial,6,Bold
0,0,0,0
Text63
Misc.
Black
Bottom
All;Black;1;Solid;False;4;Black
Transparent
4.5,0,0.6,0.15
Arial,6
Center
0,0,0,0
Text64
Subtotal
Black
Bottom
All;Black;1;Solid;False;4;Black
Transparent
2.3,0,0.5,0.15
Arial,6
Center
0,0,0,0
Text65
Each
Black
Bottom
All;Black;1;Solid;False;4;Black
Transparent
2.8,0,0.4,0.15
Arial,6
Center
0,0,0,0
Text66
Qty
Black
Bottom
All;Black;1;Solid;False;4;Black
Transparent
3.2,0,0.4,0.15
Arial,6
Center
0,0,0,0
Text67
UOM
Black
Bottom
All;Black;1;Solid;False;4;Black
Transparent
3.6,0,0.5,0.15
Arial,6
Center
0,0,0,0
Text68
Cost
Black
Bottom
All;Black;1;Solid;False;4;Black
Transparent
4.1,0,0.4,0.15
Arial,6
Center
0,0,0,0
Text87
Markup
Black
Bottom
ColumnHeaderBand2
True
Transparent
0,2.45,10.2,0.15
DownThenAcross
2
All;Black;1;Solid;False;4;Black
Transparent
0,0,2.3,0.15
Arial,6
0,0,0,0
Text69
{NonLabor.Description}
Black
All;Black;1;Solid;False;4;Black
Transparent
3.6,0,0.5,0.15
Arial,6
Right
0,0,0,0
Text70
{IIF(NonLabor.Category == "Third Party", NonLabor.UnitCost, NonLabor.UnitCharge)}
Black
1
1
False
All;Black;1;Solid;False;4;Black
Transparent
2.8,0,0.4,0.15
Arial,6
Center
0,0,0,0
Text71
{NonLabor.UnitQty}
Black
1
False
All;Black;1;Solid;False;4;Black
Transparent
3.2,0,0.4,0.15
Arial,6
Center
0,0,0,0
Text72
{NonLabor.UnitMeasure}
Black
All;Black;1;Solid;False;4;Black
Transparent
4.5,0,0.6,0.15
Arial,6
Right
0,0,0,0
Text73
{NonLabor.Total}
Black
1
1
False
All;Black;1;Solid;False;4;Black
Transparent
2.3,0,0.5,0.15
Arial,6
Center
0,0,0,0
Text77
Black
1
False
All;Black;1;Solid;False;4;Black
Transparent
4.1,0,0.4,0.15
Arial,6
Center
0,0,0,0
Text88
{IIF(NonLabor.Category == "Third Party", NonLabor.Markup + "%", "")}
Black
NonLabor
Category,NotEqualTo,Equipment,,String
DataBand3
Top;Black;1;Solid;False;4;Black
Transparent
0,3,10.2,0.15
All;Black;1;Solid;False;4;Black
Transparent
9.5,0,0.7,0.15
Arial,6,Bold
Right
0,0,0,0
Text74
{Sum(DataBand3,NonLabor.Total)}
Black
1
1
False
Bottom
Transparent
8.4,0,1.1,0.15
Arial,6
Right
0,0,0,0
Text75
Misc. Total
Black
Bottom
FooterBand3
True
Transparent
0,3.55,10.2,1.5
All;Black;1;Solid;False;4;Black
Transparent
9.1,0.4,1.1,0.2
Arial,11,Bold
Right
0,0,0,0
Text78
{Sum(DataBand2,NonLabor.Total)}
Black
1
1
False
Center
Transparent
7.7,0.4,1.4,0.2
Arial,11
0,0,0,0
Text79
Total DataBand2
Black
All;Black;1;Solid;False;4;Black
Transparent
9.1,0.65,1.1,0.2
Arial,11,Bold
Right
0,0,0,0
Text6
{Sum(DataBand3,NonLabor.Total)}
Black
1
1
False
Center
Transparent
7.7,0.65,1.4,0.2
Arial,11
0,0,0,0
Text7
Total DataBand3
Black
Transparent
6.9,0.95,2.2,0.2
Arial,11
0,0,0,0
Text8
Total DataBand2 + DataBand3
Black
All;Black;1;Solid;False;4;Black
Transparent
9.1,0.95,1.1,0.2
Arial,11,Bold
Right
0,0,0,0
Text9
{Sum(DataBand2,NonLabor.Total) + Sum(DataBand3,NonLabor.Total)}
Black
1
1
False
Center
ReportSummaryBand1
9ac2a67ba08013cb3ea3b381e040921f
0.4,0.4,0.4,0.4
Page1
Landscape
8.5
11
Letter
Arial,100
[50:0:0:0]
Report
02/03/2012 03:44:29 PM
01/06/2012 08:52:40 AM
C:\wamp\www\reports\PmgrTimesheet-mock.mrt
95b7e079db715376549e452cf7c93968
Report
Inches
2012.1.1205
CSharp