Report Designer: how do I view the SQL query being called that used for the report?

​@bpgraves

Build it within the Report Designer. 

Hi ​@bpgraves 
As ​@ricoybanez  said, you need to build directly in the designer.
If you want to see the exact SQL query, you probably need to be pulling a database trace out of your logging, but Acumatica works through BQL, which is mostly similar to SQL, except you’re dealing with constructed view tables that Acumatica already defined.

If you want to know how the SQL of a table links together, I’d personally make a GI with the links you wanted, then use the Trace to view the executed SQL after you run it.

Otherwise, ​@TimRodman   built something he calls AugSQL which can get you more SQL access, but I’ve never used it. (ref: https://www.augforums.com/augsql/ )


If you’re just starting out and want to get an idea for how things hang together, I found a combination of the following helped my learning journey:

• Using the GI editor for a Generic Inquiry that deals with the information you want.
• Using the Report Designer for a Report that deals with the information you want.
• The DAC Schema Browser is newer than when I learnt, but a really useful tool.
• The GI Designer “Add Related Table” function is great for tracing database links.