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...

im having null data in one of the cell in my report
i have to display as "no data" when u run the report
how can i achive this problem?

Answer Posted / nikhila reddy

we isnull



select isnull(col name,'no data')

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Cleared COG-112 with 100% score today. What next certification should i go for?

1833


What are the message flows?

978


What is difference between page break and section report?

1207


What are all the components of Report Studio?

1094


what are the dimensions that you have in your current project?list them?

2024


Explain what is the difference between native sql and cognos sql?

1002


what is the difference between list report and crosstab report?

1181


what is the difference between querystudio in reportnet and cognos8

2135


Can you define materialized view?

1045


Can you define dimension?

1080


What are all the advantages of Cognos?

1037


What are the types of studio?

1144


my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

4217


What is difference between data mart and data warehouse?

978


What is a dimension?

1028