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
- 16810 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
Define olap designer?
How the Bursting happens in same report and how to Print the bursting Report?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
what are the filters in framework manager and report studio?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
What r the names of the reports that you prepared?
What are shortcuts? Where it can be used? What are the advantages?
Can you explain dynamic query mode?
What are the ways to import data into catalog?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
Give the advantages of cognos?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
What is the difference between static and dynamic conditions?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
