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

Display All on report layout

Started by mrcool, 25 May 2011 10:33:44 PM

Previous topic - Next topic

mrcool

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


bvk.cognoise

#2
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
Regards
BVK

mrcool

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

bvk.cognoise

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