Thanks for checking. I’m sorry about the ignorant terms that I use like forms instead of reports and query instead of function or sql.
I believe I said “There is no drop down menu that I can use. I have to manually type it in.”, not “don’t get a dropdown for the fields of a query, but have to enter SQL.” For example instead of a drop down menu whee I can choose “plot” I have to type “plot”.
The SQL that I refer to is in the Content of the Data of the Report (SELECT “plot”, “initials”, “latin_name”, “Common_name”, “icon_url”, “sited”, “Habit”, “id”, “quantity” FROM “plot_plant_legend” WHERE ( “quantity” > ‘0’ AND ( “Habit” LIKE ‘Tree%’ OR “Habit” LIKE ‘Bulb%’ ) ) ORDER BY “initials” ASC, “latin_name” ASC)
I don’t understand “select your query one row higher in the dialogue like you have to select the used table.” There is no table or query with the data that I want. That is shy I have chosen “Content type” “SQL command”.
I also do not understand “set it from Field or formula to something like query in your locale” What are you refer to when you say “it”?
It seems that using fields from queries works. Using sql from queries is not working as well.
Also, I’ve noticed that copying and pasting the field works. When I edit the data field it stops working. Even if I edit it again back to the original. Ex: Data field “quantity” works after copy paste. Edit data field to “plot” and no longer works. Edit back to “quantity” and no longer works.