# Simple report query not working

**URL:** <https://forum.inductiveautomation.com/t/simple-report-query-not-working/10934>\
**Category:** Ignition\
**Created:** [December 18, 2015, 1:30am UTC](https://forum.inductiveautomation.com/t/simple-report-query-not-working/10934 "2015-12-18T01:30:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cja7928](https://avatars.discourse-cdn.com/v4/letter/c/258eb7/32.png) [@cja7928](https://forum.inductiveautomation.com/u/cja7928)\
**Post date:** [December 18, 2015, 1:30am UTC](https://forum.inductiveautomation.com/t/simple-report-query-not-working/10934/1 "2015-12-18T01:30:08Z")

</div>

I found when I create this simple query in the report designer:

```auto
SELECT TO_CHAR(trunc(sysdate)-1, 'DY MON DD') as "Date" from dual
```

the report does not process the query and becomes very unhappy. preview stalls out intermittently. when I remove the query all is well again. maybe im doing something wrong. haven’t seemed to have any issues with other queries. I just created a parameter to create the date format im looking for but thought I would let someone know the issue.

---

<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:** [December 18, 2015, 5:56pm UTC](https://forum.inductiveautomation.com/t/simple-report-query-not-working/10934/2 "2015-12-18T17:56:16Z")

</div>

I just tried this query in a report in 7.8.0, and had no problems. No errors in the console or Designer, and the query gives exactly the result I expect both in the report itself and in the data preview panel.