Creating reports and dashboards | Stimulsoft community forum

Reporting tool and data analytics tools for creating reports and dashboards in ASP.NET, ASP.NET MVC, .NET Core, Blazor, Angular, PHP, Python, WPF, JavaScript, and Java applications.
https://forum.stimulsoft.com/

Summing Multiple Bands with the Same Data Source problem

https://forum.stimulsoft.com/viewtopic.php?t=5329

Page 1 of 1

Summing Multiple Bands with the Same Data Source problem

Posted: Tue Jan 24, 2012 4:35 pm
by Nathan
AIR Designer
Fx Version: 2012.1.1205 from 2012.01.12
Flash Player: 11.1.102

I have a report with multiple Data Bands that use the same Data Source.
Each band just has a filter applied to it to give me different results per band.
Each DataBand has a FooterBand with a Sum TextField that sums a column to its appropriate DataBand.

Now the problem occurs in the ReportSummaryBand. I have a TextField in this band that uses the same function of each FooterBand (the SUM function) and I attempt to add them together to get a Grand Total of all DataBands, but only the Last SUM function value will get returned.

This only happens with DataBands that share the same Data Source.

Summing Multiple Bands with the Same Data Source problem

Posted: Wed Jan 25, 2012 10:06 am
by Ivan
Hello,

Can you please send us a sample report template with data, which reproduces the issue?

Thank you.

Summing Multiple Bands with the Same Data Source problem

Posted: Fri Feb 03, 2012 5:48 pm
by Nathan
Here is the report template:

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
Here is the XSD File:

Code: Select all
Here is the XML file with data:

Code: Select all

2852011-11-06DayEquipment1.50Each6(NULL)DirectOut Scope0146122462203746HT EquipmentHeat Treat Rates0CPO-19
2952011-09-08DayThird Party1250Day255(NULL)DirectIn Scope014612246CWO-1ManliftNDE Rates2CPO-1255
3052011-11-07DayEquipment20Each15(NULL)DirectIn Scope014612246CWO-1GrinderNDE Rates0CPO-130
3152011-11-06DayConsumable40Bag60(NULL)DirectOut Scope014612246CWO-1RagsNDE Rates0CPO-1240
3252011-11-06DayEquipment60Day35(NULL)DirectIn Scope014612246CWO-1GeneratorNDE Rates0CPO-1210
3352011-11-06DayEquipment10Each15(NULL)DirectIn Scope0146122462421941GrinderNDE Rates0CPO-115
3452011-11-06DayEquipment20Day50(NULL)DirectIn Scope014612246CWO-1H2S SensorNDE Rates0CPO-1100
3552011-11-06DayEquipment10Each115(NULL)DirectIn Scope014612246CWO-1TrailorNDE Rates0CPO-1115
3652011-11-06DayEquipment40Each75(NULL)DirectIn Scope014612246CWO-1TruckNDE Rates0CPO-1300
3752011-11-06DayConsumable40Bag60(NULL)DirectOut Scope0146122462527341RagsNDE Rates0CPO-1240
3852011-11-06DayEquipment40Each75(NULL)DirectIn Scope014612246CWO-1TruckNDE Rates0CPO-1300
3952011-11-06DayThird Party210Each10(NULL)DirectIn Scope0146122463268252ManliftHeat Treat Rates0CPO-120
4052011-11-06DayEquipment1.50Day50(NULL)DirectOut Scope014612246CWO-1DMS 2NDE Rates0CPO-175
4152011-12-16DayEquipment1.50Day35(NULL)DirectOut Scope014612246CWO-1GeneratorNDE Rates0CPO-152.5
4252011-12-16DayEquipment30Each15(NULL)DirectIn Scope014612246CWO-1GrinderNDE Rates0CPO-145
4352011-12-16DayEquipment1.50Day35(NULL)DirectOut Scope014612246CWO-1GeneratorNDE Rates0CPO-152.5
4452012-02-18DayEquipment1.50Each6(NULL)DirectOut Scope0146122462203746HT EquipmentHeat Treat Rates0CPO-19
4552011-11-06DayEquipment1.50Each6(NULL)DirectOut Scope0146122462203746HT EquipmentHeat Treat Rates0CPO-19
4652012-02-03DayEquipment50Day50(NULL)DirectIn Scope0146122462203746DMS 2NDE Rates0CPO-1250

Summing Multiple Bands with the Same Data Source problem

Posted: Tue Feb 07, 2012 3:50 pm
by Ivan
Hello,

The problem is solved.
The patch will be available in the next prerelease build.

Thank you.

Summing Multiple Bands with the Same Data Source problem

Posted: Mon Feb 20, 2012 6:23 pm
by Nathan
Is there an estimated time when the release with this fix will be released?
This bug is a real issue for me.

Summing Multiple Bands with the Same Data Source problem

Posted: Tue Feb 21, 2012 3:17 am
by Andrew
Hello,

It is already released and can be found either at http://www.stimulsoft.com/Downloads.aspx section Prerelease Builds as a trial version or as a licensed version at http://www.stimulsoft.com/RegisteredUse ... ?login=yes for registered users.

Thank you.
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited