COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Shailaja0520 on 15 Mar 2013 03:57:20 AM

Title: Display column value based on the prompt value DMR
Post by: Shailaja0520 on 15 Mar 2013 03:57:20 AM
Hi,
I have requirement. Its a DMR.

I have a  multiselect prompt Suppose Prompt_p1  with values  A,B,C,D.

I need to display the data in a column for e.g Column 1 if  Prompt_p1 contains only 'A' otherwise nothing in that Column.

Title: Re: Display column value based on the prompt value DMR
Post by: Deep750 on 15 Mar 2013 05:16:04 AM
Isn't it possible to add a layout calculation in the column?

Title: Re: Display column value based on the prompt value DMR
Post by: Rahul Ganguli on 15 Mar 2013 06:54:05 AM
You can achieve this using COnditional Styles and Style Variables.

Regards,
Rahul
Title: Re: Display column value based on the prompt value DMR
Post by: Lynn on 25 Mar 2013 09:52:58 AM
I think you could also do it by creating a data item in the query. This would force the prompt to be required, so don't go with this approach if your prompt is optional.


case ?Prompt_p1?
when 'A' then 'A'
else null
end