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...

Sure..I will compare and will let you know..or I will psot two URLs here..thanks a lot for your help..

Yes, we use Livelink but not NTLM authentication..

Hai Grifftihs Hyperlink works now. but on clicking the hyperlink it asks for login and then after login it displays the document that is hyperlinked. Even though user is login in one tab of the browser it still asks for login.. Is this any cookie issue? Please help on this. Thanks

Working link example: opentxt.com/examples/reports/......... Basically this is formed by using LL_PATH and this line of code in web report. <A HREF="[LL_REPTAG=DATAID LLURL:DEFAULTLINK /]">[LL_REPTAG=DATAID NODEINFO:NAME /]</A> When the web report having this line is ran, hyperlink shows up...

Hai Griffiths or any one, Can you help me on this please? Thanks

Hai I just found the problem. The link that appears in excel is absolute one and that is causing the problem. Because when the file is downloaded to our desktop path changes and its linking desktop path to document's path on server and says file not found. How to overcome this issue? thanks a...

Its in Enterprise work space. There are many subfolders in it. And library folder is existing in each project folder. I tried using location like '%Libra%' but query is toooo slow. so is there any way to do this?

Can someone please reply for this?

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..

When I search on the forums,I see there is a limit on length of URL when passes from wen report into Excel..?!! not sure if this is true..

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...

I searched in the site but could not find much helpgul info.Can you just guide me on this please?

For example my web report has 2 records as output. Each record has email ID in a field. So, I used [LL_reptag_1/] in email field (webreport -? properties -> destination). Email is being sent correctly to those two people. But my problem is each of the two users should get only their record but...

I am using WebReports. I know the dtree and user table kuaf. But I am not sure how to send notifications to users automatically by running a report.

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...