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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Get Select all to show up in a layout calculation prompt summary

Started by bbrooksux, 25 Nov 2009 02:59:34 PM

Previous topic - Next topic

bbrooksux

I'm working on several reports where we have built a layout calculation to deliver the parameter/prompt selections within the report to show the viewer what they've selected.  One thing the report requester is wanting to add is the ability to show the text 'All items selected' in the report results if the user clicks the "Select All" link during prompt selection.  Below is the layout calculation we're using in the expression definition to this point.  Does anyone know how we would need to modify the definition in order to get this to function properly?

if (ParamCount(ParamName('prompt'))>15)                                 
THEN ('Greater than 15 selected')                                       
ELSE                                                                   
(ParamDisplayValue('prompt'))

mgibson

We do things a little differently.  We set the prompt as Optional, and encourage users to select 'Nothing' if they wish to see all items (i.e. we include these instructions on the prompt page).  Then we display 'All', where the prompt parameter is Null.

Regards
Mick

vinu

HI,

use java script or static choice to create 'All items Selected' text in your prompt.

and you can try below in your layout calculation.

Case
when (ParamCount(ParamName('prompt'))>15) then ('greater than Fifteen selected')
when (ParamDisplayValue('prompt')='All items selected') then ('All items selected')
else ParamDisplayValue('prompt')
End

Regards,
Venu.