Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 14759 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / lokendra
here we can enter one value,here it can't shows lovs.
in catalog colomns we can select the value for which we can
insert the pick list.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / s.srinivas
BY USING STRING VARIABLE WE CAN SELECT(OR)ENTER MULTIPLE
VALUES
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nasa
use soundex function
ex:
select product_line from product where
soundex(product_line)=soundex('Liza')
it will show all name related to liza or...
liiiza
leza
llliza
lezaaa.
what every it may be if pronunciation is okay it will show
all data..
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / asha
Can you be more specific abut this. What i understand from
the question, you have a prompt page with a text box prompt
and the user types the value. When the user types the
product name 'ex: laptop' and clicks 'finish' the report
page has to display all the records relevent to laptop.
When the user types 'All' in the text box prompt and
clicks 'Finish' the report has to display all the products.
Has someone tried this? Can someone help?
| Is This Answer Correct ? | 0 Yes | 1 No |
What are types of batch available in cognos?
What do you understand by the term 'aggregate advisor?'
It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha
What is the difference b/w macros and prompt?
what are the types of scheduling and what are the errors faced while scheduling then how to solve those errors?
1 Answers Dr Reddys, TCS, Thomson Reuters,
Define query items?
how can you restrict the number of values available for a prompt? i tried this by using static choices property, but i dint get result... so pls explain in detail steps....
What is Metrics designer?
How u provide security to reports in report studio or in cognos connection?
set scope level in transformer
im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
3 Answers TCS, Thomson Reuters,
Teradata 
