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

Answers were Sorted based on User's Feedback



If there are two values at value prompt level and when selecting first value it have to go to date..

Answer / krishna

Use conditional block

Is This Answer Correct ?    2 Yes 2 No

If there are two values at value prompt level and when selecting first value it have to go to date..

Answer / 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

More Cognos Interview Questions

what is mean by complex starschema ,star schemagrouping?

0 Answers  


What is IQD?What is contained in IQD?

3 Answers   ABC, IBM, Infosys,


I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?

1 Answers   Cap Gemini, HSBC,


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

0 Answers  


Can you define drill across?

0 Answers  


what is the difference between cognos8 fm and cognos reportnet fm?

1 Answers  


what do u mean by bridge group? where we r using this one?

0 Answers  


After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?

1 Answers  


what is the procedure for scheduling conditional rendering?

0 Answers   Syntel,


1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com

1 Answers   IBM,


How to Improve the Performance of the Report? i need this urgently .

4 Answers   HSBC,


What are the ways to import data into catalog?

0 Answers  


Categories