I am testing out a report that will pull images dynamically from graphic files located in the folder. Below is my test formula.
if {IV00101.ITEMNMBR}="pump-10000" then "G:\Pictures\temp\pump-10000.bmp" else
if {IV00101.ITEMNMBR}="pump-10004" then "G:\Pictures\temp\pump-10004.bmp"
This works fine, but would be very long & tedious if I had a lot of numbers. How do you convert this to a dynamic formula so it can essentially link the ITEMNMBR to the physical file name? Somehow it needs to pass the itemnumber into the path statement.
Thank you.
Edited by danielboone - 15 Feb 2012 at 8:54am
IP Logged
