How to Show Navision Item Card image in Reporting Services?

offshoot
offshoot Member Posts: 21
edited 2008-08-25 in SQL General
Hi,

I am trying to build a report that also includes Picture field of an item. But i am unable to display it in Reporting Services?

Has anyone experienced a situation like that before?

Whenever i tried to add an (Database) image in the report, I simply get only the N/A placeholder instead of image...

Any help appreciated...

Thanks and best regards
Onur

Comments

  • kine
    kine Member Posts: 12,562
    The BLOB fields in NAV are compressed by default. You need to disable the compression on the field to have access from outside to the stored bitmap...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • offshoot
    offshoot Member Posts: 21
    Hi Kine,

    Thank you for that valuable hint :) I might have been searching it for ages :)

    One last Q: How should i disable the compression? (I've looked at Item Card --> Picture fields properties but havent seen a property like "Compression")

    Is it handled in another place?

    Best Regards and Thanks so much.

    kine wrote:
    The BLOB fields in NAV are compressed by default. You need to disable the compression on the field to have access from outside to the stored bitmap...
  • garak
    garak Member Posts: 3,263
    Take a look into the tabledesign -> Field Picture -> Property "Compressed".

    But i'm not sure, if you disable the compress property, that NAV shows the bmp pictures in NAV PictureBoxes.

    So, if this is so, create a new field for SQL Reporting Service (Compressed = false). And ever when you import a Picture into field Picture, u fill also the new Field "SQL Picture".

    If this is not so (or you doesn't show pictures in NAV), you dosn't need a new field.

    Regards
    Do you make it right, it works too!
  • offshoot
    offshoot Member Posts: 21
    Hi,

    Well, I will check as sson as possible. (The previous attempt to look up compressed property in Item Table, I was mistaken. Becuase Compressed Property is only visible in SQL Server Option - But unfortunately i found myself seeking for it in Native local copy :))))

    Best Regards

    Onur
    garak wrote:
    Take a look into the tabledesign -> Field Picture -> Property "Compressed".

    But i'm not sure, if you disable the compress property, that NAV shows the bmp pictures in NAV PictureBoxes.

    So, if this is so, create a new field for SQL Reporting Service (Compressed = false). And ever when you import a Picture into field Picture, u fill also the new Field "SQL Picture".

    If this is not so (or you doesn't show pictures in NAV), you dosn't need a new field.

    Regards
  • offshoot
    offshoot Member Posts: 21
    Hi,

    Thanks for all. It worked.

    Rgds,
    Onur

    offshoot wrote:
    Hi,

    Well, I will check as sson as possible. (The previous attempt to look up compressed property in Item Table, I was mistaken. Becuase Compressed Property is only visible in SQL Server Option - But unfortunately i found myself seeking for it in Native local copy :))))

    Best Regards

    Onur
    garak wrote:
    Take a look into the tabledesign -> Field Picture -> Property "Compressed".

    But i'm not sure, if you disable the compress property, that NAV shows the bmp pictures in NAV PictureBoxes.

    So, if this is so, create a new field for SQL Reporting Service (Compressed = false). And ever when you import a Picture into field Picture, u fill also the new Field "SQL Picture".

    If this is not so (or you doesn't show pictures in NAV), you dosn't need a new field.

    Regards

Categories