0

Is it possible to hide a specific cell in SSRS based on row number or group value ?

jarlh
  • 42,561
  • 8
  • 45
  • 63
Osama Al-Hasan
  • 21
  • 5
  • What do you mean by "hide" a cell? If a cell is hidden, and it's part of a column/row the table would end up malformed. It be better to `NULL` the value based on your logic. If you need to hide things, you do so to, rows, column, groups or objects in SSRS; not a single cell. – Thom A Jan 07 '20 at 08:53
  • Here's the issue, let's say i have a table that contains 3 columns, Company, Department and Employees, the columns company and Department are grouped but the Employees column isn't, now i want to hide the employee names that are under the IT department – Osama Al-Hasan Jan 07 '20 at 09:19
  • So you don't want to hide cells, you want to hide rows? – Thom A Jan 07 '20 at 09:20
  • No that's the issue, I want to hide the Employees that are in the IT department, but show the employees that are in the HR department, I apologize if I'm not making it clear enough – Osama Al-Hasan Jan 07 '20 at 09:29
  • 2
    Add a `WHERE` to your SQL? `WHERE DeptName != 'IT'`. – Thom A Jan 07 '20 at 09:34
  • Please check this solution : https://stackoverflow.com/a/20966446/6923146 – Hardik Masalawala Jan 07 '20 at 09:41
  • Like @Larnu said. This would be easier if you just modify the query and not the report. – Diego Jan 08 '20 at 17:02

0 Answers0