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
- 15979 Views
- TCS, I also Faced
- E-Mail Answers
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
what are the features in cognos8ui
What do you understand by the term 'aggregate cache'?
What are slice and dice?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
What is the difference between the standard and metrics folder?
How is possible this scenario using in type-in prompt.?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What are all the types of hierarchies?
What are the components used in web tier?
What is the difference between static and dynamic conditions?
How can I test reports in cagonos?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
what are the names of the reports that you prepared?
