COM API - Interact with report window?

Hi,

I am using the COM API with Sage 50 US 2021.

Is there a way to interact with the report window after it is open? Specifically, I am wondering about setting options, choosing columns, and then saving to Excel.

I tried the following code, which opens the "Item List" report. But after that I can't figure if there is a way to interact with the report window.


_app.OpenReport(PeachReportObjects.proItemList);
_app.ExecuteCommand("Options"); // Doesn't do anything
_app.ExecuteCommand("File|Close"); // Doesn't do anything

Thank you,

Chris

Parents Reply Children
No Data