March 4, 2011 at 12:05 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 10, 2011 at 8:01 pm
May I suggest you ask about this in the more appropriate Business Intelligence forum and that you note here that you've done so. That way you'll get the attention of people more interested and expert with SSRS.
Again, if you post there, please make note of that in this thread so you don't end up with two conversations on the same topic.
==============
Awwwwwkkkk!!! sorry. This was meant for another thread that WAS in the wrong forum. Please forgive my inattention.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply