Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17201 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 |
16. How can we create top 10 and bottom 10 records in the same list?
Hai frnds, Any body tell to What is Granularuty in cognos Please help me.i can search in so many browsers but i canot get the answer
what is logs in cognos
What is meant by alternate drill down with ex?
What is parameter maps & Session parameter?
data import to models, datastores,stored processed, is there any other way to import data?
tell me two or three issues from client side and how to solve those issues?
how to get the all values from a prompt using 'ALL' use and display value in prompt
What is the difference between ‘macro’ and ‘prompt?
what are the enhancements in cognos reportnet ?
What is RenderVariable?
What is defined as data mining?
Teradata 
