Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Is it possible to launch code or an app from field

Author  Topic 

harlingtonthewizard
Constraint Violating Yak Guru

352 Posts

Posted - 2008-10-16 : 02:20:14
If a report returns some data is there a mechanism that can be used so if the user clicks on a field it will pass data to an application and launch the application? The scenario here is that the report can return the required data from a database. The data is Meta data for a video clip so when a user clicks on a field in a row I wish to fire up an application that can play the video. The data passed to the app would be the path and file name for the video file external to the database.
Ie. Can a field display data and be a button to launch an app or code?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-16 : 03:10:18
try if you can use javascript function for that. then call that javascript function from navigation pane->>jump to url option.
Go to Top of Page

harlingtonthewizard
Constraint Violating Yak Guru

352 Posts

Posted - 2008-10-16 : 05:11:56
Well as a test I used a default web page under IIS and set navigation to:
="http://localhost/Images/" & Fields!FileName.Value
Added a few mpg and jpg files and set the details in a db table.
It launches mpg files in Windows Media Player and JPG in Internet Explorer, I also displayed jpg in an image item on the report directly. Good start with no extra code:)
Thanks visakh16 for the pointer.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-18 : 02:17:29
quote:
Originally posted by harlingtonthewizard

Well as a test I used a default web page under IIS and set navigation to:
="http://localhost/Images/" & Fields!FileName.Value
Added a few mpg and jpg files and set the details in a db table.
It launches mpg files in Windows Media Player and JPG in Internet Explorer, I also displayed jpg in an image item on the report directly. Good start with no extra code:)
Thanks visakh16 for the pointer.


welcome
would be glad to know how you got on with this
Go to Top of Page
   

- Advertisement -