Search results for query: *

Hai all I have a live report with 5 input parameters. I have a web report to run it. 5th parameter I want to have a static drop down with values. How do achieve this? I did this way. Created a new web report (html code) by having that drop down and creating a run button which calls the other...

Hai This is my query to give contractx expiring in 15 days but I am getting lot of repetitions. How could I avoid them? select A.DATAID, A.Filename, to_char(A.ValDate,'Month DD, YYYY') "EXPIRY DATE", REPLACE(A.ExpireIn,'?','') "EXPIRE IN # OF DAYS" , A.Location LOCATION FROM (select...

Hai all I am working on something like this. Hope someone can help me. Consider this as sample data Field1 Field2 John GA Mark FL Steve MI John CA John IL Can someone assist me on a query to have data like this? Field1 Field2 John GA, CA, IL Mark FL...

Hai I completed a report to show all contracts that expire in a week etc. Is there any way to find only those contrats (documents) that are in library folder? Thanks all..

Hai all, I developed a live report and displaying the output using webreport. One field (location) is hyperlink so that, when it is clicked it opens the document. This works when output is html. But user wants excel file to be downloaded to desktop. If I put that setting in destination of...

Hai all I developed a report to show documents that are going to expire in 30 days. Now I need to send an email notification to the owners of the reports. How could this be done? There is email option when developing a report but how could I send this owner email ID over there? Thanks a lot..

Hai We are using Opentext for document management. Each document has a unique URL to access it. When we access this URL (we use WSL - Web Single Logon) the document's URL is getting changed to something else when redirected through WSL after user logs in. But if user is already logged in...