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
7. What is performance tuning?
What is the model filter?
What are the advantages of using cognos sql?
What is a Folder?
What you mean by drill across?
Explain about scorecarding?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
What is dtm?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
How is possible this scenario using in type-in prompt.?
Can you define cognos decision stream?
-----------------What is Determination Model?
what is requery in cognos?