how can you restrict the number of values available for a
prompt?
i tried this by using static choices property, but i dint
get result... so pls explain in detail steps....
Answers were Sorted based on User's Feedback
Answer / chandra
when you create prompt report studio create a separate query
for that prompt. in this query write the filter condition.
It will filter the prompt values in prompt.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / vij
hi
Click that particular prompt and go to the Properties
pane , in that select the property Rows Per Page and set
the value that u want e.g. 5000,100000 etc.
Hope it will help u
Thanks,
vij
:)
| Is This Answer Correct ? | 4 Yes | 10 No |
what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?
Can we test the report other than manual testing?
What errors and types of errors you faced in Cognos ReportNet?
Is it possible to create drill through access to other report from PDF report?
Main Differnce between Cognos7 and Cognos8
What is the use of powerplay web viewer in cognos?
When we use consume in cognos?
------------------What is Inline Query?
Can you explain new content durability?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha
How to move reports one server to another server?