we have a column of int/varchar datatype,but when we run
the report we should get the date format
i.e., suppose date key is a query item consists of data as
20040105,20030503,20060410.......
output should be 5 jan 2004,3 may2003,10 apr
2006..........respectively.Can i knnow the answer
- 4 Answers
- 6333 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sa
use Extract Function
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can you define dimension?
what is catalog and types of catalogs in cagnos and which is better?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What is zero-foot print?
where you can save the report net documentation in our local system?
What is the information present in the cognos configuration file?
How is cognos model organization works?
How to generate cubes in cognos?
what is the main advantage of impromptu over cognos reportnet?
What is cognos connection?
What do you understand by user class in cognos?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
------------------What is Inline Query?
What are the types of catalogs in cognos?
