hyperlink control

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:

http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24 -78f8.html#WSc3ff6d0ea77859461172e0811cbec12bda-7fb5

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.