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
- 6334 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
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
What is defined as catalog and types of catalogs in Cognos?
Can you define query studio?
What is a Transformer?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
Can you explain model durability?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What are all the components of Report Studio?
What is cognos powerhouse?
Is it possible to join multiple Databases in a Catalog?
What r the names of the reports that you prepared?
What are the types of folder present in cognos?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
What is the use of report studio?
