MS SQL 9PL3Ce8Fo/VrHdls+kkl+8Rg+UjdS3vty2e9bGDcJWfKcIEMT3FC3eFE/b1xPaxu4FqVSMYFQoHLE4SETSit+9lWvwlLdaO8eXulCGRwKOfDVmWj5mhShfNEocxOBCITkHDNKMJ9QqRrFf3M5AGgT+Nw20jXTZPFa3z97MNJ9offGM0ISgNa8fdOvYRh+LHb2WqJjMYVY+3hSUWlYtjhN9UU2cPFaw== 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' UNION ALL SELECT 'Lazy Developer' as 'EmpName', 0 as 'Emp_Salary', 'Marvel' as 'Department' UNION ALL SELECT 'Big Jam' as 'EmpName', 0 as 'Emp_Salary', 'BIG CINEMA' as 'Department' UNION ALL SELECT 'Big Bank' as 'EmpName', 101 as 'Emp_Salary', 'BIG CINEMA' as 'Department' UNION ALL SELECT 'Big and Bold' as 'EmpName', 0 as 'Emp_Salary', 'BIG CINEMA' 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 ValuedRows = 0; [192:80:77] 0,0.4,19,0.8 None;[231:232:234];1;Solid;False;4;[0:0:0:0];True Transparent 1,0,3.6,0.8 Tahoma,7 cb4bd6c283e94205a939c552a6ede595 Center 0,0,0,0 Text5 Dep: {Data2.Department} Black Expression Center None;[231:232:234];1;Solid;False;4;[0:0:0:0];True Transparent 7,0,3.6,0.8 Tahoma,7 9f5b99e086f84dd7beab04a086c2c1b8 Center 0,0,0,0 Text3 {CountDistinct(Data2.EmpName)} Black Expression Center None;[231:232:234];1;Solid;False;4;[0:0:0:0];True Transparent 11.6,0,3.6,0.8 Tahoma,7 ae92fac4622b4c3eaf20339e08f53fbf Center 0,0,0,0 Text8 How to hide it? Black Expression Center {Data2.Department} _x007B_ValuedRows_x0020__x003D__x003D__x0020_0_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None GroupHeaderBand1 True None if(Data2.Emp_Salary != 0) { ValuedRows += 1; } [79:129:189] 0,2,19,0.8 None;[231:232:234];1;Solid;False;4;[0:0:0:0];True Transparent 3.6,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 Transparent 8,0,3.6,0.8 Tahoma,7 6913490c244943e68994371f76810daa Center 0,0,0,0 Text2 {Data2.Emp_Salary} Black Expression Center None;[231:232:234];1;Solid;False;4;[0:0:0:0];True Transparent 12.6,0,5.4,0.8 Tahoma,7 4a14b440f1af4f2494ab508e6f53929d Center 0,0,0,0 Text7 CAN BE HIDDEN BE COndition only Black Expression Center None;[231:232:234];1;Solid;False;4;[0:0:0:0];True Transparent 0,0,3.6,0.8 Tahoma,7 057cd88e72f741f1825c5b9cd12aaca9 Center 0,0,0,0 Text9 Dep: {Data2.Department} Black Expression Center _x007B_Data2.Emp_Salary_x0020__x003D__x003D__x0020_0_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None Data2 DataBand1 [192:80:77] 0,3.6,19,1 None;[231:232:234];1;Solid;False;4;[0:0:0:0];True Transparent 0,0,18.8,0.8 Tahoma,10 580d39e6a48140a1a6df81da3664e7fb Center 0,0,0,0 Text4 1)Universal has paid salaries but no group header! 3) Marvel has no paid salaries but has header to Big Cinema dep White Expression Center _x007B_ValuedRows_x0020__x003D__x003D__x0020_0_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None GroupFooterBand1 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/1/2018 4:29:22 PM 7/30/2018 10:56:00 AM D:\Chrome Downloads\HideEmptyHeaders.mrt 1c04546e723c43e4a192f01641768521 Report Centimeters 2017.1.6.0 CSharp