4 Replies Latest reply: Apr 12, 2012 10:11 AM by Dominique Jacques-Brissette RSS

Using BLOB images (from MS Access OLE objects)

Dominique Jacques-Brissette

I have a table named Program and its fields are :
- Name_Program (the primary key)

- a field that hold some numeric value (unrelated to my problem)
- Image_Program (contains an image of the program and the program's name appears on the image)

 

I have made a pivot table which looks like this :

pivot.PNG

I would like to know if it's possible to use the Image instead of the Name?
I tried but it gives me the String interpretation of the image file... even when I set the properties of that dimension to represent as an image...

pivot.PNG
Is there any way I can make the image display?

 

I've read about the BUNDLE and INFO statements in the script but still haven't made it work

  • Re: Using BLOB images (from MS Access OLE objects)
    Dipesh Patel

    Have you tried setting the field to display as image? On the Presentation tab set the field from test to Info as Image... The only solutions I've seen of this are from a SQL db not Access so not sure

    • Re: Using BLOB images (from MS Access OLE objects)
      Dipesh Patel

      I've found this for you in the help:

       

      Info

      If a piece of external information, such as a text file, a picture or a multimedia presentation is to be connected to a field value, this is done in a table that is loaded through an info prefix. (In some cases it will be preferable to store the information inside the .qvw file, by using the bundle prefix.) The table must contain two columns only, the first one with the field values that will form the keys to the information, the second one containing the file names of the pictures etcetera. 

      The same applies to, for example, a picture from a database management system. On a binary field, a blob, the info select statement makes an implicit bundle, i.e. the binary data will be fetched immediately and stored in the qvw. The binary data must be the second field in a select statement.

      The syntax is:

      info ( loadstatement | selectstatement )

      Examples:

      Info Load * from flagoecd.csv;

      Info Select * from infotable;

      Info Select Key, Picture From infotable;