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
Summing Multiple Bands with the Same Data Source problem
Hello,
Can you please send us a sample report template with data, which reproduces the issue?
Thank you.
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
Here is the report template:
Here is the XSD File:
Here is the XML file with data:
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
Code: Select all
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
Hello,
The problem is solved.
The patch will be available in the next prerelease build.
Thank you.
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
Is there an estimated time when the release with this fix will be released?
This bug is a real issue for me.
This bug is a real issue for me.
Summing Multiple Bands with the Same Data Source problem
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.
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.