Technical Problem

[lee]

HI,

I want to display below fields in the report

1) Dept No
2) DeptName
3) Employee name
4) Other employees -- this field displays the other than selected employees available in the department as a comma seperater

In the report prompts are Department Name and Employee Name. Department Name is the text prompt and employee name is the value prompt.

For eg:- If dept 10 has 4 emps(emp1,emp2,emp3,emp4) and the report is generated for dep10 and emp1,emp2. in this case we have to print the selected employee details like Dept No ,DeptName,Employee name and in the Other employees column we have to display the other than seleted employee name (emp3,emp4) as comma seperator.

we are not able to print the other emp info.
Please let me know technically how to acheive this in cognos 8.

Thanks in Advance,
Lee.

[the_xxx]

One way you can do is, in the other employees column insert one ore list or repeater and create a master detail with main list based on Dept.

Create a new query with a logic to capture reaming employees and point the new list/repeater to this new query.

this involves little formatting.

Good luck :)