Reports.Fx Version: 2012.1.1205 from 2012.01.12
When i create a cross-tab report the row headers are not lined up properly. It looks like that the Summary columns are throwing it off, but only when you are using the vertical Summary alignment. in the example below notice how the two row columns are merged under the first row column and the second row header is being used for the Summary header column.
Here is an example report of the problem with a Cross-Tab in it:
Code: Select all
Connection1
Connection1
C:/wamp/www/reports/custom/valero/data.xml
C:/wamp/www/reports/custom/valero/data.xsd
Labor
PID,System.String
DateWorked,System.String
DateFormated,System.String
Shift,System.String
PT,System.String
PTTotal,System.String
Direct,System.String
WorkDescription,System.String
EmployeeName,System.String
TeamWO,System.String
CustomerWO,System.String
Classification,System.String
OTRate,System.String
PTRate,System.String
Contract,System.String
CustomerPO,System.String
Lodging,System.String
PerDiem,System.String
Mob,System.String
ST,System.String
STRate,System.String
STTotal,System.String
OT,System.String
OTTotal,System.String
LaborHrs,System.String
LaborCharge,System.String
TravelHrs,System.String
TravelCharge,System.String
TotalCharge,System.String
Labor
Connection1.row
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.03,4.88,2.52
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
0,1.24,2.2,0.6
Arial,10
7e9286908e1c71a9e8736287a126ff63
0,0,0,0
CrossTab1_RowTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
0,0.22,1,0.4
Arial,10
5de2ca620cb51adaf4346287a128bb3d
0,0,0,0
False
CrossTab1_Row1_Title
AllowMove, AllowResize, AllowSelect, AllowChange
EmployeeName
[105:105:105]
Row:CrossTab1_Row1
All;[155:155:155];1;Solid;False;4;Black
White
1.9,0.64,0.3,0.2
Arial,10
7faec9bf64c1f872c0e362885da68a9b
0,0,0,0
CrossTab1_SumHeader1
AllowMove, AllowResize, AllowSelect, AllowChange
ST
[105:105:105]
All;[155:155:155];1;Solid;False;4;Black
White
1.9,0.84,0.3,0.2
Arial,10
a5adc122c025748cd04862885da6b460
0,0,0,0
CrossTab1_SumHeader2
AllowMove, AllowResize, AllowSelect, AllowChange
OT
[105:105:105]
All;[155:155:155];1;Solid;False;4;Black
White
1.9,1.04,0.3,0.2
Arial,10
37c38b6b57678ea606b8628867ad9ce5
0,0,0,0
CrossTab1_SumHeader3
AllowMove, AllowResize, AllowSelect, AllowChange
PD
[105:105:105]
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
3.37,0.22,0.51,0.4
Arial,10
c0747ff73c3f137d5bdf62888c929ed6
0,0,0,0
CrossTab1_ColTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
0,0,2.2,0.2
Arial,10
546a55dcb62a87c64c9562888c924717
0,0,0,0
CrossTab1_LeftTitle
AllowMove, AllowResize, AllowSelect, AllowChange
Labor
[105:105:105]
LeftTitle
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
3.37,0.42,0,0
Arial,10
4b05d181dcb2100a09a862889f4da6b1
0,0,0,0
CrossTab1_ColTotal2
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
1,1.24,0,0
Arial,10
e619e6bfb24e46da654a62904da5bd0d
0,0,0,0
CrossTab1_RowTotal2
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
1,0.22,1.2,0.4
Arial,10
96a53937c5901b5b56ef62904da6204c
0,0,0,0
CrossTab1_Row2_Title
AllowMove, AllowResize, AllowSelect, AllowChange
Classification
[105:105:105]
Row:CrossTab1_Row2
EmployeeName
All;[155:155:155];1;Solid;False;4;Black
White
0,0.64,1,0.6
{Labor.EmployeeName}
Arial,10
9bd36ff7a96fc68f928e6287a1158688
0,0,0,0
CrossTab1_Row1
AllowMove, AllowResize, AllowSelect, AllowChange
EmployeeName
[105:105:105]
7e9286908e1c71a9e8736287a126ff63
{Labor.EmployeeName}
Classification
All;[155:155:155];1;Solid;False;4;Black
White
1,0.64,0.9,0.6
{Labor.Classification}
Arial,10
ae41235cd005f2c9352162904da20b8c
0,0,0,0
CrossTab1_Row2
AllowMove, AllowResize, AllowSelect, AllowChange
False
Classification
[105:105:105]
e619e6bfb24e46da654a62904da5bd0d
{Labor.Classification}
CustomerPO
All;[155:155:155];1;Solid;False;4;Black
White
2.22,0.22,1.15,0.2
{Labor.CustomerPO}
Arial,10
02a8e3307abbae3935cc62888c8eadd3
0,0,0,0
CrossTab1_Column1
AllowMove, AllowResize, AllowSelect, AllowChange
CustomerPO
[105:105:105]
c0747ff73c3f137d5bdf62888c929ed6
{Labor.CustomerPO}
CustomerWO
All;[155:155:155];1;Solid;False;4;Black
White
2.22,0.42,1.15,0.2
{Labor.CustomerWO}
Arial,10
26e6ef19fab8b2a1ea2062889f46c239
0,0,0,0
CrossTab1_Column2
AllowMove, AllowResize, AllowSelect, AllowChange
False
CustomerWO
[105:105:105]
4b05d181dcb2100a09a862889f4da6b1
{Labor.CustomerWO}
ST
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
2.22,0.64,1.15,0.2
Arial,10
91486a59557ffe2a1a60628853880d3b
Right
0,0,0,0
CrossTab1_Sum1
AllowMove, AllowResize, AllowSelect, AllowChange
0
Black
{Labor.ST}
OT
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
2.22,0.84,1.15,0.2
Arial,10
bae1fc0aed293acd079b62885d9fc75d
Right
0,0,0,0
CrossTab1_Sum2
AllowMove, AllowResize, AllowSelect, AllowChange
0
Black
{Labor.OT}
PD
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
2.22,1.04,1.15,0.2
Arial,10
928d1052e5fd462ca79b628867a70bba
Right
0,0,0,0
CrossTab1_Sum3
AllowMove, AllowResize, AllowSelect, AllowChange
0
Black
{Labor.PD}
All;[155:155:155];1;Solid;False;4;Black
White
2.22,0,1.66,0.2
Arial,10
7facb052548fd601315662904da67485
0,0,0,0
CrossTab1_RightTitle
AllowMove, AllowResize, AllowSelect, AllowChange
CustomerPO, CustomerWO
[105:105:105]
RightTitle
Labor
CrossTab1
50ede38adf61073447b56281cc406c7b
0.39,0.39,0.39,0.39
Page1
Landscape
8.27
11.69
Arial,100
[50:0:0:0]
Report
02/09/2012 08:50:02 AM
02/09/2012 08:26:08 AM
C:\wamp\www\reports\custom\valero\TracksTimeDaily.mrt
3c8923cfe2ba871d9a876297b0cb0a23
Report
Inches
2012.1.1205
CSharp
Code: Select all
Code: Select all
52012-02-07Tue 02/07Day00Direct(NULL)Adams, Rex Lee14612246992203746LVL II Tech4545NDE RateseCPO-1f03504351405225936520400
52012-02-07Tue 02/07Day00Direct(NULL)Arroyo, Uriel 14612246992421941LVL II Tech4545NDE RateseCPO-1f035083528041801246000495
52012-02-07Tue 02/07Day00Direct(NULL)Adams, Rex Lee14612246992585507LVL II Tech4545NDE RateseCPO-1f00083528041801246020460
52012-02-07Tue 02/07Day00Direct(NULL)Adams, Rex Lee14612246992615664LVL II Tech4545NDE RateseCPO-1f000235704180625020250
52012-02-07Tue 02/07Day00Direct(NULL)Arroyo, Uriel 14612246992615646LVL II Tech4545NDE RateseCPO-1f00003500000000
52012-02-07Tue 02/07Day00Direct(NULL)Adams, Rex Lee14612246992421941LVL II Tech4545NDE RateseCPO-1f00083528041801246020460