As per the documentation it is working fine returning age in YYYYMMDD format as 21 years 02 months and 25 days for your case.
You need to format it or use some funtions to display accordingly..
Regards
K
I think you have a column (say person ID) in the group by function which forces the result to display the way you had mentioned.
If not, can be send the query generated for the report..
Regards
K
Hi All,
I am very new to SAP. And still in the process of learning. Please tell me what all needs to beconfigured in FI for PA and Py module to be used in SAP.
Its urgent please reply asap.
Thanks
swati
Just try this..
In the filter of the main tabular model, you can specify the outer join condition directly.. something like
tabularmodel1.productid = tabularmodel2.productid(+)
Hi All,
What are the Minimum requirements hardware(congif) wise for installing the visioninstance of oracle apps.
How difficult it is to do the installation???
And if one can tell me across Different OS it would be of great help.
preferable windows 2000 professional,sever and Win XP
Its...
Hi Everybody,
Can anyone help me with the concept of Web Application Dictionary. What is it??? Why do we need it and what are the advantages of having a Web Application Dictionary.
Awaiting a reply asap.
Swati.
Hi
I changed the url accordingly and ran the report and it is asking for prompt value. Do I need to change any run options for the report.
Here is the url...
I had added certain elements to CRN_HEADER_OPTIONS using the ui_add parameter in the 'system.xml' file and I could see the same in Cognos Connection page. But in the report viewer window, I could only see Cognos Connection link in the header. Is it possible to see the elements that I had added...
Hi
http://localhost/crn/cgi-bin/cognos.cgi?b_action=xts.run
&m=portal/report-viewer.xts
&method=execute
&m_obj=/content/package[@name='URL']/report[@name='City']
&outputFormat=HTML
&outputLocale=en-us
&prompt=true
&m_name=City
If I paste the above url in the address bar of internet explorer...
Can someone help me in adding a hyperlink in Cognos Connection Main page which when clicked should open a word document. Is this possible.. Please help..
Kumar
Is there a way to generate a file for all the filters that has been set against the tables, folders in a catalog for a particular user. As I am unable to see it, when I use the content overview method.
Thanks,
Kumar
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.