# Ignition Report Error

**URL:** <https://forum.inductiveautomation.com/t/ignition-report-error/103055>\
**Category:** Ignition\
**Tags:** ignition81, perspective, reporting\
**Created:** [February 28, 2025, 3:40pm UTC](https://forum.inductiveautomation.com/t/ignition-report-error/103055 "2025-02-28T15:40:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![prashants](https://avatars.discourse-cdn.com/v4/letter/p/a87d85/32.png) [@prashants](https://forum.inductiveautomation.com/u/prashants)\
**Post date:** [February 28, 2025, 3:40pm UTC](https://forum.inductiveautomation.com/t/ignition-report-error/103055/1 "2025-02-28T15:40:11Z")

</div>

We are having this issue with the report when opening design and preview menu in ignition.  
I am using Tag Historian Query for 3 values that is getting data from local MSSQL DB. Data Preview limit is set to 100.  
Other SQL Querys are working fine.  
Any idea why I am getting this error?

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

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/e/5e9b65167bb2495353a3e1c126e8b77877d53d76.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 28, 2025, 3:42pm UTC](https://forum.inductiveautomation.com/t/ignition-report-error/103055/2 "2025-02-28T15:42:40Z")

</div>

The preview limit is applied **after** the data comes back. You are experiencing a data retrieval timeout for the raw data itself. You will need to set up bounds for your queries that can actually be satisfied within the designer's hard 60-second limit.