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

[Dayna]

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

[jvitantonio]

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,

JV

[Dayna]

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

[jvitantonio]

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,

JV