Interested to Buy Any Domain ? << Click Here >> for more details...
Can someone tell me whether we can apply filter on list of
values in the 'Value Prompt'? e.g. I have a value prompt
(named city) and the prompting is holding around 2000
cities but I want to apply filters on cities so users can
select only 15 cities out of 2000 and then run the report.
Users should be flexible enought to select any 15 cities
from the list. Is it possible. Please advice!
- 5 Answers
- 10491 Views
- DELL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Step1:take a list report with country column.
step2:create a value prompt based on country.
step3:go to query explorer
step4: select query-2 based on value prompt.
step5: drag country query item into detailed filter.
step6: write a filter condition like(country in
'india','china',............)
step7:run the report
Diffenetly u will get what requirement u have to do.
Thanks & regards
Sreenivasulu pokuru
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / keyrun
Yes it is possible using Mapping Variable & Mapping parameters!
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / sathish kumar
first you create value prompt as usual with parameter and applying the filter on city.
In the next step,you need to create the static choices to select the 15 cities among 2000.
And run your report..,
am sure you will definitively get the output.
| Is This Answer Correct ? | 2 Yes | 1 No |
Is it possible to create drill through access to other report from PDF report?
what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me
Hi i want know mean and difference b/w render variable,conditional block and style variable please reply about them please be kind towards me
Explain the different stages in creating a report in cognos report net?
17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?
What is difference between page break and section report?
What is the use of Generated Prompt? Where is it used in realtime project?
What is model?
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
Can you define materialized view?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
Teradata 
