topic Reading image as binary from SQL in QlikView

Reading image as binary from SQL

Mon, 04 Oct 2010 15:45:27 GMT

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!

Reading image as binary from SQL

Tue, 05 Oct 2010 23:42:54 GMT

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

Reading image as binary from SQL

Wed, 06 Oct 2010 08:35:59 GMT

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.

Reading image as binary from SQL

lucarizziero — Fri, 03 Dec 2010 13:33:15 GMT

Hi Helen,

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

Thanks

Luca