SSRS open file instead of url within a report

Question

Post reply

SSRS open file instead of url within a report

Sherri Barkley

SSCrazy

Points: 2269
More actions
August 19, 2009 at 1:25 pm

#214013

I have a SSRS report that displays one field that contains a filename. I have been asked if it is possible to have a user click on that filename within the SSRS report and have it launch the text file? I have looked through a couple of SSRS books and Google searched and I haven't come up with anything yet. So if you know a way to make this happen, I would greatly appreciate it.
Thanks
Sherri

Viewing 9 posts - 1 through 8 (of 8 total)

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

WilliamBendall SSCrazy Points: 2591 More actions · Answer 1

Ok, I dragged a textbox onto one of my existing reports and captured "C:\MyFile.txt" in it.

Then I created the file itself on my C:. In the file I put "asdf" and saved it.

I then went into the properties of the textbox itself and next to the Action setting I clicked on the ellipses.

This opens up a window that asks you what action you want to do.

I ticked, "Jump to URL" and inside the textbox typed in ="C:\myFile.txt".

I then uploaded the report to our dev website. When I clicked on the link nothing happened.

But I was able to right click and "save target as...".

I saved the target file to my desktop, and when I opened it it had "asdf" in it.

So, I know it's linking to the right file, I just don't know why I wasn't able to open it in my browser. Maybe someone can help us with that? 🙂

----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

Sherri Barkley SSCrazy Points: 2269 More actions · Answer 2

Thanks for giving it a shot. Hopefully someone else has made it work and can give steps for the rest of us.

Thanks again for taking the time to try to figure it out.

Marianne L Collins SSCommitted Points: 1895 More actions · Answer 3

Check out the response from DevDells on Sep 19, 2008 from here: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/43385efd-b4ff-41ef-b24b-da911c155936

Basically, you need to create a share with the folder where your file will reside, and your Jump to URL will be in the following format:

http://ServerName/share/filename.txt

To create the share, right-click the folder name and go to the properties. Make sure you enable Web Sharing, as well.

Hope that helps.

-Marianne

Sherri Barkley SSCrazy Points: 2269 More actions · Answer 4

Sherri Barkley

SSCrazy

Points: 2269

August 20, 2009 at 3:04 pm

#1042455

Thanks Marianne, I will give that a try.

nirav351-1119077 Old Hand Points: 338 More actions · Answer 5

Hi,

I have same Exact Requirment like you in SSRS 2005.

Did you got any solution ?

Pls let me know.

Thanks.

Amit Raut SSCrazy Points: 2613 More actions · Answer 6

Hi,

I too have a similar requirement but it seems that it's not feasible.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/43385efd-b4ff-41ef-b24b-da911c155936/displaying-a-word-document-via-reporting-services?forum=sqlreportingservices

Amit Raut SSCrazy Points: 2613 More actions · Answer 7

Creating an hyperlink (Navigation - Jump to URL) for a pdf file worked for me. Below is the expression I used:

="file:\\fileserver\plant\Certificates\ICR_AER0190_01.pdf"

jvanderlouw-960980 SSC Eights! Points: 827 More actions · Answer 8

I want to open a text file in Notepad/Worpad itself. However the hyperlink in 'Go to URL' opens the content of the textfile in a seperate sheet. The goal is to open the text file and be able to edit it.

Is this possible?