I'm opening a CR8 report from VB6 using the automated server. In the report is a formula that calls a User defined VB6 DLL. The DLL formats a datetime stamp and executes a stored procedure to load a table with user specific data.
The problem is as follows:
When the report is executed manually the stored procedure returns a set of data with one time stamp but when the report is 'called' from the VB6 frontend the report returns two sets of data with two time stamps. This indicates that the formula in the report is being executed twice.
To further back this result, the time stamp difference is always 1 minute and 12 seconds. Also, the report uses the second set of data with the later time stamp.
The problem is as follows:
When the report is executed manually the stored procedure returns a set of data with one time stamp but when the report is 'called' from the VB6 frontend the report returns two sets of data with two time stamps. This indicates that the formula in the report is being executed twice.
To further back this result, the time stamp difference is always 1 minute and 12 seconds. Also, the report uses the second set of data with the later time stamp.