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, 2012 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, 2012 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, 2012 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, 2012 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, 2012 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, 2012 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, 2012 at 07:17 AM

Kev Riley gravatar image

Kev Riley ♦♦
54.3k 47 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, 2012 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.

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:

x560
x29
x18
x1

asked: Jun 15, 2012 at 05:57 AM

Seen: 1462 times

Last Updated: Jun 22, 2012 at 10:47 AM