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?
- 5 Answers
- 15974 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / hannah
To create an All static choice in the Year parameter follow below steps:
1. Create a Static Choice with Use value as 1 and Display value as All.
2. Create a query for the prompt with the following definition
[Year] <= {year(getdate())}
Run the report and your report works as if all the years were selected.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / gnani
As per my knowledge.. using static choices u can acheive
this.
i.e. u have to add add value and display value for value
prompt with ALL.
| Is This Answer Correct ? | 2 Yes | 8 No |
Answer / varma
As per my knowledge.you can use render variable.for example
if u want to select product number from the list.go to
prompt page and select 1 value prompt.enter a
parameter.don't create
any parameterized filter and query.
just enter static choice as All.create a string variable and
assign the parameter to the string variable. add the value
as All.
select product number from the list with the list column
from the property pane.
assign the render variable All to the list.
| Is This Answer Correct ? | 0 Yes | 6 No |
How to create Events?
write a query to display to 10 max record from the employee table?
What are the different type of securities can we apply in framework manager?
-------------------What is Deployment?
what are the features in cognos8ui
------------------- What is Busschema?
Explain the different stages in creating a report in cognos report net?
what is logs in cognos
In an existiing Framework model, how will you add a new column to the existing table?
what is mean by cognos powerhouse?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
advantages of detailed filter??? and summarized filter???
Teradata 
