# Lost vs. Lost and Paid

**URL:** https://forum.innovativeusers.org/t/lost-vs-lost-and-paid/2430
**Category:** Polaris
**Created:** [April 10, 2025, 5:29pm UTC](https://forum.innovativeusers.org/t/lost-vs-lost-and-paid/2430 "2025-04-10T17:29:51Z")
**Posts on this page:** 1
**Showing post:** 7

<div class="post-metadata">

### Author: ![wesochuck](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/wesochuck/32/499_2.png) [@wesochuck](https://forum.innovativeusers.org/u/wesochuck)
#### Post date: [April 16, 2025, 3:09pm UTC](https://forum.innovativeusers.org/t/lost-vs-lost-and-paid/2430/7 "2025-04-16T15:09:51Z")

</div>

> [@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:

> [@Polaris SQL/Reports Forum Notes](https://forum.innovativeusers.org/t/polaris-sql-reports-forum-notes/1771/1):
>
> **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.

---

_[View the full topic](https://forum.innovativeusers.org/t/lost-vs-lost-and-paid/2430)._