Hi,
This is a very simple question: I want to create a table report with the report builder in which one of the columns is an hyperlink. I see a lot of posts that relates to the hyperlink as granted but i can't find any option in the report builder that will allow me such a thing. Any clues?
Thank you,
Ken
I am not a Report Builder expert (the SQL Server Reporting Services forum has them - http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) but from what I know if your column is in the format of a URL it is automatically created as a hyperlink. So if your column has the value http://www.microsoft.com it is created as a hyperlink... otherwise it is not.
If you create your report using a Report Server Project (Business Intelligence Projects -> Report Server Project from Visual Studio) you can independently set the Display Value and the Hyperlink Action for a table column.
On a report with a table
Under Properties (right click in table cell -> Properties)
Under the General Tab
Set the Value to the value you would like displayed on the Report (i.e. =Fields!FieldID.Value).
Under the Navigation Tab
Under "Hyperlink action:" select "Jump to URL:" and set its value (i.e. =Parameters!URL.Value + Fields.FieldID.Value)
It may be possible to do this in Report Builder - I am not sure. Please post this question to SQL Server Reporting Services if you would not like to create a Report Server Project.
