x

Need to show .wav file has a hyperlink in the SSRS 2005

Hi, I have a simple report ( in SSRS 2005) with a tablix control with a few fields (textboxes).In one field i need to show (.wav file) has a link to the file location.(The file path would be something like this:(\\11.12.11.53\abc\2012061511111.wav) I tried in few ways but it doesn't working.

Can any one please suggest me need ASAP.Thanks in advance!.
more ▼

asked Jun 15 '12 at 05:57 AM in Default

Neha.sql gravatar image

Neha.sql
0 2 2 2

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
Just in case if you are not able to work with the above suggestion, another way is to share your folder through WEB/IIS. Once you correctly shared it with correct permissions, then you can access it through normal http hyperlink. Rest of the procedure is the same as mentioned in the above suggestion. Only need to use http:// instead of file://.
more ▼

answered Jun 15 '12 at 01:51 PM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

Hi,

Actually yesterday only i tried as Riley said,its not working.But Thanks a lot Riley.

Usman: What kind of permissions do we need, to access the folder through a report. Actually .wav file is stored on the server.

Thanks in advance.
Jun 15 '12 at 02:31 PM Neha.sql
I guess you should seek help from the best person i.e. your system administrator. I am saying so because based upon the authentication i.e. NTLM/KERBEROS/BASIC authentication, you would access the folder and files.
Jun 15 '12 at 02:58 PM Usman Butt
@Usman :Thank you so much :),but right now our client don't want to implement this task why i don't no.
Jun 19 '12 at 11:50 PM Neha.sql

@Neha.sql Happy to know that it helped. BTW, all this web sharing may not be needed if you move the files to the Reporting folders (Already shared). Hence, the permission inheritance would ease the job and the client should agree to implement it.

Last but not least, if the above was the solution to problem then please tick/mark the answer as accepted. It would increase your karma points and it would also help the future users. Thanks.
Jun 20 '12 at 09:24 AM Usman Butt
(comments are locked)
10|1200 characters needed characters left
Right click the field, choose Properties
Go to Navigation
Enable Jump to URL
In the URL box type : file://11.12.11.53/abc/2012061511111.wav
more ▼

answered Jun 15 '12 at 07:17 AM

Kev Riley gravatar image

Kev Riley ♦♦
50.7k 43 49 76

Just tried this on my test (albeit SSRS 2008R2) instance. The file://computername/temp/ding.wav worked and the wav played. Just make sure the account that is running SSRS has access to that file location.
Jun 22 '12 at 10:47 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x535
x28
x17
x1

asked: Jun 15 '12 at 05:57 AM

Seen: 1185 times

Last Updated: Jun 22 '12 at 10:47 AM