Interpretation MS SQL 9NTZSEhfQ7xCTJzcTkx3J9F6wYnnW7uF4kHtbGH0IjfgMLnrS2v6zctBudxOhOEq13D7AkVZuplvSb1Q5MTnG40g98vIA5P5aVq5WGBJYnfVVlPrYUtLgX9cvZhwTG3jxFS5zcU= 6b05946e72de4c229979b3d2a715a04c MS SQL dsMain zavod,System.String nomenkl,System.String rashod,System.Decimal prihod,System.Decimal ost,System.Int32 org,System.String objec,System.String numdoc,System.String ts,System.String tip,System.Int32 date,System.DateTime Name,System.String all1,System.Decimal all2,System.Decimal 30 f61b27a4fd37494b87fd50ad00db3be2 dsMain MS SQL date1,date1,33,100 date2,date2,33,100 SELECT f.Name zavod ,w.FullName nomenkl ,q.otgr rashod ,q.prih prihod ,q.ost ,s.FullName org ,ot.Name objec ,q.numdoc ,q.numts ts ,q.tip ,q.date ,u.Name ,q.all1 ,q.all2 FROM ( --Приход SELECT FactoryId fac, WareId ware, null ost, dld.Quantity prih, NULL otgr, d.SubjectId subj, d.ObjectTitleId obj, sd.Number numdoc, sd.VehicleNumber numts, d.Kind tip, d.Date date, NULL all1, null all2 FROM DocumentLineDetails dld INNER JOIN DocumentLines dl ON dl.Id = dld.LineId INNER JOIN Documents d ON d.id = dl.DocumentId INNER JOIN SubDocuments sd on sd.id = dld.SubDocumentId INNER JOIN Wares w ON dl.WareId =w.ID WHERE d.Kind = 1 AND sd.CreatedAt >= @date1 AND sd.CreatedAt <= @date2 AND COALESCE(d.ObjectTitleId, 0) IN ({addr.Count == 0 ? "NULL" : addr.ToQueryString()}) AND w.ParentID IN ({ware.Count == 0 ? "NULL" : ware.ToQueryString()}) AND d.FactoryId IN ({fac.Count == 0 ? "NULL" : fac.ToQueryString()}) AND COALESCE(d.SubjectId, 0) IN ({subj.Count == 0 ? "NULL" : subj.ToQueryString()}) UNION ALL --Отгрузка SELECT FactoryId, WareId, null, NULL, dld.Quantity, d.SubjectId, d.ObjectTitleId, sd.Number, sd.VehicleNumber, d.Kind, d.Date, NULL, null FROM DocumentLineDetails dld INNER JOIN DocumentLines dl ON dl.Id = dld.LineId INNER JOIN Documents d ON d.id = dl.DocumentId INNER JOIN SubDocuments sd on sd.id = dld.SubDocumentId INNER JOIN Wares w ON w.id = dl.WareId WHERE d.Kind = 2 AND sd.CreatedAt>=@date1 AND sd.CreatedAt<=@date2 AND COALESCE(d.ObjectTitleId, 0) IN ({addr.Count == 0 ? "NULL" : addr.ToQueryString()}) AND w.ParentID IN ({ware.Count == 0 ? "NULL" : ware.ToQueryString()}) AND d.FactoryId IN ({fac.Count == 0 ? "NULL" : fac.ToQueryString()}) AND COALESCE(d.SubjectId, 0) IN ({subj.Count == 0 ? "NULL" : subj.ToQueryString()}) UNION ALL SELECT q.fac,q.ware,q.ost,q.prih,q.otgr,q.subj,q.obj,q.numdoc,q.numts,q.tip,q.date,SUM(COALESCE(q.allprih, 0) - COALESCE(q.allrash, 0)) all1,SUM(COALESCE(q.allprih2, 0) - COALESCE(q.allrash2, 0)) all2 FROM( --Все расходы SELECT FactoryId fac, WareId ware, null ost, NULL prih, null otgr, d.SubjectId subj, d.ObjectTitleId obj, null numdoc, sd.VehicleNumber numts, d.Kind tip, d.Date date, dld.Quantity allrash, null allprih, null allprih2, null allrash2 FROM DocumentLineDetails dld INNER JOIN DocumentLines dl ON dl.Id = dld.LineId INNER JOIN Documents d ON d.id = dl.DocumentId INNER JOIN SubDocuments sd on sd.id = dld.SubDocumentId INNER JOIN Wares w ON dl.WareId =w.ID WHERE d.Kind = 2 AND sd.CreatedAt<=@date1 AND COALESCE(d.ObjectTitleId, 0) IN ({addr.Count == 0 ? "NULL" : addr.ToQueryString()}) AND w.ParentID IN ({ware.Count == 0 ? "NULL" : ware.ToQueryString()}) AND d.FactoryId IN ({fac.Count == 0 ? "NULL" : fac.ToQueryString()}) AND COALESCE(d.SubjectId, 0) IN ({subj.Count == 0 ? "NULL" : subj.ToQueryString()}) UNION ALL --Все приходы SELECT FactoryId, WareId, null, NULL, null, d.SubjectId, d.ObjectTitleId, null, sd.VehicleNumber, d.Kind, d.Date, null, dld.Quantity, null, null FROM DocumentLineDetails dld INNER JOIN DocumentLines dl ON dl.Id = dld.LineId INNER JOIN Documents d ON d.id = dl.DocumentId INNER JOIN SubDocuments sd on sd.id = dld.SubDocumentId INNER JOIN Wares w ON w.id = dl.WareID WHERE d.Kind = 1 AND sd.CreatedAt<=@date1 AND COALESCE(d.ObjectTitleId, 0) IN ({addr.Count == 0 ? "NULL" : addr.ToQueryString()}) AND w.ParentID IN ({ware.Count == 0 ? "NULL" : ware.ToQueryString()}) AND d.FactoryId IN ({fac.Count == 0 ? "NULL" : fac.ToQueryString()}) AND COALESCE(d.SubjectId, 0) IN ({subj.Count == 0 ? "NULL" : subj.ToQueryString()}) UNION ALL --Все расходы2 SELECT FactoryId, WareId, null, NULL, null, d.SubjectId, d.ObjectTitleId, null, sd.VehicleNumber, d.Kind, d.Date, null, null, null , dld.Quantity FROM DocumentLineDetails dld INNER JOIN DocumentLines dl ON dl.Id = dld.LineId INNER JOIN Documents d ON d.id = dl.DocumentId INNER JOIN SubDocuments sd on sd.id = dld.SubDocumentId INNER JOIN Wares w ON dl.WareId =w.ID WHERE d.Kind = 2 AND sd.CreatedAt<=@date2 AND COALESCE(d.ObjectTitleId, 0) IN ({addr.Count == 0 ? "NULL" : addr.ToQueryString()}) AND w.ParentID IN ({ware.Count == 0 ? "NULL" : ware.ToQueryString()}) AND d.FactoryId IN ({fac.Count == 0 ? "NULL" : fac.ToQueryString()}) AND COALESCE(d.SubjectId, 0) IN ({subj.Count == 0 ? "NULL" : subj.ToQueryString()}) UNION ALL --Все приходы2 SELECT FactoryId, WareId, null, NULL, null, d.SubjectId, d.ObjectTitleId, null, sd.VehicleNumber, d.Kind, d.Date, null, null, dld.Quantity, null FROM DocumentLineDetails dld INNER JOIN DocumentLines dl ON dl.Id = dld.LineId INNER JOIN Documents d ON d.id = dl.DocumentId INNER JOIN SubDocuments sd on sd.id = dld.SubDocumentId INNER JOIN Wares w ON w.id = dl.WareID WHERE d.Kind = 1 AND sd.CreatedAt<=@date2 AND COALESCE(d.ObjectTitleId, 0) IN ({addr.Count == 0 ? "NULL" : addr.ToQueryString()}) AND w.ParentID IN ({ware.Count == 0 ? "NULL" : ware.ToQueryString()}) AND d.FactoryId IN ({fac.Count == 0 ? "NULL" : fac.ToQueryString()}) AND COALESCE(d.SubjectId, 0) IN ({subj.Count == 0 ? "NULL" : subj.ToQueryString()}) ) q GROUP BY q.fac ,q.ware ,q.otgr ,q.prih ,q.ost ,q.subj ,q.obj ,q.numdoc ,q.numts ,q.tip ,q.date ) q INNER JOIN Wares w ON w.id = q.ware INNER JOIN Factories f ON f.id = q.fac LEFT JOIN Subjects s ON s.id = q.subj LEFT JOIN ObjectTitles ot ON ot.id = q.obj LEFT JOIN Units u ON u.id = w.UnitID dsWare id,System.Int32 FullName,System.String 30 c41699373d4a46cd81e213a2ae66662a dsWare MS SQL SELECT wp.id, wp.FullName FROM MaterialStocks ms INNER JOIN Wares w ON w.id = ms.WareId INNER JOIN Wares wp ON wp.id = w.ParentID GROUP BY wp.id, wp.FullName dsZavod id,System.Int32 name,System.String 30 12a8961817654fc2ad8b06ab86905a17 dsZavod MS SQL SELECT id , name FROM Factories WHERE AreaId = 4 dsObj ORIGINAL,ID,ID,ID,System.Int32,_x0030_2040fbf6b3e4990a99ee3534beeb8be ORIGINAL,Name,Name,Name,System.String,a7ad11e40df34321a60e44b90d142a7e 30 f2a5c5285ca941b0a4b2eaed5014c1b5 dsObj MS SQL SELECT 0 ID, 'Отсутствует' Name UNION ALL SELECT ot.id, ot.Name FROM Documents d INNER JOIN ObjectTitles ot ON ot.id = d.ObjectTitleId group by ot.id, ot.name dsSubj ID,System.Int32 FullName,System.String 30 7feed5f011314055b335ead2af991736 dsSubj MS SQL SELECT 0 ID, 'Отсутствует' FullName UNION ALL SELECT s.id, s.FullName FROM Documents d INNER JOIN Subjects s ON s.id = d.SubjectId group by s.id, s.FullName CatalogString Result,System.String 30 a598dd8c88124699a1bbce8a43b8dc7c CatalogString MS SQL DECLARE @result NVARCHAR(max) ='' SELECT @result = @result + Name + ', ' FROM( SELECT 0 ID, 'без группы' Name UNION SELECT wp.id, wp.FullName FROM MaterialStocks ms INNER JOIN Wares w ON w.id = ms.WareId INNER JOIN Wares wp ON wp.id = w.ParentID)q WHERE Id IN ({ware.Count == 0 ? "NULL" : ware.ToQueryString()}) SELECT @result Result BazaString Result,System.String 30 5fe827928d29429a8ddee6c48266b309 BazaString MS SQL DECLARE @result NVARCHAR(max) ='' SELECT @result = @result + Name + ', ' FROM Factories WHERE ID IN ({fac.Count == 0 ? "NULL" : fac.ToQueryString()}) SELECT TOP 1 @result Result ObjectString Result,System.String 30 f1097ee746284276b55ab360dd3433e8 ObjectString MS SQL DECLARE @result NVARCHAR(max) ='' SELECT @result = @result + Name + ', ' FROM (SELECT 0 ID, 'Отсутствует' Name UNION ALL SELECT ot.id, ot.Name FROM Documents d INNER JOIN ObjectTitles ot ON ot.id = d.ObjectTitleId group by ot.id, ot.name) q WHERE ID IN ({addr.Count == 0 ? "NULL" : addr.ToQueryString()}) SELECT TOP 1 @result Result ,CurrentUserID,CurrentUserID,,System.String,_x0033_4e5457e-7d41-4109-848f-9dafbd871355,False,False,False,False ,date1,Дата_x0020_с,,System.DateTime,Today.AddDays_x0028_-1_x0029_.AddHours_x0028_8_x0029_,False,True,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_DateTimeType_x003E_DateAndTime_x003C__x002F_DateTimeType_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_ ,ware,Каталог,,Stimulsoft.Report.IntList,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_dsWare.id_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_dsWare.FullName_x003C__x002F_ValuesColumn_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_ ,addr,Объект,,Stimulsoft.Report.IntList,_x0031_,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_dsObj.ID_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_dsObj.Name_x003C__x002F_ValuesColumn_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_,_x0033_62ebd17967842ef88f4dda8f7da9b95,True ,printLable,Печать_x0020_параметров,,System.Boolean,true,False,False,True,False,,,True ,date2,Дата_x0020_по,,System.DateTime,Today.AddHours_x0028_8_x0029_,False,True,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_DateTimeType_x003E_DateAndTime_x003C__x002F_DateTimeType_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_ ,fac,База,,Stimulsoft.Report.IntList,_x0031_23,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_dsZavod.id_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_dsZavod.name_x003C__x002F_ValuesColumn_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_,,True ,subj,Контрагент,,Stimulsoft.Report.IntList,_x0031_,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_dsSubj.ID_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_dsSubj.FullName_x003C__x002F_ValuesColumn_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_,,True EngineV2 2440d0eafc154372b77ed2cd98fb0347 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,27.7,2.4 Transparent True 0,0,27.6,2.4 Arial,12,Italic 0,0,0,0 Text4 Дата с: {date1} Дата по: {date2} Каталог: {CatalogString.Result} База: {BazaString.Result} Объект: {ObjectString.Result} [0:0:0] ,,,,WordWrap=True,A=0 Expression _x007B_printLable_x0020__x003D__x003D__x0020_false_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None ReportTitleBand1 Transparent 0,3.6,27.7,1.6 All;Black;1;Solid;False;4;Black Transparent 3.2,0,3,1.6 Arial,12,Bold Center 0,0,0,0 Text20 Номер ТС Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black Transparent 6.2,0,2.6,1.6 Arial,12,Bold 4597b61a22934feeaa2f0bd95789b7a3 Center 0,0,0,0 Text21 Номенклатура Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black Transparent 8.8,0,2.6,1.6 Arial,12,Bold df7b7392670049369cb09164af0ac051 Center 0,0,0,0 Text22 Контрагент/Поставщик Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black Transparent 0,0,3.2,1.6 Arial,10,Bold 48535a7ab49841f6bc8752531b6d6036 Center 0,0,0,0 Text23 Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black Transparent 11.4,0,2.2,1.6 Arial,12,Bold 6f4f4d9d37904c5db563d518b6f342bc Center 0,0,0,0 Text24 Объект Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black Transparent 13.6,0,2.4,1.6 Arial,12,Bold aa88047a3dd74f23ac43f73d25cb1a04 Center 0,0,0,0 Text25 ЕИ Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black Transparent 16,0,2.4,1.6 Arial,12,Bold e52f869b9670427bb6f972e5588d53bc Center 0,0,0,0 Text26 Остаток на начало Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black Transparent 18.4,0,2.8,1.6 Arial,12,Bold 22b67c9a29cf42f98a75677cbc713c0e Center 0,0,0,0 Text27 Приход Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black Transparent 21.2,0,3.8,1.6 Arial,12,Bold 9c3eafeaafc2441fa4bc539e5454e319 Center 0,0,0,0 Text28 Расход Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black Transparent 25,0,2.6,1.6 Arial,12,Bold e157a7883d32427fa0fba93193c27bbf Center 0,0,0,0 Text29 Остаток на конец Black ,,,,WordWrap=True,A=0 Expression Center HeaderdsMain True Transparent True 0,6,27.7,0.8 All;Black;1;Solid;False;4;Black Transparent True 0,0,27.6,0.8 Arial,12,Bold| Italic True 0,0,0,0 Text17 {dsMain.zavod} Black ,,,,WordWrap=True,A=0 {dsMain.zavod} GroupHeaderBand2 Transparent True 0,7.6,27.7,1.4 All;Black;1;Solid;False;4;Black [127:127:127] True True 6.2,0,2.6,1.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>_x007B__x0028_Sum_x0028_dsMain.prihod_x0029__x0029__x003D__x003D_0_x007D_</value><value>_x007B__x0028_Sum_x0028_dsMain.rashod_x0029__x0029__x003D__x003D_0_x007D_</value></Filters><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,12 True 7412d1c684c74b498ec99d641218bbf0 0,0,0,0 Text11 {dsMain.nomenkl} Black ,,,,WordWrap=True,A=0 All;Black;1;Solid;False;4;Black [127:127:127] True True 13.6,0,2.4,1.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>_x007B__x0028_Sum_x0028_dsMain.prihod_x0029__x0029__x003D__x003D_0_x007D_</value><value>_x007B__x0028_Sum_x0028_dsMain.rashod_x0029__x0029__x003D__x003D_0_x007D_</value></Filters><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,12 True 58e68ca462cd4fe38f06e4f4cb3e9653 0,0,0,0 Text12 {dsMain.Name} Black ,,,,WordWrap=True,A=0 All;Black;1;Solid;False;4;Black [127:127:127] True True 16,0,2.4,1.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>_x007B__x0028_Sum_x0028_dsMain.prihod_x0029__x0029__x003D__x003D_0_x007D_</value><value>_x007B__x0028_Sum_x0028_dsMain.rashod_x0029__x0029__x003D__x003D_0_x007D_</value></Filters><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,12 True 79e2cb82145c412c9a0b3fe8e74977ed 0,0,0,0 Text13 {Sum(DatadsMain,dsMain.all1)} Black ,,,,WordWrap=True,A=0 Totals All;Black;1;Solid;False;4;Black [127:127:127] True True 18.4,0,2.8,1.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>_x007B__x0028_Sum_x0028_dsMain.prihod_x0029__x0029__x003D__x003D_0_x007D_</value><value>_x007B__x0028_Sum_x0028_dsMain.rashod_x0029__x0029__x003D__x003D_0_x007D_</value></Filters><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,12 True 5f54e5081d0e47f4978a17faa4eca275 0,0,0,0 Text14 {Sum(DatadsMain,dsMain.prihod)} Black ,,,,WordWrap=True,A=0 Totals All;Black;1;Solid;False;4;Black [127:127:127] True True 21.2,0,3.8,1.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>_x007B__x0028_Sum_x0028_dsMain.prihod_x0029__x0029__x003D__x003D_0_x007D_</value><value>_x007B__x0028_Sum_x0028_dsMain.rashod_x0029__x0029__x003D__x003D_0_x007D_</value></Filters><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,12 True 026a2c135b8840f89546cf5edb99030e 0,0,0,0 Text15 {Sum(DatadsMain,dsMain.rashod)} Black ,,,,WordWrap=True,A=0 Totals All;Black;1;Solid;False;4;Black [127:127:127] True True 25,0,2.6,1.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>_x007B__x0028_Sum_x0028_dsMain.prihod_x0029__x0029__x003D__x003D_0_x007D_</value><value>_x007B__x0028_Sum_x0028_dsMain.rashod_x0029__x0029__x003D__x003D_0_x007D_</value></Filters><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,12 True 61fd91dc09134da9b5460ab327cc57b9 0,0,0,0 Text16 {Sum(DatadsMain,dsMain.all2)} Black ,,,,WordWrap=True,A=0 Totals All;Black;1;Solid;False;4;Black [127:127:127] True True 0,0,6.2,1.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>_x007B__x0028_Sum_x0028_dsMain.prihod_x0029__x0029__x003D__x003D_0_x007D_</value><value>_x007B__x0028_Sum_x0028_dsMain.rashod_x0029__x0029__x003D__x003D_0_x007D_</value></Filters><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,12 True 2972175d21ff4037ac4c2b4009ffb048 0,0,0,0 Text18 Black ,,,,WordWrap=True,A=0 DataColumn All;Black;1;Solid;False;4;Black [127:127:127] True True 8.8,0,4.8,1.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>_x007B__x0028_Sum_x0028_dsMain.prihod_x0029__x0029__x003D__x003D_0_x007D_</value><value>_x007B__x0028_Sum_x0028_dsMain.rashod_x0029__x0029__x003D__x003D_0_x007D_</value></Filters><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,12 True 219217dec6804ea29688fc9c841f4914 0,0,0,0 Text19 Black ,,,,WordWrap=True,A=0 DataColumn {dsMain.nomenkl} GroupHeaderBand1 Transparent True 0,9.8,27.7,1 All;Black;1;Solid;False;4;Black Transparent True True 0,0,3.2,1 dsMain.numdoc,IsNull,,,String,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,12 True f76de6eac4994080ba9257ee4e204df5 0,0,0,0 Text30 {dsMain.date} Black ,,,,WordWrap=True,A=0 All;Black;1;Solid;False;4;Black Transparent True True 3.2,0,3,1 dsMain.numdoc,IsNull,,,String,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,12 True e7148faa7b2a4090a2cfbde3909a42f0 0,0,0,0 Text31 {dsMain.ts} Black ,,,,WordWrap=True,A=0 All;Black;1;Solid;False;4;Black Transparent True True 6.2,0,2.6,1 dsMain.numdoc,IsNull,,,String,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,12 True 4c06c1b9368d4bc5bd6d3abd02ac78fe 0,0,0,0 Text32 {IIF (dsMain.tip == 1, "Прием №", "Отгрузка №") + dsMain.numdoc} Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black Transparent True True 8.8,0,2.6,1 dsMain.numdoc,IsNull,,,String,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,12 True 4e84288aeaeb4545bfab7ac6ef6fb80f 0,0,0,0 Text33 {dsMain.org} Black ,,,,WordWrap=True,A=0 All;Black;1;Solid;False;4;Black Transparent True True 11.4,0,2.2,1 dsMain.numdoc,IsNull,,,String,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,12 True 2ce9bb79925348f7bfad77235b452eef 0,0,0,0 Text34 {dsMain.objec} Black ,,,,WordWrap=True,A=0 All;Black;1;Solid;False;4;Black Transparent True True 18.4,0,2.8,1 dsMain.numdoc,IsNull,,,String,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,12 True 2ce89268b69646b0b2f381817de67a4d 0,0,0,0 Text35 {dsMain.prihod} Black ,,,,WordWrap=True,A=0 DataColumn All;Black;1;Solid;False;4;Black Transparent True True 21.2,0,3.8,1 dsMain.numdoc,IsNull,,,String,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,12 True 075e029029c545b387c470c200ce2954 0,0,0,0 Text36 {dsMain.rashod} Black ,,,,WordWrap=True,A=0 DataColumn All;Black;1;Solid;False;4;Black Transparent True True 13.6,0,2.4,1 dsMain.numdoc,IsNull,,,String,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,12 True a6d7311d84c04be5b44530249959ded4 0,0,0,0 Text37 Black ,,,,WordWrap=True,A=0 DataColumn All;Black;1;Solid;False;4;Black Transparent True True 16,0,2.4,1 dsMain.numdoc,IsNull,,,String,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,12 True 0,0,0,0 Text1 {dsMain.all1} Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black Transparent True True 25,0,2.6,1 dsMain.numdoc,IsNull,,,String,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,12 True af1f14ce22b246b299825ac4fbfcc979 0,0,0,0 Text2 {dsMain.all2} Black ,,,,WordWrap=True,A=0 DataColumn dsMain False DatadsMain Transparent 0,11.6,27.7,0 GroupFooterBand1 Transparent 0,12.4,27.7,0 GroupFooterBand2 08b9e627e4b041d2b30a82fbc78c2b27 1,1,1,1 Page1 Landscape 21 29.7 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 1/28/2022 11:50:53 AM 12/15/2021 2:16:12 PM C:\Users\Chekulaev\Desktop\v\удалить тест\test 2. Report тест (GranitWareMovementTest).mrt fe305bcf3a574594a3040c3438a9b64a Report Centimeters 2019.4.2.0 True CSharp