# Report table query issue **URL:** \ **Category:** Ignition\ **Tags:** vision\ **Created:** [March 1, 2024, 9:53pm UTC](https://forum.inductiveautomation.com/t/report-table-query-issue/86700 "2024-03-01T21:53:13Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Brent\_Osterkamp1](https://avatars.discourse-cdn.com/v4/letter/b/ebca7d/32.png) [@Brent\_Osterkamp1](https://forum.inductiveautomation.com/u/Brent_Osterkamp1)\ **Post date:** [March 1, 2024, 9:53pm UTC](https://forum.inductiveautomation.com/t/report-table-query-issue/86700/1 "2024-03-01T21:53:13Z")
I am creating a report in Ignition 7.9. I have an sql query that pulls 3 columns of ints, they are just 0 or 1. two of the three come back correctly in a table the last one does not. It comes back as . If I create the same table in vision it works fine has the correct values. They are all ints in SQL, there are no null values. I am doing the same call @running@ as the ones that work like @Idle@ for example. I tried to pull into a dataset and show using the dataset with the same results Another anomaly it that in the report I am using the data for a chart and it shows running in the chart without issue. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/a/faf61b806cecf88b029ca7e303550cf4cf8a68fd.png) Same query in server ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/5/15c4aca131602d421a7f48d18550ecb43bf616ff.png) Any ideas? ---
**Author:** ![Brent\_Osterkamp1](https://avatars.discourse-cdn.com/v4/letter/b/ebca7d/32.png) [@Brent\_Osterkamp1](https://forum.inductiveautomation.com/u/Brent_Osterkamp1)\ **Post date:** [March 7, 2024, 5:23pm UTC](https://forum.inductiveautomation.com/t/report-table-query-issue/86700/2 "2024-03-07T17:23:32Z")
The issue was some sort of conflict with the running name in the column. I had to add the data source name. So it ended up looking like this @datasourcename.Running@ and it worked fine.