Interested to Buy Any Domain ? << Click Here >> for more details...
I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'
- 2 Answers
- 6333 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naresh
Create one new Derived Column ,In derived column Expression use case statement as ---->
case when column_Name =0 then 'NULL'
when column_name<>0 then cast(column_name,varchar(20))
end
after this hide the original column by checking properties of column
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / krishna
case when column_Name =0 then 'NULL'
else 'column_Name'
end
| Is This Answer Correct ? | 8 Yes | 0 No |
can any one say the which is the best performance in framework manager
How do we create Links & Segments in Cognos Framework Manager?
-----------------What is Determination Model?
what is filter?give me one example that you created a report in your project?
What are the different types of OLAP. Which one is Cognos Powercube?
What are the different ways of adding data in Transformer?
what is hints in cognos and where we use it.
what are ERP systems?
What is the difference between Standard and Metrics folder?
What is snapshot ?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
Where in report Studio's property pane can I find NoDataHandler?
Teradata 
