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.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.
"Bucky" wrote:
> 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.
>
Wednesday, March 7, 2012
pass pathname dynamically for hyperlink
Labels:
database,
dynamically,
environment,
hyperlink,
microsoft,
mysql,
oracle,
pathname,
plug,
production,
server,
servername,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment