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
- 17191 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 components of report net?
What is zero-foot print?
What is the difference between ‘macro’ and ‘prompt?
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
What are all types of Batches?
Give the advantages of cognos?
What is called a slice?
in u r data u having duplicates how to fetch the latest data in our report?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
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.....
How do we convert from Numeric to be Words?
7. What is performance tuning?
-----------With out using DrillThrough how to do Reports?
How to select multiple values from type-in prompt?
