Cross-Tab row headers not lining up right

Nathan · Post by **Nathan** » Thu Feb 09, 2012 11:01 am

AIR Designer
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

Here is the XSD file:

Code: Select all

And the XML data:

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

Post by **HighAley** » Fri Feb 10, 2012 3:52 am

Hello.

We know about this issue.
At this moment, the cross-tab component is a complicated one (in terms of the engine).
We have plans to redesign the cross-tab engine, but it is hard to when it will be available.

Thank you.