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
- 15193 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 explain health care project and which reports we can create in health care doain?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
How to Reset Pagenumbers in one report.
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What is Cognos Mashup Services .what is the use of Cognos Mashup Services and where to use.
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....
----------------What is Surrogate Key?
What is a Pivot?
What is called cognos reporting tool?
What is the difference between filter & Condition?
Which one is better among Value and select & search prompts,in terms of performance?
What is the difference between regular dimension and derminant?
Teradata 
