Report designer - How to pass Calculated Field to HyperLink property

Hi everyone

I'm having trouble to pass a variable from Calculated field to HyperLink property.

Best way to describe via screenshots.

I have defined Field1 with a formula. I have no problem to pass the content to Text property using DataField, but I can't work out how to pass it to HyperLink.

_img_ alt="User-added image" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=90660000000TSP9&feoid=Body&refid=0EM60000000LvJU" _/_img_

2. Defined Label Object

_img_ alt="User-added image" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=90660000000TSP9&feoid=Body&refid=0EM60000000LvJZ" _/_img_

3. Outcome in the report :

Hyperlink doesn't contains Field1 values. Any thought? What am I missing?

_img_ alt="User-added image" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=90660000000TSP9&feoid=Body&refid=0EM60000000LvJe" _/_img_

Tom Neer

1 mars 2016 16:29

You will need to create a script in your report for that. Something like:

Sub Detail1_Format
  'ADD HYPERLINK TO COGCC WEBSITE TO API FIELD
  
  CType(rpt.Sections("Detail1").Controls("API"), Label).HyperLink = "http://cogcc.state.co.us/cogis/FacilityDetail.asp?facid=" + CType(rpt.Sections("Detail1").Controls("lblsdf_key"), Label).Text 

End Sub

Permanently deleted user

1 mars 2016 22:52

Thanks Tom!

11 février 2019 11:42

Another good support link for those who stumble on this one.

https://support.geocortex.com/essentialsGSCForum?sub-nav=forum&main-nav=essentials&#!/feedtype=SINGLE_QUESTION_DETAIL&criteria=ALLQUESTIONS&id=9066000000007JJAAY

Report designer - How to pass Calculated Field to HyperLink property

Commentaires

Ce n’est pas ce que vous cherchez ?