Topic: Adding an extra field to the query results in a broken report
I am having a weird problem. My report is working fine, but, as soon as i try to add an extra field from the table to be used as data in the report (in MVD > button > add data > open report in designer) the report breaks and i get an error ".... is not a valid integer" (an error on a field that worked before, and has nothing to do with the field that is added.
Anyway i am trying to get the value of an id from a table in the report, could i use an SQLExecute in Fast Report?
Something like this in a Label: SQLExecute('SELECT field FROM table WHERE id = ...');
What would be the correct syntax?
Thanks in advance!