MS SQL 9BRTz81oe5lqe/3c/lzhJ9FUaYhIa9nNy2HtQOQFpGPXQGXrZ0s6gWFL3YDghGIPxED5K2FZyp1xeM34YaAlKtVa+UjFcUFtaUmh8HJwpD/5GFPCYgV6mWtPoYTlJfYP2Xhx MS SQL Data2 EmpName,System.String Emp_Salary,System.Int32 Department,System.String 30 Data2 MS SQL SELECT 'James Bond' as 'EmpName', 120 as 'Emp_Salary', 'Universal' as 'Department' UNION ALL SELECT 'Killer' as 'EmpName', 130 as 'Emp_Salary', 'Universal' as 'Department' UNION ALL SELECT 'Harry P' as 'EmpName', 120 as 'Emp_Salary', '21 Century' as 'Department' UNION ALL SELECT 'Hermeona G' as 'EmpName', 0 as 'Emp_Salary', '21 Century' as 'Department' UNION ALL SELECT 'Ironman' as 'EmpName', 0 as 'Emp_Salary', 'Marvel' as 'Department' UNION ALL SELECT 'Captain A' as 'EmpName', 0 as 'Emp_Salary', 'Marvel' as 'Department' ,ValuedRows,ValuedRows,ValuedRows,System.Int32,_x0030_,False,False,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,23.5,19,4.2 None;[231:232:234];1;Solid;False;4;[0:0:0:0];True Transparent 0,0.1,19,4 Tahoma,10 Center 0,0,0,0 Text6 PLEASE LOOK HOW WE ARE HIDING GROUP FOOTER BAND - THE SAME LOGIC DOES NOT WORK IN GROUP HEADER. ALSO HOW WE ARE HIDING DATABAND WHERE EMPLOYEE HAS NO SALARY - THE SAME LOGIC DOES NOT WORK IN GROUP HEADER BUT CountDistinct Show properly the numbers of emp in each group. We want if it is equal to 0, hide it. BECAUSE WE have page break on each group Black Expression Center PageFooterBand1 if(Data2.Emp_Salary != 0) { ValuedRows += 1; } [79:129:189] 0,0.4,19,0.8 None;[231:232:234];1;Solid;False;4;[0:0:0:0];True Transparent 0,0,3.6,0.8 Tahoma,7 Center 0,0,0,0 Text1 {Data2.EmpName} Black Expression Center None;[231:232:234];1;Solid;False;4;[0:0:0:0];True Yellow 4,0,3.6,0.8 _x007B_Data2.Emp_Salary_x0020__x003C__x0020_125_x007D_,Red,Transparent,Arial_x002C_8,True,False,,Test,None Tahoma,12 6913490c244943e68994371f76810daa Right 0,0,0,0 Text2 {Data2.Emp_Salary} [79:97:40] Expression Center None;[231:232:234];1;Solid;False;4;[0:0:0:0];True Transparent 9,0,5.4,0.8 Tahoma,7 4a14b440f1af4f2494ab508e6f53929d Center 0,0,0,0 Text7 CAN BE HIDDEN BE COndition only Black Expression Center _x007B_Data2.Emp_Salary_x0020__x003D__x003D__x0020_0_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None Data2 DataBand1 ba26d2a077d74533a1867ea999b2d32a 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] 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 8/22/2019 7:13:16 PM 7/30/2018 10:56:00 AM C:\Users\iskandara\Downloads\HorizontalAlignment.mrt 99b5d3a287ca4c40a7e3419666c43f99 Report Centimeters 2017.1.6.0 CSharp True Transparent Arial Black,11.25,Bold| Italic,Point,False,0 Test Black