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