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!
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
What is the difference between group and associare?
7. What is performance tuning?
How do you Parametermap variables in Quiries?
Why cognos scenario is used?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
What is the information present in the cognos configuration file?
How can you link a query to a data container manually in Report Studio?
what is the procedure for scheduling conditional rendering?
What is defined as Cognos Impromptu?
Explain the difference between native sql and cognos sql?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What is a Query Subject?
how you migrate reports to cognos 8 from previous versions?
What are the services provided in cognos 8?