Its my first time using the reporting module and i’ve been getting pretty stuck on what is the first step sadly.
I have a pretty straight forward table set up in an SQL database called “plantdata”
I can be queried just fine if i do an SQL query on a standard table data binding by a simple:
SELECT * FROM plantdata
However when i try and create a new “Data Source” in my report Data tab, i do the same SELECT ALL query and when i go the the Design tab i get a generic error:
I have no idea what that means, but its rather shocking to me that it cant do a simple select all query.
I’ve noticed everything in reports needs to be linked to a Datasource KEY, but there doesn’t seem to be a way to set up KEYS for Basic SQL queries…? I just want each column name to be a KEY.