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

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

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?

0 Answers  


what is difference btw summary filter and detail filter, plz explain with example

10 Answers   IBM, TCS,


What is a scope? can you tell me one example for scope?

1 Answers   CTS, IBM, TCS,


Can you explain dynamic query mode?

0 Answers  


How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take <html item> my question is how to use parameter value in the html page .)

4 Answers   JKL, Kudos India,






What is cognos powerhouse?

0 Answers  


Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com

2 Answers  


Is it possible to apply access manager user rights in impromptu?

1 Answers  


How can we do the unit testing?

3 Answers   Logica CMG,


What is Lookup ,bridgeing tables where they will use in the Dataware house

2 Answers   IBM,


how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

0 Answers   NEC,


How to crate cubes in transformer ?

3 Answers  


Categories