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
- 10480 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / sreenivasulu pokuru
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 |
Post New Answer View All Answers
How is cognos model organization works?
Explain the different types of views used in cognos.
How do we drill through from a powerplay cube to reportnet?\
What is Online View?
how you migrate reports to cognos 8 from previous versions?
What is the difference between Open Connection command ang Open Session Command?
How to create model and how to test model?
What are the advantages of using cognos sql?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
what is the difference between native sql and cognos sql?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
What are all the types of report?
what is hints in cognos and where we use it.
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What are products of cognos?
