Cognos - Merge result from data item with CASE

Sucris · ‎Mar 30, 2022

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.

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.

Any ideas? Please advise.

KRs

Su

KevinD · ‎Mar 30, 2022

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

Thank you,
Kevin
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 · ‎Mar 30, 2022

@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
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.