April 11, 2011 at 10:38 am
I have a sales table with a field of image datatype, which will contain a document in either PDF, DOC or XLS format
I need to show on the report for each sales order as well as normal details, the pdf/doc/xls document
I guess the best way is to insert an image and set it to database rather than embedded, then when you click it, it will open the document in its own window.
However this seems to be tricky, as normally with jpg's you see the image in the row, but in this case i need an action to open the document (doc/xls/pdf).
Any ideas?
Thanks in advance.
April 11, 2011 at 6:50 pm
Do an SSIS project to extract each "image" on a schedule from the database into the web server file system; then on the report link to that address so when they click it, it will open in whatever installed program on the client machine.
Totally insecure, but it's the only way I could think of.
April 13, 2011 at 7:50 am
Thanks for the reply, but I don't think it will be practical as there are 1/2 million documents but thanks anyway.
April 13, 2011 at 8:17 am
The alternative is still to use a link; but the link specifies the document name as a parameter to an aspx component on a web server, which retrieves the file blob from the database and sends it as the proper MIME type so that an app on the client will recognise and open it ...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply