cancel
Showing results for 
Search instead for 
Did you mean: 
Sucris
Occasional Member - Level 1

Cognos - Merge result from data item with CASE

Hi !!

I'm trying to do a report where the roles (only the ones visible in the profile) appear in one single line as in the 300 file.

I've added data items for each "role" with CASE.

Sucris_1-1648647056083.png

Although would like to have 1 single line per user.

Tried with CASE and ELSE IF to fill in the data items, with filters, with merging the lines in the page but is not the desired result.

 

Sucris_0-1648646982590.png

 

Any ideas? Please advise.

 

KRs

Su

 

 

2 REPLIES 2
KevinD
Community Manager
Community Manager

@Sucris I'm asking my reporting experts if this is possible. I'll let you know what I find out.


Thank you,
Kevin Dorsey
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.
KevinD
Community Manager
Community Manager

@Sucris can you tell me which company this report is for? I see the company you work for is a Partner. I think you are working for a company that you are implementing, so I need that company name so we can go look at the report you built. 


Thank you,
Kevin Dorsey
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.