PENTAHO: CREATING HYPERLINK

1: Open report designer. Create a new report.

2: Drag fields to Item band.

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

                

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]))

5: Save and Run the report.

6: End.