Where can I see the queries used to generate reports?
Question asked by Stan Paulauskas - 9/29/2022 at 6:42 AM
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? 

2 Replies

Reply to Thread
Mark Culos Replied
Employee Post Marked As Answer

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
Phew, that was a mouthful, but that does answer the question. Thanks!

Reply to Thread