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
- 17025 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 is Online View?
What is the importance of having monitor service in cognos?
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?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
What do you understand by the term 'dynamic cube'?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
What is Additive function?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
write a query to display the departments with no employee?
What is the difference between a cascading report and drill through the report?
How to select multiple values from type-in prompt?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
Explain difference between powerplay transformer and power play reports?
Can you define folder?
