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
faq's on cognos
What do you understand by the term 'model durability'?
Can you define cube?
Can you define snapshot?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
How do we convert from Numeric to be Words?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
What is defined as data mining?
What is difference between data mart and data warehouse?
How to do Performence Tunning in Cognos Reports?
tell me two or three issues from client side and how to solve those issues?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
How do you Parametermap variables in Quiries?
What is the difference between ‘macro’ and ‘prompt?
please please give me some banking calculations in framework manager.