473,385 Members | 1,958 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Reporting Server - What are the caveats with hyperlinks in fields?

I'm trying to use a LocalReport in a ReportViewer and make a couple fields
in the report show up as hyperlinks so I can navigate to other pages after
running the report. The hyperlinks themselves are not showing up at all
unless I use something simple like, http://www.msnbc.com. When I use
something more complicated like a relative path with a querystring, they
just simply don't appear as hyperlinks at all, just flat text.

Here's an example of the link I'm trying to use. The querystring values are
concatenated in an expression on the field.
http://localhost:1314/CarDashboard/P...omerID=1235456

If a relative path would work it would look something like this:
.../../Pages/CRM/CustomerDashboard.aspx?GlobalCustomerID=12354566

Any ideas?

Thanks in advance.
-Nathan


Sep 21 '07 #1
2 2622
To add to this, I also have inspected the rendered html from this report and
when it does work it generates this:
<td class="a115">
<div class="r11">
<a target="_top" style="text-decoration: none; color: Black;"
href="http://www.msnbc.com/">firstname lastname</a>
</div>
</td>

The navigation expression is actually this:
="http://www.msnbc.com"

I also found that it only renders the anchor if i'm using a fully qualified
url and not just a relative path. The error I was having before was caused
by not using .ToString() on my int value in the querystring and also that I
was using a relative path.

In a perfect world, I'd like to be able to change the target frame or remove
it completely so it uses the current frame. I would also like it to use a
relative path, but that's something I can just work around.

ideas?

Thanks,
Nathan

"Nathan" <na*****@vinsolutions.comwrote in message
news:Ow**************@TK2MSFTNGP02.phx.gbl...
I'm trying to use a LocalReport in a ReportViewer and make a couple fields
in the report show up as hyperlinks so I can navigate to other pages after
running the report. The hyperlinks themselves are not showing up at all
unless I use something simple like, http://www.msnbc.com. When I use
something more complicated like a relative path with a querystring, they
just simply don't appear as hyperlinks at all, just flat text.

Here's an example of the link I'm trying to use. The querystring values
are concatenated in an expression on the field.
http://localhost:1314/CarDashboard/P...omerID=1235456

If a relative path would work it would look something like this:
../../Pages/CRM/CustomerDashboard.aspx?GlobalCustomerID=12354566

Any ideas?

Thanks in advance.
-Nathan


Sep 21 '07 #2
I answered my own question. But hopefully someone can find this useful.

I solved all of this by using a Bookmark. I defined a bookmark navigation
link to be the customer id. Then on the page containing the ReportViewer, I
subscribed to the ReportViewer.BookmarkNavigation event. Inside the handler,
I cancelled the bookmark navigation and then parsed the id form the bookmark
id and used that in a redirect to the page I wanted. This succesfully used
the same frame I was in and allowed me to use relative urls. It also allowed
my PDF output docs to remove the links from the bookmarks. It gave me the
best of all worlds, but it's a little kluge.

Nathan

"Nathan" <na*****@vinsolutions.comwrote in message
news:Ol**************@TK2MSFTNGP04.phx.gbl...
To add to this, I also have inspected the rendered html from this report
and when it does work it generates this:
<td class="a115">
<div class="r11">
<a target="_top" style="text-decoration: none; color: Black;"
href="http://www.msnbc.com/">firstname lastname</a>
</div>
</td>

The navigation expression is actually this:
="http://www.msnbc.com"

I also found that it only renders the anchor if i'm using a fully
qualified url and not just a relative path. The error I was having before
was caused by not using .ToString() on my int value in the querystring and
also that I was using a relative path.

In a perfect world, I'd like to be able to change the target frame or
remove it completely so it uses the current frame. I would also like it to
use a relative path, but that's something I can just work around.

ideas?

Thanks,
Nathan

"Nathan" <na*****@vinsolutions.comwrote in message
news:Ow**************@TK2MSFTNGP02.phx.gbl...
>I'm trying to use a LocalReport in a ReportViewer and make a couple
fields in the report show up as hyperlinks so I can navigate to other
pages after running the report. The hyperlinks themselves are not showing
up at all unless I use something simple like, http://www.msnbc.com. When
I use something more complicated like a relative path with a querystring,
they just simply don't appear as hyperlinks at all, just flat text.

Here's an example of the link I'm trying to use. The querystring values
are concatenated in an expression on the field.
http://localhost:1314/CarDashboard/P...omerID=1235456

If a relative path would work it would look something like this:
../../Pages/CRM/CustomerDashboard.aspx?GlobalCustomerID=12354566

Any ideas?

Thanks in advance.
-Nathan



Sep 21 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: William Cleveland | last post by:
I'm working on a system right now where I have a database (two, actually, but one is discarded halfway through), but it's created and used as part of a process (reporting), rather than as the...
2
by: Steve Miller | last post by:
hello... i am a 'user' of access, meaning, i import excel files, join, and merge....that's about the extent of my expertise with ms-access. my boss wants me to create an access application that...
0
by: Tim | last post by:
Access 97: I have a table with a hyperlink field that I display on a form. I can click on the form field and the hyperlink activates correctly. However, if I try to activate the hyperlink using VB...
1
by: Ethem Azun | last post by:
Hi, I'm looking for an excel reporting solution to use in my ASP.NET application. I don't want to use Crystal Reports (too poor for excel reporting) and Reporting Services has requirements that...
8
by: Brendan Reynolds | last post by:
I'm trying to integrate SQL Server Reporting Services reports into an ASP.NET app (SRS 2000, ASP.NET 1.1). I know how to do this using direct URL addressing, but this exposes in the query string...
8
by: Woody Splawn | last post by:
I am asking this question here because I asked this question in the Reporting Services Newsgroup and did not get an answer. Does anyone know if Reporting Services is intended to work in a...
0
by: rmk | last post by:
How can I get the 2000 and 2005 versions of SQL Server Reporting Services both working on my development laptop ????? I have ASP.NET 1.1 and 2.0 installed on my laptop. I have Visual Studio...
1
by: Janna | last post by:
Hello tech savvy gurus! I hope someone can help me! THE PROBLEM: "Cannot open specified file" when I click on a hyperlink in an Access database when it is located on our server. THE...
7
by: TG | last post by:
hi! I am trying to create a sql server table from an excel sheet. Here is the code I have: 'This procedure the xlsx file and dumps it to a table in SQL Server
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.