How to change Boolean variable Yes As "TRUE" and No as "FALSE&qu

How to change Boolean variable Yes As "TRUE" and No as
"FALSE" in Cognos reporting studio?

Question Posted / vmvkreddy

2 Answers
10464 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to change Boolean variable Yes As "TRUE" and No as "FALSE" in Cognos report..

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

How to change Boolean variable Yes As "TRUE" and No as "FALSE" in Cognos report..

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

Post New Answer

More Cognos Interview Questions

what is online view?

0 Answers HCL,

hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........

1 Answers TCS,

Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

0 Answers

What do you understand by the term 'dynamic cube'?

0 Answers

How will you migrate your reports to QA environment?

2 Answers Satyam,

what are the dimensions that you have in your current project?list them?

0 Answers IBM,

what is a join? what are the types of joins?

5 Answers HCL, Satyam,

How we check the errors before running the report,plz let me know the answer