# \[BUG-14873\]Report: "Preview Limit" option

**URL:** <https://forum.inductiveautomation.com/t/bug-14873-report-preview-limit-option/27901>\
**Category:** Ignition\
**Created:** [August 30, 2019, 10:54am UTC](https://forum.inductiveautomation.com/t/bug-14873-report-preview-limit-option/27901 "2019-08-30T10:54:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\
**Post date:** [August 30, 2019, 10:54am UTC](https://forum.inductiveautomation.com/t/bug-14873-report-preview-limit-option/27901/1 "2019-08-30T10:54:05Z")

</div>

Good morning.  
In Ignition 8.0.3  
When you create a report associated with a “named query”, the “Preview Limit” option **only works** when the “Use Sample Size Limit” option of the “named query” is active.

**Named Query (“Testing” Tab)**:

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/6c71f23e0f3cf6b62bcd21be94bf3a96bdd51f83.png)

**Report (“Data” Tab):**

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/540feba1c6ea4589210970d3764c57121d5e9c4c.png)

**Report (“Preview” Tab):**  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/b010764f20674b3a457c328ec1bc3d3127c9d325.png)

In addition, the **limit of the number** of rows used is the one set in the “named query”, not in the report.

**Named Query (“Testing” Tab)**:

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4b075d39ae20cb2d24559264baea8ae8140ecb83.png)

**Report (“Data” Tab):**

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/dcf47b20e3e42e95bca5a203d3acd124810e878b.png)

**Report (“Preview” Tab):**

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/186a347dde83183035c7541df78014d628da47bf.png)

I think this is confusing. The “Preview Limit” should work independently of the “named query”.

Best Regards.

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [August 30, 2019, 2:36pm UTC](https://forum.inductiveautomation.com/t/bug-14873-report-preview-limit-option/27901/2 "2019-08-30T14:36:41Z")

</div>

Yeah, seems like we should be using the smaller of the two numbers or only the report preview limit. Thanks for catching that – I’ll make a ticket.

---

<div class="post-metadata">

**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\
**Post date:** [August 30, 2019, 5:52pm UTC](https://forum.inductiveautomation.com/t/bug-14873-report-preview-limit-option/27901/3 "2019-08-30T17:52:30Z")

</div>

I think the “Preview Limit” should work independently of the “named query” testing.

Thank you.

---

<div class="post-metadata">

**Author:** ![awalker](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/awalker/32/6874_2.png) [@awalker](https://forum.inductiveautomation.com/u/awalker)\
**Post date:** [October 30, 2019, 4:04pm UTC](https://forum.inductiveautomation.com/t/bug-14873-report-preview-limit-option/27901/4 "2019-10-30T16:04:01Z")

</div>

This issue was fixed in the 8.0.7 nightly build that was uploaded today (10/30).