Skip to Content
Mar 19, 2013 at 09:58 AM

Crystal Reports: Orange Link Arrow to OPCH (Purchase Invoice)



This is my first attempt at using link arrows in Crystal Reports, so please bear with me.

I created a test Crystal Report using the following fields from SAP Table OPCH (Purchase Invoice):

DocEntry, DocNum, CardCode, U_Scan.

U_Scan is a User Defined Field which was created in Marketing Documents and defined as ‘Link field’

The purpose of this field is to attach scanned PDF files of Suppliers’ Invoices.

When I click on this UDF, the scanned PDF pops us.

In this way, it’s easy to view the Purchase Invoice without the pain of searching for the hard copy.

Now for link arrow:

In the Hyperlink X-2 box, I type this formula:


When I run the Crystal Report from SAP (Preview External Crystal Reports File), I see a golden link arrow on each row.

When I click on one of these arrows, the relevant A/P Invoice Screen pops up.

If I then click on the UDF (which is on the same screen), the scanned invoice pops up.

Now, this is not exactly what I want.

I don’t want users to have access to the A/P Invoice screen (accidental modification!).

I want them to go directly to the PDF.

I want the scanned invoice to pop up when the user clicks on the golden arrow in Crytal Reports.

Is this possible? How can I modify my formula to make it possible?


Leon Lai