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
- 5299 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / krishna
case when column_Name =0 then 'NULL'
else 'column_Name'
end
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How is possible this scenario using in type-in prompt.?
What is Fullouterjoin?
Explain difference between powerplay transformer and power play reports?
Explain what is the main advantage of impromptu over cognos reportnet?
What do you understand by the term 'model durability'?
What do you understand by the term 'aggregate advisor?'
What DB View and Bus View?
What is defined as catalog and types of catalogs in Cognos?
can we insert all types of charts in a list report? what r the realtime prompts?
How to select multiple values from type-in prompt?
------------------What is Inline Query?
What is the enterprise class platform architecture of cognos 8?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
What is defined as Query studio?
