mibuso.com
Home› SQL General

How to Show Navision Item Card image in Reporting Services?

offshootoffshoot 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

  • kinekine 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.
  • offshootoffshoot 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...
  • garakgarak 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!
  • offshootoffshoot 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
  • offshootoffshoot 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
Sign In or Register to comment.