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