How do i view the SQL in Jet Essentials 2010

Jet Reports Historic Posts

September 05, 2012 21:20

None

Can anyone please help me - How do I view the SQL that is "behind" the jet report?
When i hit refresh i can click on the details while it's executing but it's not readable.
Is there a way to turn on logging or to view the actual sql statements such as a trace?
Thanks
M

Date Votes

1 comment

0

Jet Reports Historic Posts September 05, 2012 21:46

Hi M,

If you want to see the SQL being produced by a particular NL function, just add a filter for "ShowQuery=","true". So it would look like this:

=NL("Rows","Customer",,"ShowQuery=","true")
Does that work for you?

Regards,
Hughes

Comment actions Permalink

Please sign in to leave a comment.