Map hyperlink to c:\ drive or shared drive in ssrs

Question

Post reply

Map hyperlink to c:\ drive or shared drive in ssrs

shravankoneru

SSC-Addicted

Points: 409
More actions
May 13, 2009 at 9:33 pm

#204932

Hello,
Can any one let me know how to map hyperlink to c:\ drive.
When the report is rendered users want to click on it and go to shared drive. How to accomplish this in layout. Please let me know.
Thank You!

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323522 More actions · Answer 1

you'll need to make it a UNC path, like \\ServerName\SharedFolder\Filename.txt or whatever.

you cannot put it on a C:\ drive, it has to be a share since you want other people to get to it.

if you can put it on web server, then it's jsut a standard web address path, http://servername/SubFolder/FileName.txt

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

shravankoneru SSC-Addicted Points: 409 More actions · Answer 2

Thank you for the reply and Where i need to put this UNC. Generally we give www,google.com in Textbox Properties->Navigation->Jump to url but where do i need to give this UNC path in which Hyperlink Action.

Suppose i want to test from my laptop. how do i want to point to c:\drive

Lowell SSC Guru Points: 323522 More actions · Answer 3

it's still just a hyperlink...your computer resolves the path for you.

Some Excelfile on a web server with DNS

Some Excelfile on personal web server by name

Some Excelfile on personal web server

Some Excelfile on dns of hte company

Some Excelfile on my open share i had to create

Some Excelfile on my administrative share

Some Excelfile on my sharethat only I can see

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

shravankoneru SSC-Addicted Points: 409 More actions · Answer 4

Its look great as if i got the solution but when i copy the same and put in the jump to URL tab of table text box . It doesnt jump any where. I coudnt see the cursor changing to hand symbol too for the last code in you reply

and when i include '=' before that it throws error.

This looks very simple but got stuck. Please let me know if you have a better way of doing this.

Lowell SSC Guru Points: 323522 More actions · Answer 5

more details from you before anyone can help; it's all specific to YOUR network.

what is the address of yout SSRS server? are you connecting to a .com address or a machine name address?

a link with C:\myExcelFile.xls would be visible ONLY if you are sitting at the console of the Report Server...if you connect from YOUR laptop TO the server, you cannot see the C:\ drive of the report server.

did you create a share to put files? what is the UNC path to it on your network? did you put any files on the share to link to?

what SPECIFIC data did you put in the link? without that, it's all a guess.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

shravankoneru SSC-Addicted Points: 409 More actions · Answer 6

more details from you before anyone can help; it's all specific to YOUR network.

Yes

what is the address of yout SSRS server? are you connecting to a .com address or a machine name address?

machine name address

a link with C:\myExcelFile.xls would be visible ONLY if you are sitting at the console of the Report Server...if you connect from YOUR laptop TO the server, you cannot see the C:\ drive of the report server.

I connect to server using my laptop

did you create a share to put files? what is the UNC path to it on your network? did you put any files on the share to link to?

Let start with very simple step first. Dont worry about server,UNC at this point. just think you got 2005 installed in you laptop and you created a texbox in your ssrs layout and want to see whether the hyperlink pointed to c drive of laptop works in preview . How do you give href pointed to drive in the jump to URL tab.?

Map hyperlink to c:\ drive or shared drive in ssrs

Cookies on SQLServerCentral