Reading image as binary from SQL

[#1]

Hi all,

I have a problem when I'm trying to convert a binary into image. I have a database field (photo) which contains binary data type and I want to convert this into image. The database is SQL and the Qlikview version is 9 SR3.

When I'm trying to do this by using the Info Load (in this way):

Pictures:

INFO LOAD ID, Photo;
SELECT ID, Photo
FROM sqlTable1;

The only field that displayed in Available Fields to the layout is the ID.

Any idea or suggestion is accepted.

Thank you!

[#2]

Hi eleni_theo,

You won't see the field Photo anywhere as you have loaded this as an information field linked to the ID field.

To view the Photo field you need to do something like the following:

- Add a listbox for the ID field to your report

- Right click the field and select Properties

- Check the box on the General tab called Show Info Automatically

-Click OK

Now when you select a single value from your ID list you will see an 'i' icon appear in the caption for the field. Click on the 'i' and you should see the picture.

Alternatively create a text box object and add the formula =INFO(ID) and make sure the Representation field is set to image. This will show the image when a single field is selected in the ID list.

Hope this helps.

Rod

[#3]

Dear Rob,

Thank you for your reply.

I'll try this solution and I will let you know about the results.

Thanks for you help

Regards,

Helen.

[lucarizziero]

Hi Helen,

I have the same question: did you find the solution for show an image stored in a SQLServer table ?

Thanks

Luca