How to show the data reported horizontally: (For example:) employee skill 1 a 1 b 1 c 2 d 2 e 2 f
Report result: 1 abc 2 def
Assuming 3 records per grouped item:
1. Group on employee 2. Create a running count based on the skill field. 3. Create 3 calculated columns based on the count field. Call them skill1, skill2, skill3:
if (count = 1) then (skill) else null if (count = 2) then (skill) else null if (count = 3) then (skill) else null
4. Create 3 more calculated columns using the maximum function. Call them maxskill1, maxskill2, maxskill3
maximum (skill1) maximum (skill2) maximum (skill3)
5. Group on employee on maxskill1 on maxskill2 on maxskill3 6. report employee axskill1 maxskill2 maxskill3
RE: How to show the data reported horizontally:(...
Concatenating is the best solution. Create a calculated field. Get the values related to Skill type 1 and concatenate them with required spaces inbetween.
RE: How to show the data reported horizontally:(For example:)employee skill1 a1 b1 c2 d2 e2 fReport result:1 abc2 def
I feel we can use the tool functionality to achieve this as follows.
1. Create a list report having employee column 2. Create a cross tab - contains emp in row and skill in column 3. Provide Master Detail relationship between 'emp' of list & CT 4. Hide emp of CT and format appropriately
