What you want to do is at the end of the program, put in a PRINT command and send your data to a file.
Then after the PRINT command, add your script. Your SCRIPT should first find the file by using the dir *.pdf command. The latest file name is last in the list. Then parse the file name using the LEFT and RIGHT commands and you will be able to zoom into the correct index value. Then load this index value into a variable. Then refresh the report and voila, you got what you want.
I do something similar, but it was awful. Lots and lots of VB programming. It works now but I have 6 or 7 different programs involved to do this all righht. It also all depends on your directory structure etc etc etc.
Good luck, you'll need all the luck you can get to pull this one off....
What you want to do is at the end of the program, put in a PRINT command and send your data to a file.
Then after the PRINT command, add your script. Your SCRIPT should first find the file by using the dir *.pdf command. The latest file name is last in the list. Then parse the file name using the LEFT and RIGHT commands and you will be able to zoom into the correct index value. Then load this index value into a variable. Then refresh the report and voila, you got what you want.
I do something similar, but it was awful. Lots and lots of VB programming. It works now but I have 6 or 7 different programs involved to do this all righht. It also all depends on your directory structure etc etc etc.
Good luck, you'll need all the luck you can get to pull this one off....