topic Re: Provide a link to a PDF from a Byte Array field in SQL in QlikView

Provide a link to a PDF from a Byte Array field in SQL

Dayna — Tue, 27 May 2014 09:33:58 GMT

Hello All!

I have a SQL table used to store PDF's which is converted to a Byte Array when it's uplpaded - I'd like to provide users a link within a QlikView table to view/download the file. I know it's possible to create links to sites or files within a network share by changing the representation to 'link' within a straight table.

Could anyone advise how to provide a link to the PDF? I've attached the byte array that's outputed when I load from the SQL table in QlikView..

Kind Regards,

Dayna

Re: Provide a link to a PDF from a Byte Array field in SQL

jvitantonio — Tue, 27 May 2014 10:00:02 GMT

Hi Dayna,

You will need to first convert everything to PDF using a store procedure, put all the files in a place that can be access by the users, and ten link to this folter like 'C:\MyFolder\PDF1.pdf'.

Thanks,

Re: Provide a link to a PDF from a Byte Array field in SQL

Dayna — Tue, 27 May 2014 10:02:11 GMT

JV,

Many thanks for your quick response, could you point me in the right direction to how QlikView could read the stored procedure? Apologies, I've never used them in QlikView before.

Kind Regards,

Dayna

Re: Provide a link to a PDF from a Byte Array field in SQL

jvitantonio — Tue, 27 May 2014 10:24:39 GMT

Hi Dayna,

You can do this in a separate process in your DB. You can run the store procedure and then link to those files from Qlikview.

You can also run the procedure from Qlikview load script using the Execute syntax. You can look this up in the help.

Thanks,