I have a report that shows product category codes in one of the columns. I would like to be able to click on one of these and have it be a link to a web page that displays information about the product category, passing the code as a querystring parameter to the destination web page. The destination is not another report, but a bona-fide web page.

I have tried going to the properties form for the field, then clicking the Advanced button, then the Navigation tab. I check the Jump to URL radio button and try inputting the desired URL, but haven't had any luck passing the field as a querystring parameter.

Here is the URL I am entering into the textbox:

http://lbwl/Products/ProdCat.aspx?Id=Fields!ProductCategory.Value

Unfortunately, what gets passed as the querystring parameter value is not the value of the product category, but "Fields!ProductCategory.Value" Is there any way to do what I'm trying to do?

Here are two example that I use to hyperlink between reports:

When passing the URL you can pass in two globals that resolve to the Report Server you are using (Globals!ReportServerUrl) and the Report Folder that is the current Project that you are working with (Globals!ReportFolder).

So if the report you want to link to is in the same project as the report that you are currently viewing you can use this method. If the report you are calling is outside the current project folder use the method below the first example.

Either method you use you wil then need to supply the Report name itself. In this case it is "Sales Summary Report - UK". After the name of the report come the configuration parameters and actual report parameters:
Show Parameters = false
Parameter startdate = Fields!date_value.value - take the value of the field date_value from the current row.
Parameter enddate = Fields!date_value.Value - same as above.
Parameter countryiden = Fields!country_iden_fk.value - same as above.

So that's it in a nutshell. Here is the URL I put in the Hyperlink properties:

=CStr(Globals!ReportServerUrl) + "?" + CStr(Globals!ReportFolder) + "/Sales Summary Report - UK&rs:Command=Render&rc:parameters=false&rs:Comman d=Render&startdate= " + CStr( Fields!date_value.Value ) + "&rs:Command=Render&enddate= " + CStr( Fields!date_value.Value ) + "&rs:Command=Render&countryiden= " + CStr( Fields!country_iden_fk.Value )
Customer Event Details - UK (PC)

Below is another example where I pass in actual value for a report that is not in the current report project directory.

=CStr(Globals!ReportServerUrl) & "?" & "/SalesDetailReport" & "/Raw Sales Summary Report - UK&rs:Command=Render&rc:parameters=false&rs:Comman d=Render&startdate=2003/10/01&rs:Command=Render&enddate=" & format( Parameters!end_date.Value, "d") & "&rs:Command=Render&countryiden=" & CStr( Parameters!country_iden_fk.Value ) & "&rs:Command=Render&customer_iden_fk=" & CStr(Fields!InternationalID.Value)

Let me know if I can help further.

This worked for me, I hardcoded the URL and added the field value to the end:

example:

="http://www.anyurlhere.com" + CStr( Fields!BG_BUG_ID.Value )

Hope this helps. deeman