suppose a value prompt contains 100 values and i want to
select all values in that prompt....i want ALL option in
the value prompt? how can u keep this option in value
prompt?
Answer Posted / thanjairajan@gmail.com
Hi Everybody, This is very simple.don't have any calculation to solve this question.
1.Drag any one of the data container to the work area.
2.Adding data item to the container
3.Create prompt page
4.When we Add value prompt to the prompt page. we create parameter then select package item, and then when we select operator we will see more operator like =,<,>,<=,>=,in,not in, in_range. in that operator we should select in_range operator.
5.After that we do normal procedure .
6.when we run the report, If the value prompt contain 100 numerical values, we should select 1 in From drop down box and select 100 in To drop down box. If the value prompt contain char type .that is it may contain product name,select first product name in From drop down box then select last product name in To drop down box.
7.Finally in report output we will see all values in value value prompt instead of particular value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What is Bitmap Index?
What is the size of the cube?
Can you define a datastore in cognos?
what is the difference between native sql and cognos sql?
Can you explain dynamic query mode?
What do you mean by query studio?
Why need staging area database for dwh?
Give me any example of semi and non additive measures?
what is the difference between querystudio in reportnet and cognos8
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
what is online view?
What are the main services provided by application tier?