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
- 6356 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 |
i was asked what are the caluclations done by you in your report? plz give reply
What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?
How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.
1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.
Can u please describe the different types of traps with eg. Thanks
Why we take so long time to display date prompt before displaying a report? How can we reduce the time?
what is report view?
What is the difference b/w macros and prompt?
How you create IQD In ReportNet FrameWork?
What is the difference between a cascading report and drill through report?
how to handle multifact?
What are all the advantages of Cognos?
Teradata 
