pass pathname dynamically for hyperlink -- sql server reporting services

Bucky
1/30/2005 5:46:13 PM

I need to get the pathname dynamically to plug into a hyperlink since
the servername will change between development to production
environment.

Here is an example of the desired link:
http://servername/webapp/page.aspx?id=123

Here is how I would like to set the Jump to URL field:
Jump to URL = pathname & "page.aspx?id=" Fields!id.Value

where pathname = "http://servername/webapp/"

The question is, how can I pass the pathname from .NET codebehind to
SQL RS? It's stored in the web.config.

Rajan
1/30/2005 10:51:04 PM

You can use report parameters for doing this. Add a report parameter to your
report. Then refer the report parameter in your jump to url option as

=Parameters!WebServerPath.Value + "?Id=" + Trim( Fields!ID.Value)

Where "WebServerPath" is ur report parameter and "Id" is your row value
which u want to pass it to the new page.

Hope this helps.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : pass pathname dynamically for hyperlink