Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunny9
Starting Member
4 Posts |
 Posted - 2008-04-17 : 09:31:24
|
| I am new to Reporting services pls let me know ..How to display the heirarchies(manager ,team lead....) on the top of the report and place a matrix below to display no of days likeTeam lead:-------- 4/10 4/11 4/12.....Totalteam 11 8 6 -- team1 10 1 1 --Total -- -- -- --team lead:----- 4/10 4/11 4/12.....Totalteam 11 8 6 -- team1 10 1 1 --Total -- -- -- --and so on ..and Grand total below this matrix Pls let me know how to do it Thanks in Advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-17 : 13:39:13
|
| Not sure. But you can try putting a matrix inside a table which links to your dataset providing the hierarchy details and write expression to retrieve manager,team lead,... value and them fileter the accompanying matrix to bring data for particular employee. |
 |
|
|
sunny9
Starting Member
4 Posts |
Posted - 2008-04-17 : 14:43:52
|
| Thanku,Can u pls elobarate ..I need the report like this manager:---Teamlead:--------------------------Employee:---------then matrix here |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-18 : 03:16:36
|
| What all information do your dataset contain? |
|
|
|
bbasir
Yak Posting Veteran
76 Posts |
Posted - 2008-04-21 : 19:14:00
|
| What you can do is this.... have a hidden field on the report itself i.e. some text box or label, and then in the header of the report itself you can access that afield as a report item. |
|
|
|
|
|
|
Matrix Report