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

What is the use of powerplay web viewer in cognos?

1029


Can you define report item?

980


What are slice and dice?

877


What DB View and Bus View?

1929


Explain the difference between native sql and cognos sql?

930


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

11607


What is the use of cognos decision stream?

1036


How can I test reports in cagonos?

904


how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

1100


If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

2046


How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

1973


Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3554


hi my name is siraj i want to know cognos queriy language

2213


What you mean by drill across?

973


how u will determine the performence tune will occur either in report or system

2077