Lost vs. Lost and Paid

[wesochuck (Wes Osborn)]

@Leenie

So I’ll use the simply reports

If you like what you see from any SimplyReports report, you can find the code it is using and then use it as Find Tool SQL following these steps:

@mhammermeister

How do I see the query that SimplyReports builds?

• Create and run a report in SimplyReports as normal. After clicking Submit, you’ll be taken to the report results page.
• On the report results page, right click and select “View Page Source” or in most browsers, press CTRL+U.
• If prompted with a “Confirm Form Resubmission” message, hit Refresh in the browser or press F5. The browser will display the HTML that generates the page.
• Press CTRL+F to search the HTML page. Search for SQLStatementHide
• Following the SQLStatementHide text, the “value” field will display the SQL query. (It starts with “Select”). Select the text and copy it.
• Paste the text into NotePad or a preferred text editor. The query will be formatted for the web, so it may be necessary to add line breaks for readability or convert certain text like date fields.