Copy link to clipboard
Copied
I would like to have a control to have hyper link based on data source.
I would like to know does Report Builder have any controls that I can set hyper link based on data.
Your help and information is great appreciated,
Regards,
Iccsi,
Copy link to clipboard
Copied
iccsi wrote:
I would like to have a control to have hyper link based on data source.
I would like to know does Report Builder have any controls that I can set hyper link based on data.
Yes, see the "Using Links" section on the following page:
Copy link to clipboard
Copied
Thanks for the message and helping,
I am looking for the hyperlink based on the data.
For example, if the data is 100 then I want to the hyperlink www.myserver/100.cfm
if data is 200 then I want to link to www.myserver.com/200.cfm
Thanks again for helping,
Regards,
Iccsi,
Copy link to clipboard
Copied
iccsi wrote:
I am looking for the hyperlink based on the data.
For example, if the data is 100 then I want to the hyperlink www.myserver/100.cfm
if data is 200 then I want to link to www.myserver.com/200.cfm
You can use a report function to return the desired URL based on the data in your query.
In other words, in the "Expression" property of your hyperlink report object, pass the query field to a function which then returns the URL as a string.
Copy link to clipboard
Copied
Thanks a million for the information and help,
Regards,
Iccsi