Report table query issue

Ignition
1

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
Same query in server
image

Any ideas?

2

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.

1 Like