Including Database Fields in URL

[JohnOB]

I am trying to setup a link to a web based mapping system from an SQL Reporting Services Report. I right-click the field and choose Properties, then click the Navigation tab, I click the option "Jump to URL" and am trying all permutation of possibilities for having the URL along with the database fields that I can think of, but no joy. The URL I want is

http://mappingportal/easting&northing&highlight=true

with the words easting and northing being the values from the easting and northing table from the dataset, so that each click will take me to the map for the specific property, because the webbing portal allows the easting and northing of the property to be entered as part of the URL.

Thanks


"Stupid isn't not knowing the answer, it's not asking the question

 

[RiverGuy]

You use expression syntax like anything else. In the box for the URL, click the Fx button to bring up the expression window. Your expression would look something like this:

="[URL unfurl="true"]http://SomeUrl?SomeItem="[/URL] & Fields!SomeItem.Value & "&SomeItem2=" & Fields!SomeItem2.Value