Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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'

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


Please Help Members By Posting Answers For Below Questions

is there any difference between operational database and data base?if yes what r they?

2066


Which studio is used to create reports?

1108


--------------Explain Table of contents?

2024


Can you explain new content durability?

1030


what is degenerate key in oracle ?whare do we use it?

2563


what is a prompt value in report studio and variables ?

2716


What are the advantages of using cognos sql?

1194


9. What was the most complex type of report you dealt with?

2215


Can you define query studio?

960


--------------Diff b/w ODS and OLAP?

3207


What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

2147


-------------How you design DWH?

2312


What is meant by Reportstudio shortcut?

2188


What are the advantages of shortcuts?

968


What is the difference between Standard and Metrics folder?

1082