Have to Refresh Window for accurate data

[gjw1211]

Hello,

 

I've created a new report in my database and have been having a problem. The script to run the report first asks for a date range, then performs a find using the date range, and then goes to the report layout to display the results.

 

The report runs fine and shows the correct data if it's the first time I run the script after opening the db. However, if I run it again and enter a different date range, the some of the data on the report is incorrect. If I leave the layout and then navigate back to it, then the correct data shows, or if I choose Refresh Window from the Records menu, the correct data will show, but adding the Refresh Window step to the script does not make it work.

 

Any ideas on how to correct this problem? Thanks for any help.

 

-Greg

[aaa]

Hi diwl211.

Try in script:

Minimiz window

Restore window.

Or try

Close

Open

Will be better if you attach here your file(the little part of it)

[Maarten Witberg]

or try the script step

 

refresh window [ flush cached join results ]

[gjw1211]

Flushing the cached join results works perfectly, thank you both for your help.