Display images dynamically on report

I am creating a directory report in Crystal 2013 SP 1 and using in SQL Server stored procedure as a data source.  My image files are stored on a folder on the server with a path reference in the table for each record.  The path references are not complete in that the beginning of the url is not present and must be assumed.  (I'm a newbie so there probably a term for this)  the path in the table is like /Portrait/Member/folder/folder//filename.png
I have added an image to my report, chose format graphic | picture | graphic location and have added the field there.  This doesn’t work.  I added a formula and concantante with the rest of the path and then added the formula there.  This didn’t work either.  I just see my original image repeated.
Can anyone help me figure this out?
Thanks mbooher
Michele BooherAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Éric MoreauSenior .Net ConsultantCommented:
are you using a standalone Crystal report or is it through an application?

if you call it through a .net application, you should load your image into a byte array, add it to a dataset and push that dataset to your report. this is shown under "Feeding a custom chart " from http://emoreau.com/Entries/Articles/2006/10/Crystal-Reports--Part-II.aspx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Michele BooherAuthor Commented:
Thank you Eric.  I will study this.
mlmccCommented:
For the format method to work, you will need to include the full path to the image files.

mlmcc
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.