My company uses VB6, Crystal Report8.5, MS SQL Server as development tools. I can't insert the photo files into MS SQL server because of company policy. Now, I would like to display the photo in Crystal Report by these string field in a table.
Table structure like the following sample.
create table PhotoTable
PhotoField varchar(50) null
Here is its data.
There is a directory to place all photos files.
SQL statement is
"Select KeyField, PhotoField from PhotoTable"
I want to display some selected photos in detail section.
I find that there is no way to convert string field into a photo.
I can't use OLE because it set the file name during design time.
I can't use blob field because it is company policy.
Is there anyone help?