Report Refresh & RefreshSilent

[Simon_Aldworth]

Hello,

Can someone clarify the exact purpose of the Refresh method for Report and the difference between Refresh and RefreshSilent please? In particular, I'd like to know what they're supposed to do when the Report window is active.

I would like to have the equivalent of the VBA Application.ScreenUpdating and set it to false whilst my script is running. However, in the absence of that I'm trying different alternatives.

One idea was to load a new (blank) report into the Report window so the user has just a white screen to stare at, and then show them the finished Report file at the end of the script. However, I can't find a way of hiding the subsequent Report loading process and periodic updates that occur throughout the script. The repeated calls to activate certain sheets seems to always be visible to the user providing they're looking at the Report window. I can't avoid using activate for reasons explained in another of my posts.

I have commented out all but the very last call to Refresh the report, but that only makes a very small improvement. Changing each Refresh to RefreshSilent makes no difference. Hence my question above. The only way to avoid seeing updates and calls to activate different report sheets is to avoid looking at the Report window altogether (e.g. show the user the Navigator window instead).

So, is there no way to stare at the Report window AND make any updates invisible to the user until such time as I choose?

Thanks,

Simon.

[Simon_Aldworth]

I forgot to point out that the reason I have periodic calls to refresh the report is that I thought it was necessary to ensure that the axis system parameters where up to date before using code to modify them.

[AnJalpaka]

Hello Simon_Aldworth,

The Refresh command, as the name implies, is there to update the REPORT. If this is not desired, it should not be called. At the end of the script it will certainly be desired, since the changes made should become visible.

Have you tried removing all refresh calls and only calling it at the end of the script?

While a script is running, REPORT is not automatically refreshed.

With the Refresh command, REPORT is brought to the front first and then updated. With RefreshSilent, REPORT is updated first and then brought to the front. If REPORT is already visible, there is probably no difference between these two commands.

[Simon_Aldworth]

Thanks AnJalpaka,

So, just to be clear - there is no need to refresh the report to ensure that the parameters of the axis system are up to date within the programme memory, e.g. axis beginning, end and origin values? In other words, it is used strictly to ensure that the visible representation of the report is updated?

Regards,

Simon.

[AnJalpaka · Accepted solution]

Hi Simon,

For automatic axis scaling it should not be necessary to update the REPORT, right.

It could be that there are exceptions. I would recommend to implement the script without refresh calls and only do a refresh at the end. If you find that a refresh is needed while the script is running, for example before a PDF export of the layout, then add the refresh command.

Regards,

AnJalpaka