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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What you mean by drill across and what is the difference between drill through, drill across?

741


Define olap designer?

887


What are various types of gateways in cognos?

727


What is drill down and slicing and dicing whats the difference between them?

748


where you can save the report net documentation in our local system?

825


What do you understand by the term 'aggregate cache'?

740


Can you define metrics designer?

811


---------------Tell me about DWH Concepts?

1816


Define the slice and dice?

748


What are query items?

784


What DB View and Bus View?

1759


We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2293


----------------Diff b/w Dimensional modeling and Relational modeling?

14330


What is difference between primary key and unique key constraints?

749


What are all the types of indexes in Cognos?

888