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
- 17046 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 |
What is called Cognos powerplay?
Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance
What is the enterprise class platform architecture of cognos 8?
What is the difference between Standard and Metrics folder?
what is the use of layout calculation?
Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?
what is the automation tool used for data warehouse testing???
3 Answers Covansys, IBM, Wipro,
how can you restrict the number of values available for a prompt? i tried this by using static choices property, but i dint get result... so pls explain in detail steps....
How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take <html item> my question is how to use parameter value in the html page .)
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
------------------- What is Busschema?
After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?
Teradata 
