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
- 10327 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
what are the errors faced while bursting the reports and how to solve those errors?
what is the difference between filter and condition?
what are the features in cognos8ui
Can you define fan trap?
What is the size of database for you project?
Cleared COG-112 with 100% score today. What next certification should i go for?
How to deploy from one server to another server?
faq's on cognos
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What are the components of report net?
What is the size of the cube?
what is the difference between querystudio in reportnet and cognos8
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
What are various types of gateways in cognos?
What is the difference between drill through, drill across?
