Select All option in prompt

[Mita]

Hi All,

I have a checkbox prompt for coverage names which has nearly 50 or more values.Currently when the users are selecting any coverage value that is shown in the report (using layout calculation).

It works fine when they select less values.but when they are selecting the cognos builtin "Select All" option in the prompt,The report looks really bad as it has a large number of names in the top.

Is it anyhow possible that when they select "Select All" in the prompt,We will be able to show only ALL instead of all the names in the report.




Thanks in advance

[Michael75]

Hi,

The solution proposed in the penultimate post here could be adapted to your situation: http://www.cognoise.com/index.php?topic=18636.0

i.e. conditional rendering based on paramcount() > 40, or whatever.

[Mita]

Thank you Michael for your reply .

the issue is different here compared to what is mentioned in that thread.

[Michael75]

the issue is different here compared to what is mentioned in that thread.

Yes, but I think the solution is applicable. What I was thinking is that if paramcount() < 40, you could use your present display, which presumably looks like:

Code Select Expand

ParamDisplayValue('pCoverageNames')

And if it's >= 40, you could display a fixed text such as 'All available values selected'.

[Robl]

You could possibly go one step further and do a count of the number of possible items in the prompt and then compare that to the number of items selected and then base the format on that.

[RichardP]

Hi All,

I have a checkbox prompt for coverage names which has nearly 50 or more values.Currently when the users are selecting any coverage value that is shown in the report (using layout calculation).

It works fine when they select less values.but when they are selecting the cognos builtin "Select All" option in the prompt,The report looks really bad as it has a large number of names in the top.

Is it anyhow possible that when they select "Select All" in the prompt,We will be able to show only ALL instead of all the names in the report.




Thanks in advance

Hmmm.
you said..."The report looks really bad as it has a large number of names in the top."

Two options
1. I assume you are referring to using a Layout Expression to display the prompt values in the Page Header ?
If yes - what about adding a separate Prompt Parameters page at the START or END of the report - where you
could display all the values selected - and not use the Page Header real estate...

2.
You said it was a checkbox prompt
I think this would work..
Assuming Prompt is based on a Query....
Under 'Static Choices' add a value of
Use: 'ALL'
Display" 'All Values'
add a value of 'ALL' under 'Default selections'


Add a Filter to your query...

?<name of prompt> Parm? in ('ALL')
OR
[Column to Filter against] in ?<name of prompt> Parm?


Small Training  issue as user could select ALL and another value - but filter would use ALL.

ParamDisplayValue would display 'All Values'