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 / 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 |
Post New Answer View All Answers
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
Can you explain model durability?
in u r data u having duplicates how to fetch the latest data in our report?
Name the types of gateway?
What actually a project contains?
Can you define transformer?
Can you define query studio?
what are the dimensions that you have in your current project?list them?
How to publish a package by running Java Script?
--------------Diff b/w ODS and OLAP?
What is Online View?
Can you define a datastore in cognos?
What is the use of Cognos scenario?
hi friends pls forward impropmtu interview question
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?