Run a Predefined Excel Query from Query Viewer

Run a Predefined Excel Query from Query Viewer

In this topic you will learn how to Run a Predefined Query from Query Viewer.

Queries can also be run directly to Excel from the Query Viewer Search page.

Enter the SetID "SHARE".

Running the query directly to Excel allows you to manipulate the results. You may perform any function or features available in Excel. You are also able to Save your results to a folder.

Run a Predefined Excel Query from Query Viewer

This completes View a Predefined Excel Query from Query Viewer.

Enter the SetID "SHARE".

Click the APY3001_AP_VENDOR_SUMMARY Excel link.

Enter the desired information into the SetID field. Enter

a valid value

e.g.

"SHARE"

.

Click the button to the right of the Supplier Status field.

Click the Approved list item.

Click the View Results button.

Click the Open button.

Click the Close Report button.

Click the Close Window button.

DPIINFODIV

Run a Predefined Excel Query from Query Viewer

;

Frame ID: