Adding A Lot of Pictures to a Report

[jopav613]

I created a Crystal Report (2016) that shows up to 30,000 items

and I want to display another column that has the pics for those items next to the item#. My pics reside on a directory on the server and are file-named based on the item# .

I need the actual pics to show up on the report, not links to them. Problem is my pics are not in the database, so I can’t just bring over a field that contains them. I'm assuming it would be a long complex process to bring my pics into the Mysql database. Not too mention it would use up another 20gb or more of space if I do it.

I've been looking at some other similar questions but they don't seem to match my issue exactly.

Anyone's help is sincerely appreciated!

[ido_millet]

Set the Graphic Location property expression to the path & name of the image file.

[jopav613]

Ido,

I set the graphic to my server path of the folder, but it displays the same image for each of my 30,000 or so item#s. What am I doing wrong? this is what I typed into the graphic location....

"\\heandb.local\Home-Essentials\Shared\Photos" + {itemsuev31.ITEM} + ".jpg"

[ido_millet]

Show on the report the result of that expression.
Does it match the actual path?
Prime suspect is that you are missing a "\"

[jopav613]

I'll explain from the beginning what I did. I took basically any pic from my local pc and inserted it in the design view in the detail section to the left of the first field, then set its graphic location to "\\heandb.local\Home-Essentials\Shared\Photos" + {itemsuev31.ITEM} + ".jpg"

I changed it to "\\heandb.local\Home-Essentials\Shared\Photos\" + {itemsuev31.ITEM} + ".jpg" but it still just displays the same pic over and over again next to each item# going down 30,000 rows. I must be doing something wrong just don't know what.

[ido_millet]

Show on the report the result of that expression.
Does it match the actual path?

[jopav613]

Ido,

Sorry not understanding. If you're referring to clicking on one of the pictures (all of them showing up as the same image) and opening up it's graphic location they all match "\\heandb.local\Home-Essentials\Shared\Photos\" + {itemsuev31.ITEM} + ".jpg" even though the pic they're displaying is some random pic that I took from my local drive originally, which is NOT in the server //heandb......

[DellSC]

Here's what Ido is suggesting:

1. Create a formula that reads:

"\\heandb.local\Home-Essentials\Shared\Photos\" + {itemsuev31.ITEM} + ".jpg"

2. Place this formula on the report so that you can see what path is being generated and check whether it's valid.

-Dell