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
What do you mean by drill through report?
Define datastores in cognos?
--------------Explain Table of contents?
What DB View and Bus View?
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?
How do you Parametermap variables in Quiries?
Can you define a query subject?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
What is Bitmap Index?
What is a Datastore in Cognos?
What is the deployment requirements used in cognos?
What is the difference between ‘macro’ and ‘prompt?
What are the advantages of cognos?
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
write a query to display the departments with no employee?