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'
Answer Posted / krishna
case when column_Name =0 then 'NULL'
else 'column_Name'
end
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
is there any difference between operational database and data base?if yes what r they?
Which studio is used to create reports?
--------------Explain Table of contents?
Can you explain new content durability?
what is degenerate key in oracle ?whare do we use it?
what is a prompt value in report studio and variables ?
What are the advantages of using cognos sql?
9. What was the most complex type of report you dealt with?
Can you define query studio?
--------------Diff b/w ODS and OLAP?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
-------------How you design DWH?
What is meant by Reportstudio shortcut?
What are the advantages of shortcuts?
What is the difference between Standard and Metrics folder?