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 do you mean by drill through report?

794


Define datastores in cognos?

756


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

1797


What DB View and Bus View?

1798


Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4458


How do you Parametermap variables in Quiries?

2024


Can you define a query subject?

824


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2535


What is Bitmap Index?

835


What is a Datastore in Cognos?

1048


What is the deployment requirements used in cognos?

1451


What is the difference between ‘macro’ and ‘prompt?

788


What are the advantages of cognos?

763


Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

1901


write a query to display the departments with no employee?

1784