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
- 6433 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / krishna
case when column_Name =0 then 'NULL'
else 'column_Name'
end
| Is This Answer Correct ? | 8 Yes | 0 No |
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
Tell me about Dnamic and Static Dashboards?
how to explain health care project and which reports we can create in health care doain?
2.How do you drill through report from Report Studio to Analysis studio?
is cognos 7 is better than cognos 8
why we r using report studio in webbased only and fm windows based only
What junk dimension contains?
Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos
3.User1 doveloped some report,user2 modify the same report and user 3 also updates in that same report? how to identify that report will be modified or not?
1 Answers IBM, Thomson Reuters,
After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......
Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.
Teradata 
