Showing posts with label driven. Show all posts
Showing posts with label driven. Show all posts

Sunday, March 25, 2012

Attach additional files to data driven report

Is it possible to attach a file to a data driven report?
Thanks,
TimI don't believe you can do that. However, you can have a varbinary field
within a table on your MSSQL server, and create a small ASP page that will
return that file. Then all you need is a hyperlink on your report that will
point to that ASP page. I wouldn't recommend it for large files however. I
read somewhere that you shouldn't store anything larger than 256kb in a
varbinary field. MSSQL 2008 will address this issue with the filestream data
type.
If you need the C# code example for the ASP page, I can post it here. I got
it from someone on the ASP NG.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Tim Kelley" <tkelley@.company.com> wrote in message
news:%23mvZVXalIHA.2304@.TK2MSFTNGP05.phx.gbl...
> Is it possible to attach a file to a data driven report?
> Thanks,
> Tim
>