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
- 6434 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 actually a project contains?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
What are the methods by which it non-durable model could be changed into the durable model?
Explain difference between powerplay transformer and power play reports?
What are the themes in a data warehouse?
What is the information present in the cognos configuration file?
Name the types of report?
---------------Tell me about DWH Concepts?
Explain the difference between powerplay transformer and power play reports?
How to deploy from one server to another server?
What are the two types of framework manager?
What are the roles defined by cognos platform?
how u will design the report if the objects are available
what are the errors faced while bursting the reports and how to solve those errors?
What are the different types of reports present in cognos?
