If there are two values at value prompt level and when selecting first value it
have to go to date prompt and when selecting second value we have to get
output without any prompting. How to solve this issue. if any plz mail me on this
vasuattada@yahoo.co.in
Answer Posted / pradeep
create a dataitem ib the query like...
case
when ?first? = 'Product Line' then [Product]
else
?Product?
end
use this dataitem in the filter condition for product
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are slice and dice?
What is the complex report you faced in real time?
Cleared COG-112 with 100% score today. What next certification should i go for?
What is the difference between group and associare?
what is online view?
What are the methods by which it non-durable model could be changed into the durable model?
What is defined as Query studio?
New coloums are added in database, then how you know in report level
Name the types of report?
How to a create header dynamically in a crosstab report in cognos 8.1?
What is the difference between static and dynamic conditions?
What are all the components of Report Studio?
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..
which type of project we r going to snowflake schema
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?