COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 03 Dec 2010 03:22:03 PM

Title: How to get rid of "and" text in the filter expression in between select prompts
Post by: jd on 03 Dec 2010 03:22:03 PM
I have to display selected prompts(filter expression) end of my list report.

I have around 10 prompts in my report.
ex: Region, Location, site, program, product etc..

when I ran the report end of the report I have to show these prompt values like below:( using and text)

Region and Location and Site and Program and Product.

Here I am haveing issue..

If I select only Region, Product filters in the report filter expression has to show like Region and Product but here I am seeing Region and and and and Program

I tried to use conditional formatting also to get rid of this extra "and " text but no luck .

could you please share any ideas to resolve this 
Title: Re: How to get rid of "and" text in the filter expression in between select prompts
Post by: Sreeni P on 06 Dec 2010 01:20:52 AM
Quote from: d.laxmi on 03 Dec 2010 03:22:03 PM
I have to display selected prompts(filter expression) end of my list report.

I have around 10 prompts in my report.
ex: Region, Location, site, program, product etc..

when I ran the report end of the report I have to show these prompt values like below:( using and text)

Region and Location and Site and Program and Product.

Here I am haveing issue..

If I select only Region, Product filters in the report filter expression has to show like Region and Product but here I am seeing Region and and and and Program

I tried to use conditional formatting also to get rid of this extra "and " text but no luck .

could you please share any ideas to resolve this 


Hard code the 'and' in Layout calculation along with your displayParameterValue