Page 1 of 1

Hyperlink

Posted: Fri 24 Feb 2017 12:11
by nusa
Hi,

in my DB, I store an hyperlink. I make a report and I wanted to skow the hyperlink but I wanted that hyperlink is active.

An example :
https://cl.ly/2f210x2I021c

I wanted the link http//......./incidentmangement/ticket/Edit/1400 is active for a click on my report.

Is it possible?

Thank's.

Nusa

Re: Hyperlink

Posted: Fri 24 Feb 2017 13:00
by alexa
This can be setup as follows:

Image

Re: Hyperlink

Posted: Mon 06 Mar 2017 14:27
by nusa
Thank's for your help but it's not good. My hyperlink is a field on my query :

Code: Select all

Ticket.ReturnUrl
https://cl.ly/0f1S2N2G2D02

my Query :

Code: Select all

SELECT
  Ticket.Number
 ,Company.FirmName AS Client
 ,Ticket.Subject AS [Objet de la demande]
 ,[User].Username AS Demandeur
 ,[User].Email
 ,Ticket.RequestDate AS [Date de la demande]
 ,State.Name AS Etat
 ,Ticket.StateId
 ,Ticket.ReturnUrl
FROM MembershipManagement.[User]
INNER JOIN OrganizationManagement.Company
  ON [User].CompanyId = Company.Id
INNER JOIN IncidentManagement.Ticket
  ON Ticket.RequesterId = [User].Id
INNER JOIN WorkflowManagement.State
  ON Ticket.StateId = State.Id
WHERE Ticket.StateId <> 'e6dddf02-c8c9-45da-9937-1e2d8126c208'
AND Company.FirmName LIKE '%- AV%'
ORDER BY [Date de la demande]
Nusa