Hi All,
I have a report header with the values selected in the prompts.
When the user selects 'Select All' from multi select value prompt I want to display 'All' instead of all the 100-200 values it has.
Any java script or straight away feature in 8.4?
Thanks,
Mrcool
http://www.ibm.com/developerworks/data/library/cognos/reporting/scripting_techniques/page516.html?ca=drs-
Also
http://www.cognoise.com/community/index.php?topic=12836.0
Hope this helps
Cheers
Peter B
Hi mrcool,
may be it helps you.please try this.
>create areport
>create a prompt (for eg:value prompt on required column)
>then select that value prompt
>add static choice like
use value as : ALL
Display Value : ALL
>then go to report page
>click on filter symbol
>edit filter as follows
(?parameter?='ALL') or ([dataitem]=?parameter?)
foreg:my data item name is product type
my parameter name is ?cognos?
it will look like this
(?cognos?='ALL') or([producttype]=?cognos?)
>click ok
>now drag a layout calculation in report header
>drag parameter into layout calculation
>now run the report
whenever you select all in the prompt in will shows all records and as well as your report header also shows ALL
hope it helps you.if its not correct answer let us wait for better answer. :(
thanks
bvk
Thank you Peter but this doesn't help me as I want to show the prompt values in report header using layout calculation.
I have a multi select value prompt on prompt page which has 200 values.. When I click select all button on prompt I should show 'All' on report header. If user select 10-20 values he should see all 20 values on the report.
Cheers,
mrcool
Hi mrcool,
i am sure you can achieve that requirement using above steps which i suggested you in my previous reply.
if its not your requirement please excuse me.
thanks
bvk