People's face with Data Graphic?

[marcoadf]

Hi there.
Is it possible to have a Data Graphic based on SQL Server or excel file with a image field?

Today I have a DataGraphic to show organigram of a company. Now I would like to add people's face to the hierarquie. I have had a field of type image and tried to load it to Visio, but it comes out with strange characters.

Is this possible to accomplish?

Thanks in advance.

[JohnGoldsmith]

If you're storing your image as binary then (as far as I'm aware) you'd need to stream it back out to a file in order for it to be consumed by Visio.  If the db field is just a path then you can use that directly with the Org Chart addon as per this post:

http://visualsignals.typepad.co.uk/vislog/2008/06/linking-org-chart-images.html

If your issue is the former then you might find these links helpful:

http://www.codeproject.com/Articles/21208/Store-or-Save-images-in-SQL-Server

http://stackoverflow.com/a/5613926/683606

Hope that helps.

Best regards

John