LBI crystal report with link to Portal Form

Sort:
You are not authorized to post a reply.
Author
Messages
JeanneS
Veteran Member
Posts: 49
Veteran Member


    How do you create a link in a Crystal Report that is published on a dashboard to link to the Lawson Portal?  I have a report that contains PO information and I want to create a link so when the user clicks on the PO number it takes them to the PO20.1 form with the PO number from the report auto populated in the PO20.1 form.

    Thanks!

     

    Milo Tsukroff
    Veteran Member
    Posts: 47
    Veteran Member

      In a Crystal Report - insert a picture. Right-click, then choose Format Graphic. Choose the right-most tab - "Hyperlink". From there, set up the hyperlink. You have access to objects within the Crystal report - set up the Hyperlink string as
      "http://servername/" & {FILE.FIELD} & "/more"
      Sorry I'm not good with AGS type calls, but you get the picture - Make it a full hyperlink call, enclose strings with quotes, concatenate with the ampersand, and pull in string info as necessary from the rest of the Crystal Report.

      We have found issues with security when we do this. If the report runs under a single user, fine, however if the report is made into a PDF sometimes the link won't work, and sometimes if the link works within a PDF but the report is sent to someone else, the DSSO security will kick in. Good luck!

      JeanneS
      Veteran Member
      Posts: 49
      Veteran Member

        Thank you.  I actually ended up creating a hyperlink on the PO number field so the PO number auto populates on the PO20 screen.  Thanks again

        Nirav Bhatt
        Basic Member
        Posts: 6
        Basic Member
          Hi,
          My name is Nirav Bhatt. I am working on the Crystal Report which requires hyper link of Lawson PO20 form. This form should be inquire using company and PO-Number which i will pass from the report. I saw a post where you have done similar thing. Can you please tell the syntax of the link?
          Thanks you very much.

          Nirav Bhatt
          You are not authorized to post a reply.