Where can I see the queries used to generate reports?

I'm using Atrex 19 and the ODBC driver to generate an CSV based on the "Reports -> Inventory -> Stock by Code" report.

Where can I find the query used to generate pre-defined reports?

9/29/2022 at 10:39 AM

Employee Post Marked As Answer

Stan,

Go to Options - Company Setup/Customization - Report Maintenance and on the Standard Reports tab, locate the report and Save To Disk. From the Custom Reports tab, use the Report Designer button and open the report previously saved. On the Data tab, the Primary data view contains the SQL for the base query.

Stan Paulauskas Replied

9/29/2022 at 1:23 PM

Phew, that was a mouthful, but that does answer the question. Thanks!

2 Replies

Reply to Thread

Related Knowledge Base Articles