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
- 10078 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 |
What is a dimension?
-----------------What is Singleton?
1 Answers BoA, Cap Gemini, TCS,
what is an associated query?
how to Explain a complex report at the time of interview ? please post the answer very urgent?
What are the advantages of cognos?
What are types of batch available in cognos?
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.
diff b/w layout calculation and query calculation
how many types of formats you can run a report using cognos?
what are determinants?
4 Answers College School Exams Tests, IBM,
i thought to keep fake experience..as a fresher i can't enter..bcos there is a large gap after my graduation..4 years..any person who enter with fake exp describe how to attend the interview process..
How do you use SUM function in Reportnet?
Teradata 
