Hello Cognos Experts,
I am trying to combine two rows into one. See the image below:
(https://i.imgur.com/bVjBEGL.jpg)
I am creating a project list output that should look similar to printing a project list from MS Project where the task assignees appear in ONE row, not two.
Does anyone know if this is possible?
Thank you!
C
edit to add image
To have any chance of answering the question I'd really need to know what's causing the data to appears on two lines in the first place. There doesn't appear to be anything in the data that you've shared so far that would suggest a reason...
My assumption would be that the second-to-rightmost column that has been blanked out by OP contains employee names (hence the blanking out :)) and that those differ.
So, in order to possibly devise a solution (an ugly one, I fear), we'd need to know:
- are there always multiple assignees to a task? I think the first row already answers that, but just making sure;
- if there are multiple assignees to a task, is there an upper limit? Is it a max of two, as one could imply from your description, or are more possible?
As BigChris and hespora have already stated, a little more information about what the expectation/requirement is for this obscured data is likely key to getting the best answer. It would also help to understand if any of the other columns could vary and cause duplication.
A few techniques:
- Get rid of the column that causes the duplication of rows so the data will automatically summarize to a single row per all elements shown - probably not viable if that information is required in the output
- Set an aggregate property on that column to show the minimum or maximum value - probably too arbitrary and may also be contrary to the requirement
- Drag a repeater object into your list to show the names as a horizontal list within a single row (requires a master-detail relationship) - be aware of performance implications with this approach but with small volumes it may not be an issue
Select No Wrap in the properties for the column causing problem?
Use a repeater table. You'll want columns named Assignee and Comma. Comma is the result of a calculation. It returns a comma (,) if this is not the last row within the group. It contains an empty string () if it is the last row within the group. See the attached report spec.