If you are unable to create a new account, please email support@bspsoftware.com

 

How to get rid of "and" text in the filter expression in between select prompts

Started by jd, 03 Dec 2010 03:22:03 PM

Previous topic - Next topic

jd

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 

Sreeni P

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