Dynamic Column Hiding of a Table in ssrs 2005

• srinadh.ramineni

  Say Hey Kid

  Points: 675

  More actions

  March 4, 2011 at 12:12 am

  #234615

  Hi to all,

  I am facing problems with the following situation:

  TABLSE:

  EMPNo EMPNAME DEPTNO SALARY

  01 AAA D1 15000

  02 BBB D2 20000

  DEPTNO NAME

  D1 ACCOUNTS

  D2 PRODUCTION

  D3 SALES

  -- For Department 1 (Table for D1 related data : D1RelData)

  DEPTNO Value1 Value2 Value3 Value4 Value5

  D1 001 002 003 0004 005

  -- For Department 2 (Table for D2 related data : D2RelData)

  DEPTNO 2_Value

  D2 001

  -- For Department 3 (Table for D3 related data : D3RelData)

  DEPTNO 3_Value

  D3 003

  -- For Department 4 (Table for D4 related data : D4RelData)

  DEPTNO 4_Value

  D4 004

  Now if you see the above tables, I have Employee, Dept and Dept Related Table. Now in the report what i want to show like this:

  REPORT:

  Group By Department and also selected options are :

  Page Break at start, Page Break at end, Include Group Header and Footer. Pages should be breaked for each group.

  D1

  EmpNo EmpName Salary VALUE1 VALUE2 VALUE3 VALUE3 Value5

  01 AAA 15000 001 002 003 004 005

  D2

  EmpNo EmpName Salary 2_Value

  02 BBB 20000 001

  Dynamic Columns are (VALUE1 VALUE2 VALUE3 VALUE3 Value5 for D1 and 2_Value

  for D2)

  For this i listed all the columns in the report. Based on the condition i am doing the Visibility of the columns. But this visibility is not working. Please suggest me any alternative for this. Iam using SQL SERVER 2005 DB and SSRS 2005.

  Thanks and Regards,

  Srinadh

• srikant maurya

  Hall of Fame

  Points: 3293

  More actions

  March 4, 2011 at 12:32 am

  #1294470

  Return One column in result set and use that column to hide the column from report.

  Use Expression on Column proeprty(SSRS) if value is 1 the hide and 0 then visible.

  Regards,

  Srikant

• srinadh.ramineni

  Say Hey Kid

  Points: 675

  More actions

  March 4, 2011 at 1:54 am

  #1294504

  Hi Srikant,

  For the Department "D1", there are 5 dynamic columns. If you see the below O/P you can have an idea on this: For the remaining there will be only one dynamic column. If the Dynamic column is one, then that is not a issue. or the first grouping it is giving 5 dynamic columns.

  D1

  EmpNo EmpName Salary VALUE1 VALUE2 VALUE3 VALUE3 Value5

  01 AAA 15000 001 002 003 004 005

  For "D2" there will be only one. What we need to do is simly we need to hide the top 5 dynamic columns and display the latest dynamic column.

  Thanks and Regards,

  Srinadh.