Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. visopenlive

    Drop down web report

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

    Contracts expiring in 15 days

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

    Multiple records one column separated by comma (,)

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

    Hyperlink not working in Excel

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

    Hyperlink not working in Excel

    Yes, we use Livelink but not NTLM authentication..
  6. visopenlive

    Hyperlink not working in Excel

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

    Hyperlink not working in Excel

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

    Hyperlink not working in Excel

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

    Hyperlink not working in Excel

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

    Search in library folders only

    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?
  11. visopenlive

    Hyperlink not working in Excel

    Can someone please reply for this?
  12. visopenlive

    Search in library folders only

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

    Hyperlink not working in Excel

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

    Hyperlink not working in Excel

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

    Email notification

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

    Email notification

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

    Email notification

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

    Email notification

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

    Opentext Redirect URL

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

Part and Inventory Search

Back
Top