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
Cleared COG-112 with 100% score today. What next certification should i go for?
What are the message flows?
What is difference between page break and section report?
What are all the components of Report Studio?
what are the dimensions that you have in your current project?list them?
Explain what is the difference between native sql and cognos sql?
what is the difference between list report and crosstab report?
what is the difference between querystudio in reportnet and cognos8
Can you define materialized view?
Can you define dimension?
What are all the advantages of Cognos?
What are the types of studio?
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...
What is difference between data mart and data warehouse?
What is a dimension?