how can you create a report like if country=india then true
if contry=spain then false?
Answer Posted / arkchowdary
Actually your question is not clear.
2 ways we can do which you asked why bcz --------- If u
want to do on same Column then u can use Conditional
formatting
Another One------------ If you want to do display result on
new column take new Query Calculation.
-------------- With the help of New query calculation we
can do this Report.
Ex------------ In Query Defnition you need to give
condition like this-------------- If Country='INDIA'
then 'TRUE
else If country='SPAIN' then "FALSE'
Another One is --------------- Through Conditional
Formatting we will do this Report.
Ex---------------- Use Boolean Variable we will do
If Condition is True then select Yes.
If condiotion is False then select No.
I Hope Clear.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
hi friends pls forward impropmtu interview question
Define catalog in cognos and write its various types?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
Can you define framework manager?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
what is the difference between list report and crosstab report?
What are the different uses of a repository manager?
What are the advantages of cognos?
What errors and types of errors you faced in Cognos ReportNet?
What are query items?
How is possible this scenario using in type-in prompt.?