Sunday, February 19, 2012

Creatiing a link to download an attachment

I have a database where one of the fields is a large binary object. I would
like to create a report where one of the columns shows a link to the
"attachment". When the user clicks on the link, they should be able to
download the raw binary data (with the mime type of my choosing). Can this
be done?
Thanks,
SteveYou would need to put a URL into the table cell as a hyperlink and then on
your web server, process that URL by obtaining the attachment from the
database and returning it. There is no native support for this in Reporting
Services.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Stephen Walch" <swalch@.proposion.com> wrote in message
news:%23WNOOaQkEHA.644@.tk2msftngp13.phx.gbl...
> I have a database where one of the fields is a large binary object. I
would
> like to create a report where one of the columns shows a link to the
> "attachment". When the user clicks on the link, they should be able to
> download the raw binary data (with the mime type of my choosing). Can
this
> be done?
> Thanks,
> Steve
>
>

No comments:

Post a Comment