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
- 6347 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / chiru
hi, there are two ways to change date format in cognos....
1) In Query Studio right click on Date key and select the Data format ... Select Format type = "Date" In Right Side u will get different formats of date.. there u can select the Format type and click ok and then run the report
2) In Report Studio, right click on Date key and select Format type is "Date" and right side, display the properties... in Properties select the Date Ordering.. in drop down u will get date formats, select and click ok.. now run the report
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are products of cognos?
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 main difference mapplets and mapping?
What do you understand by user class in cognos?
How to deploy from one server to another server?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
What do you understand by the cognos?
What is meant by alternate drill down with ex?
Explain is there any comparison available for cognos reportnet vs crystal reports?
what is power prompt in cognos ep7series?what is the use of this?
What is the difference between static and dynamic conditions?
what is hints in cognos and where we use it.
What is the difference between the standard and metrics folder?
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?
what are the special features in cognos reportnet?
