How to change Boolean variable Yes As "TRUE" and No as
"FALSE" in Cognos reporting studio?
Answers were Sorted based on User's Feedback
Answer / chandrasekar. p
After creating boolean variable we will assign variable 'Yes' as 'True' and 'No' as 'False' from using block/style variable in cognos report studio.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / suman palisetty
write a case statement
case when [data item] ='Yes'
then 'True'
else 'False'
end
| Is This Answer Correct ? | 1 Yes | 5 No |
how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?
difference between impromptu and cognos8
What are the advantages of using cognos sql?
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?
Why Star Schema is de-normalized? Please explain in detail probably with some examples.
what is online view?
WHAT ARE THE TYPES OF LIST REPORTS?
What is difference between informatica power mart and power center?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
what is the use of macros&folders&herarchies in frameworkmanger?
How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?