FastTrack360 Version 12 Online Help

Add Hotlinks to a Report

The Stimulsoft report design supports the ability to embed hotlinks within Custom Reports (custom SQL query), which will support opening entity records.  There are three elements required to build a hotlink, the url, the parameter and the report field.  For example to add a link to the Client Record from a report you would need to add:  @ClientURL/@Client/{JER.ClientId}

Below is a list of parameters and the related report field required:

Parameter

Report Field Required

@Candidate

CandidateId

@JobOrder

JobOrderId

@TempJob

JobOrderId

@ContractJob

JobOrderId

@PermJob

JobOrderId

@Parent

ParentCompanyId

@Client

ClientId

@Contact

ClientContactId

@CostCentre

CostCentreId

@Leave

LeaveRequestId

@user

UserId

@Timesheet

dbtemtempid

This string is added to the hyperlink property associated with the field in the report as per the example shown below:

 

When using hotlinks, test your report in view mode and not via the editor preview.

If you wish to create a report using hotlinks and you do not have a user that is familiar with report writing, please contact your Account Manager or Professional Services.





Classification-Public