March 4, 2011 at 12:12 am
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
March 4, 2011 at 12:32 am
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
March 4, 2011 at 1:54 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply