How to select multiple values from Type-in prompt?
Example - I want to enter into type-in prompt in 'Product
name--- Liza' display report data in 'product name is Leza'
only OR I want to enter into type-in prompt in 'All', that
time display report data in all are report data. How is
possible this Scenario using in type-in prompt.

Answer Posted / cognos

By using the following condition as the filter for the
textbox prompt we can get the data for the specified
product as well as All products when we type ALL in textbox
prompt

Product name = ?P_ProductName? or 'ALL' in (?P_ProductName?)

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1693


9. What was the most complex type of report you dealt with?

1922


what is stitch query in reportnet?

844


Can you define drill across?

760


Can you define a datastore in cognos?

821


What are the steps to import the two data sources in framework manager?

816


What are the components of the report studio?

895


What are the considerations regarding performance kept in mind while setting up cognos?

753


What is a Query Subject?

886


What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2341


Can you define materialized view?

829


Can you define a query subject?

807


Define the slice and dice?

769


What is set to be cardinality?

873


What is the complex report you faced in real time?

1955