473,800 Members | 2,893 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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/CustomerDashboa rd.aspx?GlobalC ustomerID=12354 566

Any ideas?

Thanks in advance.
-Nathan


Sep 21 '07 #1
2 2649
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*****@vinsol utions.comwrote in message
news:Ow******** ******@TK2MSFTN GP02.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/CustomerDashboa rd.aspx?GlobalC ustomerID=12354 566

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.Bo okmarkNavigatio n 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*****@vinsol utions.comwrote in message
news:Ol******** ******@TK2MSFTN GP04.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*****@vinsol utions.comwrote in message
news:Ow******** ******@TK2MSFTN GP02.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/CustomerDashboa rd.aspx?GlobalC ustomerID=12354 566

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
1439
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 actual production data repository. I may be keeping the database permanantly, but it would be completely read-only; once the process is complete, the database will not change again. This has me wanting to do a few things that are rather foreign to...
2
2160
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 will replace our 'excel' version of time reporting. we use ms-access 2000. i have a huge book (mastering access 2000) though the cd is missing. i looked at using the wizard for time reporting, but is was designed for external clients, and the...
0
466
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 code, the last hyperlink that was clicked is the only one that displays. Background: The database is for providing instruction documentation for shop-floor personnel in a manufacturing environment. The main purpose of the database is to provide...
1
1283
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 the customer is not happy with, so it's not an option either. I definitely don't want to use Excel as a server component. My requirements for excel reporting include formatting, formula fields and using images when necessary.
8
3121
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 parameters that should not be exposed. Each user is associated with a school, and should see only that school's data. When the user logs in, I retrieve the SchoolID associated with that user, and that SchoolID is used as a parameter in all stored...
8
2754
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 client/Server or Local machine environment? Based on what I have seen my guess is yes but that is a guess. In some materal it talks about it running on a web server but my supposition is that this does not necessarily mean that it would not make for a...
0
435
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 2003 and 2005 installed on my laptop. I have my default website configured for ASP.NET 2.0. I have the developer edition of SQL Server 2000 installed on my laptop as
1
3652
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 BACKGROUND: I created a folder "Document Library" on my local drive, which contains document sub-folders and the database. For referential integrity, I designed the database with relative hyperlinks (e.g. Folder\File.pdf). The hyperlinks worked perfectly...
7
12077
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
9690
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9550
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10501
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10250
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10032
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9085
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7574
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5603
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4149
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.