Interested to Buy Any Domain ? << Click Here >> for more details...
I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'
- 2 Answers
- 6346 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / naresh
Create one new Derived Column ,In derived column Expression use case statement as ---->
case when column_Name =0 then 'NULL'
when column_name<>0 then cast(column_name,varchar(20))
end
after this hide the original column by checking properties of column
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
what is stitch query in reportnet?
Can you define snapshot?
Is it possible to join multiple Databases in a Catalog?
what is online view?
What are all the different types of prompt in cognos?
How to create a cube in Transformer? What is the process? Please mention process thank u
what is the procedure for scheduling conditional rendering?
Why cognos scenario is used?
how you provide security to reports? How you provide security to packages ?
What is the difference between drill through, drill across?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
what is degenerate key in oracle ?whare do we use it?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
-------------How you design DWH?
