Hi,
I am trying to create a report to display 5 images that exist on disk.
I have created a cursor and put the name of each image in a separate record
CREATE CURSOR myGraphs;
(GraphName C(20))
INSERT INTO myGraphs VALUES ("Graph1.jpg")
INSERT INTO myGraphs VALUES ("Graph2.jpg")
INSERT INTO myGraphs VALUES ("Graph3.jpg")
INSERT INTO myGraphs VALUES ("Graph4.jpg")
INSERT INTO myGraphs VALUES ("Graph5.jpg")
On the report I drop an OLE/Picture object in the detail band and set the Controlsource Type to be "Expression or variable name", then set the Control source to myGraphs.Graphname.
The result is the first image (Graph1) printing out 5 times. If I display the content of the field just below the graph the proper file name is displayed.
I know I've done this before, but for the life of me can't remember the trick.
Anybody remember the trick to this?