MS SQL 9Gzh6+8JS4XhTaWYZyXgTtFazy9OXdOZaFslzMMloCfUasGDT117We1dcQhhPeEP33DLD1tMq5l6eIS9ZAF3bsRsTytGWZttQgbthc8NJS/VVtXDzF1pyHJaTdxNeGVnwsjPiVZd2ZnCTehYw0wof9E6wStLSgGFYlG1mE1x62fCfPkJT18x 0ffe103682dd457f83b94a5cf2557a74 MS SQL Settings key,System.String value,System.String 30 47815891e19a491a85effe237106d487 Settings MS SQL SELECT * FROM [DargahData].[dbo].[Settings] WHERE [Key] = 'Title' TedadeMoamelat ContractorID,System.String estelam,System.Int32 Manabe,System.String monaghese,System.Int32 mozayede,System.Int32 30 bc41d7b2711d49888f3cdffaf98a8513 TedadeMoamelat MS SQL _x0040_DE,Dates.To,31,0 _x0040_DB,Dates.From,31,0 --exec sp_executesql @Filters SELECT SUM(IIF([TestDargahData].[dbo].[vTender].[TendTypeID]= 'public' OR [TestDargahData].[dbo].[vTender].[TendTypeID]= 'limited',1, 0)) AS monaghese, SUM(IIF([TestDargahData].[dbo].[vTender].[TendTypeID]= 'inquiry',1, 0)) As estelam, SUM(IIF([TestDargahData].[dbo].[vTender].[TendTypeID]= 'aucPublic' OR [TestDargahData].[dbo].[vTender].[TendTypeID]= 'auction',1, 0)) As mozayede, [TestDargahData].[dbo].[vTenderContractor].[ContractorID], MAX([TestDargahData].[dbo].[vTenderContractor].[ContractorName]) AS Manabe FROM [TestDargahData].[dbo].[vTender] INNER JOIN [TestDargahData].[dbo].[vTenderContractor] ON [TestDargahData].[dbo].[vTender].[ID] = [TestDargahData].[dbo].[vTenderContractor].[TenderID] INNER JOIN [TestDargahData].[dbo].[Contractor] ON [TestDargahData].[dbo].[vTenderContractor].[ContractorID] = [TestDargahData].[dbo].[Contractor].[ID] WHERE [TestDargahData].[dbo].[vTenderContractor].[InsertDate] Between @DB And @DE GROUP BY [TestDargahData].[dbo].[vTenderContractor].[ContractorID]; EngineV2 7f76a46c08544bf5ae999f4288521001 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,7.47,0.8 Transparent 0,0.1,0.8,0.3 B Nazanin,9,Bold ced5cfc4053149c3936969a4246943fa 0,0,0,0 Text45 {DateToHijri(Today)} [38:38:38] ,,RightToLeft=True,,,A=0 Expression Center Transparent 0,0.4,0.8,0.3 B Nazanin,9,Bold 2c7789e7f39646a8b32e3b5a07ba7ff7 0,0,0,0 Text50 {PageNumber} از {TotalPageCount} [38:38:38] ,,RightToLeft=True,,,A=0 Expression Center Transparent 1.6,0.1,4.7,0.3 B Nazanin,12,Bold 49e0e6efe6fd4f9cbeb053cc56e62e06 Center 0,0,0,0 Text51 {Settings.value} [38:38:38] Expression Center 32882584ca91403da0a73bcf40c5a6ec PageHeaderBand1 All;Black;1;Solid;False;4;Black [219:229:241] 10.4,1.4,0.5,0.3 B Nazanin,13,Bold 73ced793255e45829f13ba151123e9c8 Center 0,0,0,0 Text16 ردیف Black Expression Center All;Black;1;Solid;False;4;Black Transparent False 0,1.4,7.47,0.3 All;Black;1;Solid;False;4;Black [219:229:241] 3.38,0,4.1,0.3 Arial,13,Bold 5fdddfa71c05454d9a27d6024a158e9b Center 0,1,0,0 Text2 source Black Expression Center All;Black;1;Solid;False;4;Black [219:229:241] 2.2,0,1.2,0.3 Arial,13,Bold 26af31a8f3f048f59ec0caf8a683c1a0 Center 0,0,0,0 Text12 count 1 Black ,,RightToLeft=True,,,A=0 Expression Center All;Black;1;Solid;False;4;Black [219:229:241] 1.1,0,1.1,0.3 Arial,13,Bold a84c30b0954049708892dacccbf5f419 Center 0,0,0,0 Text1 count 2 Black ,,RightToLeft=True,,,A=0 Expression Center All;Black;1;Solid;False;4;Black [219:229:241] 0,0,1.1,0.3 Arial,13,Bold f8d532d9dfb24e02a8d8b4f58b9d98b6 Center 0,0,0,0 Text3 count 3 Black ,,RightToLeft=True,,,A=0 Expression Center bd97d52167f74ac6bfe4b35d369a7704 ColumnHeaderBand3 Transparent True False True 0,2.1,7.47,0.3 Top, Right, Bottom;Black;1;Solid;False;4;Black Transparent 3.38,0,4.1,0.3 B Nazanin,11 48c384c9f604420b928e3c2178edfc5f Right 0,1,0,0 Text22 {TedadeMoamelat.Manabe} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 2.2,0,1.2,0.3 B Nazanin,11 701a81661efa44f6bb1efc0612bbbf02 Center 0,0,0,0 Text21 {TedadeMoamelat.monaghese} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 1.1,0,1.1,0.3 B Nazanin,11 5d0b49dd9f8d4ddc8bb62aeed6dbd5e5 Center 0,0,0,0 Text5 {TedadeMoamelat.estelam} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 0,0,1.1,0.3 B Nazanin,11 a3aac854345a4e95a57785d1cf45e647 Center 0,0,0,0 Text4 {TedadeMoamelat.mozayede} Black Expression Center TedadeMoamelat d53b3d0ad40342cc9d9d932f96522b20 DataBand3 7cc2944e9fec4d228f915817e4178055 0.4,0.4,0.4,0.4 Page1 11.69 8.27 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 Report 12/13/2021 4:22:43 PM 12/8/2021 12:21:43 PM C:\Users\shahmohamadi.s\Documents\گزارشات آقای نیلی و دارکوش\مس\MonagheseBa filterZaman3.mrt 0ec80b35931a4c248b970d3eef65e3c3 Report Inches 2021.4.2.0 CSharp