Prompt Page to show option for 1) Top 5 Products 2) Select All Products

[nsaxena]

Hi All ,

I have a prompt page showing product name,and users can do multi select.
Apart from display product names,i also want to show 2) 'All Products' (user can see data for all products) 2) Top 5 Products ( which will be calculated based on measure field,and if user select this static prompt choice,report should run only for top 5 products).

For  'All Products' i can put in detail filter like :- [Product_name] in ?prompt_product? or ?prompt_product?='All Products' .
'All Products' is static choice in prompt.

But i am not able to get how to show Top 5 Product option in prompt .Any suggestions!

Thanks!

[nsaxena]

Got to this link.
http://www.sourcetofind.com/how-to-display-multiple-rank-choice-to-user-at-prompt-value-in-reports-designed-using-cognos-report-studio/

Will try this.Looks like it will work.

[MFGF]

Hi All ,

I have a prompt page showing product name,and users can do multi select.
Apart from display product names,i also want to show 2) 'All Products' (user can see data for all products) 2) Top 5 Products ( which will be calculated based on measure field,and if user select this static prompt choice,report should run only for top 5 products).

For  'All Products' i can put in detail filter like :- [Product_name] in ?prompt_product? or ?prompt_product?='All Products' .
'All Products' is static choice in prompt.

But i am not able to get how to show Top 5 Product option in prompt .Any suggestions!

Thanks!

Are you using a dimensional package or a relational package?

[nsaxena]

hi MFGF,

I am using relational model.