data1 127cb3789d524fac9ba47920640a4d2b data1 C:\Users\quocp\Desktop\data2.xml C:\Users\quocp\Desktop\schema1.xsd ThirteenPeriodTable SubDept,System.String StoreName,System.String StoreID1,System.Int32 StoreID,System.Int32 StartDate,System.DateTime salesEx,System.Decimal qty,System.Decimal profit,System.Decimal PriceGroup,System.String PLUG_UID,System.Byte[] Period,System.String ItemUn,System.String ItemNo,System.String Item,System.String GP,System.Decimal EndDate,System.DateTime DeptSortOrder,System.Int64 DeptName,System.String Dept,System.String costEx,System.Decimal APN,System.String Accuracy,System.Int32 5c484ca47b8f470290fdce489f9e28b5 ThirteenPeriodTable data1.ThirteenPeriodTable PriceGroupCrossSum TRANSFORM,qty,qty,System.Decimal,Sum_x0028_ThirteenPeriodTable.qty_x0029_,e3575722e97d496c8aba25f4c186b1ce,Measure TRANSFORM,PriceGroup,PriceGroup,System.String,ThirteenPeriodTable.PriceGroup,_x0031_2facb4628cf4cfea37e67ec4aac1af7,Dimension TRANSFORM,EndDate,EndDate,System.DateTime,ThirteenPeriodTable.EndDate,_x0039_e391cc115aa4763b5175048e7c8fc58,Dimension 25a22f70fd324542aedd7c79ae5d19d6 PriceGroupCrossSum PriceGroupCrossSum Descending 9e391cc115aa4763b5175048e7c8fc58 12facb4628cf4cfea37e67ec4aac1af7 Items SubDept,System.String StoreName,System.String StoreID,System.Int32 PriceGroup,System.String ItemUn,System.String ItemNo,System.String Item,System.String DeptSortOrder,System.Int64 DeptName,System.String Dept,System.String APN,System.String 78489db6990b44259b211085c6619dac Items data1.Items FooterDBSum TRANSFORM,qty,qty,System.Decimal,Sum_x0028_ThirteenPeriodTable.qty_x0029_,_x0031_54a2c5bf69d47a4aa85537f83c41207,Measure TRANSFORM,EndDate,EndDate,System.DateTime,ThirteenPeriodTable.EndDate,_x0036_0b49be8b859428499fbe2cd533f5d3f,Dimension a0e7c183c82b4311b641aaab142ed3d5 FooterDBSum DataTransformation CrossingData Period,System.String EndDate,System.DateTime 3f6b5504674e4606a1546b46eea72bc8 CrossingData data1.CrossingData Items ItemUn 31d8f024fe2f49f394546569e240aaec Items Items ItemUn CrossingData EndDate 8ec9ad5aadc14855b99fb3550a1b2654 CrossingData CrossingData EndDate PriceGroupCrossingData EndDate ff9e31990c6e41c180ddb7ef3897a803 PriceGroupCrossingData PriceGroupCrossingData EndDate ,Version,Version,,System.String,,True,False,False,False,,_x0031_095ce87cfa1419dabb863d3345ddbb4 ,TimeZoneOffset,TimeZoneOffset,,System.Double,,True,False,False,False,,_x0032_5bada014c9740c7af3c5efafc9c6b75 ,StoreName,StoreName,,System.String,,True,False,False,False,,_x0038_22981145df9424fbc7bc723cce37e72 ,ShowSOH,ShowSOH,,System.Boolean,false,True,False,False,False,,_x0031_d7f9cc0ab704df6a256f631512901ee ,selectedPeriod,selectedPeriod,,System.String,,False,False,False,False,,a419b40465444ed0bc60449814431d2a ,Sales,Sales,,System.Boolean,false,False,False,False,False,,_x0031_8c5974c3365411dbe6e133550ecfa2a ,Profit,Profit,,System.Boolean,false,False,False,False,False,,_x0035_a4c04e3b6e1467bb5d905af7d25f957 ,IncludeZero,IncludeZero,,System.Boolean,false,False,False,False,False,,_x0033_02cf61c6d434882adaa4d54fad37c4a ,GP,GP,,System.Boolean,false,False,False,False,False ,FilterDesc,FilterDesc,,System.String,,True,False,False,False ,ExpandSubDepartments,ExpandSubDepartments,,System.Boolean,false,False,False,False,False ,ExpandDepartments,ExpandDepartments,,System.Boolean,false,False,False,False,False ,DateRange,DateRange,,System.String,,True,False,False,False,,c7cc7fd6bf4842359dda0dd4823a41a1 ,CurrencySymbol,CurrencySymbol,,System.String,,True,False,False,False ,CrossingItemsCount,CrossingItemsCount,,System.Int32,,False,False,False,False ,Cost,Cost,,System.Boolean,false,True,False,False,False ,AdditionalFilteringDescription,AdditionalFilteringDescription,,System.String,,True,False,False,False EngineV2 859a77a8d36d46ddb3e43fe8561a9b51 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,88,1 Transparent 10.2,0,15,0.8 Arial,16,Bold Center 0,0,0,0 Text1 Report Black Expression Center PageHeaderBand1 Transparent 0,18.2,88,0.8 PageFooterBand1 None;Transparent;1;None;False;4;Transparent [76:104:162] 0,2.2,88,2.4 Transparent 0,0,14.9,2.4 [76:104:162] 0,0,14.9,1.6 Top Panel1HB [76:104:162] 0,1.6,14.9,0.8 Transparent True 0,0,2.5,0.8 Left Arial,9,Bold True 3,3,0,0 StoreHB1 Store White ,,,,WordWrap=True,A=0 Expression Center Transparent True 2.5,0,2.5,0.8 Left Arial,9,Bold True 3,3,0,0 ApnHB1 APN White ,,,,WordWrap=True,A=0 Expression Center Transparent True 5,0,7.8,0.8 Left Arial,9,Bold True 3,3,0,0 DescriptionHB1 Description White ,,,,WordWrap=True,A=0 Expression Center Transparent True 12.8,0,2,0.8 Left Arial,9,Bold True Right 3,3,0,0 TQtyHB1 Total Qty White ,,,,WordWrap=True,A=0 Expression Center Top Panel2HB CrossHeaderBandHB Transparent False True 14.9,0,3,2.4 [76:104:162] True 0,0,3,0.8 All;[255:255:255];1;Solid;False;4;Black Transparent True 0,0,3,0.8 Top Arial,9,Bold True Center 3,3,0,0 Text22 {CrossingData.Period} {selectedPeriod=="Monthly"? MonthName(CrossingData.EndDate): selectedPeriod=="Weekly"? "": Format("{0:dddd}",CrossingData.EndDate) } White ,,,,WordWrap=True,A=0 Expression Center Top, Left, Right;[255:255:255];1;Solid;False;4;Black Transparent True 0,0.8,3,0.8 Top Arial,9,Bold True Center 3,3,0,0 Text14 {Format("{0:dd MMM yy}",CrossingData.EndDate)} White ,,,,WordWrap=True,A=0 Expression Center Top Panel1 [76:104:162] True 0,0.8,3,0.8 All;[255:255:255];1;Solid;False;4;Black Transparent True 0,0,3,0.8 Top Arial,9,Bold True Center 3,3,0,0 Text15 {Format("{0:dd MMM yy}",CrossingData.EndDate)} White ,,,,WordWrap=True,A=0 Expression Center Top Panel2 [76:104:162] True 0,1.6,3,0.8 Top, Left, Right;[255:255:255];1;Solid;False;4;Black Transparent True 0,0,3,0.8 Left Arial,9,Bold True Right 3,3,0,0 QtyCDB1 Qty White ,,,,WordWrap=True,A=0 Expression Center Top Panel5 CrossingData CrossDataBand1 HeaderBand1 True [165:165:165] 0,5.4,88,0.6 Transparent True 0,0,9.3,0.6 Left Arial,8,Bold True 3,3,0,0 Text3 {Items.PriceGroup} Black ,,,,WordWrap=True,A=0 DataColumn Center {Items.PriceGroup} GroupHeaderBand1 None;Transparent;1;None;False;4;Transparent Transparent 0,6.8,88,0.6 Transparent 0,0,14.9,0.6 Transparent True 0,0,2.5,0.6 Left Arial,8 True 3,3,0,0 Text8 {Items.StoreName} Black ,,,,WordWrap=True,A=0 Expression Center Transparent True 2.5,0,2.5,0.6 Left Arial,8 True 3,3,0,0 Text17 {Items.APN} Black ,,,,WordWrap=True,A=0 DataColumn Center Transparent True 5,0,7.9,0.6 Left Arial,8 True 3,3,0,0 Text18 {Items.Item} Black ,,,,WordWrap=True,A=0 DataColumn Center Transparent True 12.9,0,2,0.6 Left Arial,8,Bold True Right 3,3,0,0 TQtyDB1 {SumIf(CrossDataBandItems,ThirteenPeriodTable.qty,ThirteenPeriodTable.Items.ItemUn == Items.ItemUn)} Black 2 , 1 DecimalDigits ,,,,WordWrap=True,A=0 Expression Center CrossHeaderBandDB Transparent True 14.9,0,3,0.6 Left;Black;1;Solid;False;4;Black Transparent True 0,0,3,0.6 Left Arial,8 True Right 3,3,0,0 QtyCDB2 {SumIf(CrossDataBandCrossingData,ThirteenPeriodTable.qty,ThirteenPeriodTable.Items.ItemUn == Items.ItemUn)} Black 2 , 1 DecimalDigits ,,,,WordWrap=True,A=0 Expression Center CrossingData CrossDataBand2 Transparent True 17.9,0,4,0.6 CrossingData ThirteenPeriodTable CrossDataBandCrossingData Transparent True 21.9,0,4,0.6 Items ThirteenPeriodTable CrossDataBandItems Items DataBand1 Row: Light Gray Background [216:216:216] 0,8.2,88,0.6 Transparent 0,0,14.9,0.6 Transparent True 0,0,12.8,0.6 Left Arial,8,Bold True 3,3,0,0 Text7 Price Group Total Black 2 , 1 DecimalDigits ,,,,WordWrap=True,A=0 Expression Center Transparent True 12.8,0,2,0.6 Left Arial,8,Bold True Right 3,3,0,0 Text4 {SumIf(CrossDataBandItems,ThirteenPeriodTable.qty,ThirteenPeriodTable.Items.ItemUn == Items.ItemUn)} Black 2 , 1 DecimalDigits ,,,,WordWrap=True,A=0 Expression Center CrossHeaderBand1 [255:255:0] True 14.9,0,3,0.6 Left;Black;1;Solid;False;4;Black [255:255:0] True 0,0,3,0.6 Left Arial,8,Bold True Right 3,3,0,0 Text5 {SumIf(CrossDataBand5,ThirteenPeriodTable.qty,ThirteenPeriodTable.Items.PriceGroup == Items.PriceGroup)} [255:0:0] 2 , 1 DecimalDigits ,,,,WordWrap=True,A=0 Expression Center CrossingData CrossDataBand4 Transparent True 17.9,0,4,0.6 PriceGroupCrossingData PriceGroupCrossSum CrossDataBand5 Transparent True 21.9,0,4,0.6 Items ThirteenPeriodTable CrossDataBand6 GroupFooterBand1 None;Black;1;None;False;4;Black [76:104:162] 0,9.6,88,0.6 Transparent 0,0,14.9,0.6 Transparent True 0,0,12.8,0.6 Left Arial,9,Bold True 3,3,0,0 Text6 Report Total White ,,,,WordWrap=True,A=0 Expression Center Transparent True 12.8,0,2,0.6 Left Arial,8,Bold True Right 3,3,0,0 Text9 {Sum(CrossDataBandCrossingData,ThirteenPeriodTable.qty)} [255:255:255] 2 , 1 DecimalDigits ,,,,WordWrap=True,A=0 Expression Center CrossHeaderBand2 Transparent True 14.9,0,3,0.6 Left;Black;1;Solid;False;4;Black Transparent True 0,0,3,0.6 Left Arial,8 True Right 3,3,0,0 Text2 {FooterDBSum.qty} [255:255:255] 2 , 1 DecimalDigits ,,,,WordWrap=True,A=0 Expression Center FooterDBSum CrossDataBand3 FooterBand2 8f2eae0de11f4635b7dfd13a130700b6 1,1,1,1 Page1 Landscape 21 90 A4 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll ItemMovementReport 7/22/2024 4:06:04 PM 12/22/2020 9:15:45 AM C:\Users\quocp\Desktop\ItemMovementdsa23rt.mrt d053a0740770445c9638708f98d6852c ItemMovementReport Centimeters 2023.2.7.0 CSharp None;Black;1;None;False;4;Black [242:242:242] Arial,8 Center Row: Light Gray Background Red Black Center All;Black;1;Solid;False;4;Black [216:216:216] Arial,8 Center Row: Gray Background Red Black Center All;Black;1;Solid;False;4;Black [228:235:246] Arial,8 Center Row: Light blue Red Black Center