Adding Hyperlinks to Reports

Add a column to the report query using the below snippet substituting <TABLE> with whatever table you are linking to (i.e., WorkOrder, Asset, PreventativeMaintenance).

CAST(<TABLE>.<TABLE>ID AS NVARCHAR(50)) + '/false/' +

(SELECT CAST(vwGetGuid.Guid AS NVARCHAR(50)) FROM vwGetGuid) AS Link

Then: 

1. Select the field you want to be hyperlinked 
2. Open the Properties tab. 
3. Expand the data bindings in the data section.
4. Add the new Link Column in the Navigation option as shown below.

Lastly, copy the /MEXData/#/...../ part of the url and paste it into the Format String options for the Navigation option.