PENTAHO: CREATING HYPERLINK

STEP 1: Open report designer. Create a new report.

STEP 2: Drag fields to Item band.

STEP 3: Select the field for which you want to create hyperlink. Right Click on it and select CREATE HYPERLINK option.

STEP 4: Give the URL.

Note: Once you have created hyperlink you can see the automatically generated code in STYLE EXPRESSIONS :

report: SUBSTITUTE("http://images.google.com/images?q={0}"; "{0}"; URLENCODE([EMPNO]))

       

                                                  

STEP 5: Save and Run the report.

STEP 6: End.