This post will be a little long, but I figure the more detailed my description, the better chance someone will be able to assist.
I have created two tasks which work in concert together. The first task goes into our company report generating system and orders 7 reports. Then the 2nd task is to go back into the reporting system and download the reports which have generated using a javascript command. This has been working very well after working all of the idiosyncrasies involved with our particular web reporting system, however, this a.m. I ran into a problem that I am at a complete loss on how to correct.
At the completion of the report request a report token ID is generated and once the report has completed, it is available for download by the report token ID. In the first process I gather the report token ID's generated and hold those values in an Access database for use when the reports are available for download. I then use the database connection to provide the parameter for the link. I was having issues with the interface between AA and our reporting system when I attempted to have it loop through a single query to provide the parameters, so I changed the code to include a query with a single record for each occurrence of the report that I wanted to have downloaded. These are named D1 - D7.
This a.m., the AA task downloaded the first report instance it came to, token ID TER412_GARDNLI_2910427, which is the token ID found in D4, not D1 and then jumped down to the bottom of the page and downloaded 6 copies of token ID TER412_GARDNLI_2901411 (which was ordered and downloaded successfully 2 days ago) which is not contained as a value in queries D1 - D7.
I have attached the entire contents of the 2nd task as TER412Download.txt and the lines which are proving the problem are 9-24. I am at a loss as to why it is downloading a report that is not one of the parameters passed through. I double checked by using the Message box function to ensure that the correct parameters were being passed. A sample (from query D1) of the value being passed to the reporting system is: javascript:download('TER412_GARDNLI_2910433.zip',' EQP1A','file:///c:/fts/TER412_GARDNLI_2910433')
Any assistance/suggestions would be greatly appreciated.
Last edited by gardnli; 08-08-2007 at 01:02 PM.
Reason: The attachments were not visible
I found the issue after noting that the download sequence of the reports was consistenly following the pattern of 1st instance of the report name, 2nd instance etc. In looking at the properties of the web recorder statement, I found that under the advanced button, the only option selected for the find function was that of Name. I put a check mark in the URL box and it now finds the specific report in the correct order for download.