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 |
|
mgarret
Starting Member
14 Posts |
 Posted - 2013-07-06 : 21:13:00
|
| Hi all-I have a dataset which shows a worker’s scores on various skills using four test types along with their supervisor and the director above the supervisor. To save space, the dataset example below is for just one worker. This is what I start with.Director Supervisor Worker Test Skill ScoreDoris Smith Jane Awe Lorina Marc Overall 1: Identifying Support 1Doris Smith Jane Awe Lorina Marc Test A 1: Identifying Support 4Doris Smith Jane Awe Lorina Marc Test B 1: Identifying Support 1Doris Smith Jane Awe Lorina Marc Test C 1: Identifying Support 5Doris Smith Jane Awe Lorina Marc Overall 2: Tracking the Sequence 3Doris Smith Jane Awe Lorina Marc Test A 2: Tracking the Sequence 2Doris Smith Jane Awe Lorina Marc Test B 2: Tracking the Sequence 5Doris Smith Jane Awe Lorina Marc Test C 2: Tracking the Sequence 5Doris Smith Jane Awe Lorina Marc Overall 3: Searching for Exceptions 3Doris Smith Jane Awe Lorina Marc Test A 3: Searching for Exceptions 3Doris Smith Jane Awe Lorina Marc Test B 3: Searching for Exceptions 3Doris Smith Jane Awe Lorina Marc Test C 3: Searching for Exceptions 3I feed this into MS SQL server reporting services using either table wizard or matrix wizard. I have to move Skill column over the Score column so the skills are now columns. Row Groups: Director, Supervisor, Worker Test Column Group: Skill Value: Score I get this:Director Suprviser Worker Test 1: Identifying 2: Tracking 3: Searching Support the Sequence for ExceptionsDoris Smith Jane Awe Lorina Marc Overal 1 3 3 Test A 4 2 3 Test B 1 5 3 Test C 5 5 3 Al Vega Overal 5 5 3 Test A 3 3 2 Test B 2 4 4 Test C 5 2 5 David Osorio Overal 1 1 3 Test A 2 4 2 Test B 4 5 1 Test C 2 3 2 Katie Lewis Ally McIntosh Overal 1 2 3 Test A 5 3 4 Test B 3 3 2 Test C 1 3 2 Christina Gooderd Overal 2 2 1 Test A 4 4 1 Test B 5 5 4 Test C 2 5 4I need to have a value in each cell, so the values need to repeat for each group. So, what I want the report to look like:Director Suprviser Worker Test 1: Identifying Support 2: Tracking the Sequence 3: Searching for ExceptionsDoris Smith Jane Awe Lorina Marc Overal 1 3 3Doris Smith Jane Awe Lorina Marc Test A 4 2 3Doris Smith Jane Awe Lorina Marc Test B 1 5 3Doris Smith Jane Awe Lorina Marc Test C 5 5 3Doris Smith Jane Awe Al Vega Overal 5 5 3Doris Smith Jane Awe Al Vega Test A 3 3 2Doris Smith Jane Awe Al Vega Test B 2 4 4Doris Smith Jane Awe Al Vega Test C 5 2 5Doris Smith Jane Awe David Osorio Overal 1 1 3Doris Smith Jane Awe David Osorio Test A 2 4 2Doris Smith Jane Awe David Osorio Test B 4 5 1Doris Smith Jane Awe David Osorio Test C 2 3 2Doris Smith Katie Lewis Ally McIntosh Overal 1 2 3Doris Smith Katie Lewis Ally McIntosh Test A 5 3 4Doris Smith Katie Lewis Ally McIntosh Test B 3 3 2Doris Smith Katie Lewis Ally McIntosh Test C 1 3 2Doris Smith Katie Lewis Christina Gooderd Overal 2 2 1Doris Smith Katie Lewis Christina Gooderd Test A 4 4 1Doris Smith Katie Lewis Christina Gooderd Test B 5 5 4Doris Smith Katie Lewis Christina Gooderd Test C 2 5 4What do I fix/change/modify so I can have a value in each cell filled in? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-07 : 10:47:12
|
| Have you set Hide Duplicates property for fields Director,Worker etc? if yes you need to remove them.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Cell value not repeating using table/matrix Wizar