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 |
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?
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?
Can you explain dynamic query mode?
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 .)
What is cognos powerhouse?
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
Is it possible to apply access manager user rights in impromptu?
How can we do the unit testing?
What is Lookup ,bridgeing tables where they will use in the Dataware house
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
How to crate cubes in transformer ?