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